20180328
09270600
1.0
FGDC CSDGM Metadata
FALSE
scpgis.gisadmin.address_pts
002
Server=10.6.250.23; Service=sde:postgresql:10.6.250.23; Database=scpgis; User=gisadmin; Version=sde.DEFAULT
ArcSDE Connection
3532415.423650
3617600.051181
466157.443785
582677.277346
1
Projected
GCS_NAD_1983_2011
Linear Unit: Foot_US (0.304801)
NAD_1983_2011_StatePlane_Louisiana_South_FIPS_1702_Ft_US
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WKT>PROJCS["NAD_1983_2011_StatePlane_Louisiana_South_FIPS_1702_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",3280833.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-91.33333333333333],PARAMETER["Standard_Parallel_1",29.3],PARAMETER["Standard_Parallel_2",30.7],PARAMETER["Latitude_Of_Origin",28.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",6479]]</WKT><XOrigin>-124791100</XOrigin><YOrigin>-91255500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>103060</WKID><LatestWKID>6479</LatestWKID></ProjectedCoordinateSystem>
CalculateField GISDATA.DBO.ADDRESS_PTS UNITTYPE "TRLR" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS UNITTYPE "TRLR" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70030 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70031 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70039 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70047 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70057 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70066 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70068 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70070 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70078 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70079 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70080 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ZIP 70087 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 204 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 203 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 202 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 201 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 101 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 104 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 102 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 103 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS ESN 105 VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STATUS "Current" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS UNITTYPE "TRLR" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS UNITTYPE "TRLR" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADNUM "[ADDNUM]&" "& [UNITTYPE]&" "& [UNITID1]&"-"& [UNITID2]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADNUM "[ADDNUM]&" "& [UNITTYPE]&" "& [UNITID1]&" "& [UNITID2]" VB #
CalculateField ADDRESSES FULLADNUM "[ADDNUM] &" " & [UNITID1] &" " & [UNITID2]" VB #
CalculateField ADDRESSES STREETID 365 VB #
CalculateField ADDRESSES TOWNID "HNV" VB #
CalculateField ADDRESSES ADDNUM 172 VB #
CalculateField ADDRESSES STREETNAME "KELLER ST" VB #
CalculateField ADDRESSES DESIGNATIO "ST" VB #
CalculateField ADDRESSES MUNICIPALI "HAHNVILLE" VB #
CalculateField ADDRESSES STATUS "Current" VB #
CalculateField ADDRESSES POINTTYPE "BLDG CENTROID" VB #
CalculateField ADDRESSES CDIST 1 VB #
CalculateField ADDRESSES ESN 102 VB #
CalculateField ADDRESSES CAPTUREMET "GPS" VB #
CalculateField ADDRESSES FULLADDR "[ADDNUM] & [STREETNAME] & [UNITTYPE] &" "& [UNITID1] & [UNITID2]" VB #
CalculateField ADDRESSES FULLADDR "[ADDNUM] &" "& [STREETNAME] &" "& [UNITTYPE] &" "& [UNITID1] & [UNITID2]" VB #
CalculateField ADDRESSES FULLADDR "[ADDNUM] &" "& [STREETNAME] &" "& [UNITTYPE] &" "& [UNITID1] & [UNITID2]" VB #
CalculateField ADDRESSES FULLADNUM "[ADDNUM] &" "& [UNITID1] & [UNITID2]" VB #
CalculateField ADDRESSES COMPLETEAD "[FULLADDR] &", "& [MUNICIPALI] &" "& [STATE] &", "& [ZIP]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STREETNAME "FIRST ST" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection 2" FULLADDR "[ADDNUM] & " " & [STREETNAME]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection 2" FULLADDR "[ADDNUM] & " " & [STREETNAME] & " " & [UNITTYPE] & " " & [UNITID1]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [UNITTYPE] & " " & [UNITID1] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection 2" COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [UNITTYPE] & " " & [UNITID1] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" STREETNAME "1ST ST" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" FULLADDR "[ADDNUM] & " " & [STREETNAME]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" STREETNAME "SECOND ST" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" FULLADDR "[ADDNUM] & " " & [STREETNAME]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" FULLADDR "[ADDNUM] & " " & [STREETNAME] & " " & [UNITTYPE] & " " & [UNITID1]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" FULLADDR "[ADDNUM] & " " & [STREETNAME] & " " & [UNITTYPE] & " " & [UNITID1]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [UNITTYPE] & " " & [UNITID1][MUNICIPALI] & " " & [STATE]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [UNITTYPE] & " " & [UNITID1] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STREETNAME "3RD ST" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " " & [STREETNAME] " VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STREETNAME "4TH ST" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " " & [STREETNAME]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STREETNAME "5TH ST" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " " & [STREETNAME]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[ADDNUM] & " " & [STREETNAME] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " " & [STREETNAME] " VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " " & [STREETNAME]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & "AUTIN LN"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " AUTIN LN"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " AVE OF OAKS"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[FULLADDR] & "E"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " BAYOU ESTATES SOUTH"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & "BEAU PL BLVD"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " BEAU PL BLVD"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " BELL ORMOND CIR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[STREETNAME] & "E"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[FULLADDR] & "E"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[FULLADDR] & "E"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " CATHY ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " CRISTINA CT"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " DELL DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " D'EVEREAUX DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " DUFRENE LOOP"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " E OAKLAND DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " GIACOMO DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " GIACOMO DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " E OAKLAND DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " GOODHOPE ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " JB GREEN RD"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " JAMES DR EAST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " JAMES DR WEST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " KERRY'S POINTE EAST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " KERRY'S POINTE WEST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " KIRK ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " LOUIS THE FIRST ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " LYNN DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " LYNN ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " NORTHBEND"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " OAKLAWN RIDGE LN"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ORMOND TRACE"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " PM LN"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " PAUL FREDERICK DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " RUE SYDNEY"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " SCHEXNAYDRE LN"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. ANTHONY ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. CHARLES BLVD"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. CHARLES PL"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. CHARLES ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. JOE ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. JOHN ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. JUDE ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. MARIA ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. MARKS AVE"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. NICHOLAS ST"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. ROSE AVE"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " VAN'S LN"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " VIC'S LN"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " W JAMES DR"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" COMPLETEAD "[FULLADDR] & " " & [MUNICIPALI] &" " & [STATE]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" COMPLETEAD "[FULLADDR] & " " & [MUNICIPALI] &" " & [STATE]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " NORTH BEND"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " ST. MARK AVE"" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STATUS Retired VB #
CalculateField GISDATA.DBO.ADDRESS_PTS TOWNID "LUL" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS MUNICIPALI "LULING" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STATE "LA" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " " & [STREETNAME]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & "COVE POINTE DR"" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " COVE POINTE DR"" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[FULLADDR] &" " & [MUNICIPALI] &" " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[FULLADDR] &" COVE GLEN LN" " VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] &" COVE GLEN LN" " VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[FULLADDR] &" LULING " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " MONARCH COVE LN"" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS COMPLETEAD "[FULLADDR] &" LULING " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS TOWNID "DHN" VB #
CalculateField "ASHTON PLANTATION PHASE 2A ADDRESSES" FULLADNUM [ADDNUM] VB #
CalculateField "DESTREHAN PLANTATION ESTATES ADDRESSES" STREETID "806" VB #
CalculateField "DESTREHAN PLANTATION ESTATES ADDRESSES" SITEADDID "[TOWNID] &"-"& [STREETID]&"-"& [ADDNUM]" VB #
CalculateField "ASHTON PLANTATION PHASE 2A ADDRESSES" STREETID "807" VB #
CalculateField "ASHTON PLANTATION PHASE 2A ADDRESSES" STREETID "808" VB #
CalculateField "ASHTON PLANTATION PHASE 2A ADDRESSES" STREETID "809" VB #
CalculateField "ASHTON PLANTATION PHASE 2A ADDRESSES" SITEADDID "[TOWNID] &"-"& [STREETID]&"-"& [ADDNUM]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" FULLADDR "[ADDNUM] & " SCHOOL HOUSE RD"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection selection" COMPLETEAD "[FULLADDR] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STREETNAME "SCHOOLHOUSE" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS STREETNAME "SCHOOLHOUSE RD" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS FULLADDR "ADDNUM + "SCHOOLHOUSE RD"" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" FULLADDR "[ADDNUM] & " " & [STREETNAME]" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" FULLADDR "[ADDNUM] & " " & "SCHOOL HOUSE RD"" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS PI_CODE "410803700003" VB #
CalculateField GISDATA.DBO.ADDRESS_PTS PI_CODE "410803700003" VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" PI_CODE " " VB #
CalculateField "GISDATA.DBO.ADDRESS_PTS selection" PI_CODE " " VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADDR Replace( [FULLADDR], "DUFRENE", "DUFRENSE") VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS COMPLETEAD Replace( [COMPLETEAD] , "DUFRENE", "DUFRENSE") VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS ZBA_CASE "87-31" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS ZBA_HYPERLINK "http://www.scpgis.com/zba/87-31.pdf" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS ZBA_HYPERLINK ""http://www.scpgis.com/zba/" & [ZBA_CASE] &".pdf"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS ZBA_HYPERLINK "http://www.scpgis.com/zba/85-44.pdf" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS ZBA_CASE "85-44" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS ZBA_HYPERLINK "http://www.scpgis.com/zba/93-11.pdf" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS ZBA_CASE "93-11" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection 2" ZBA_HYPERLINK Replace( [ZBA_HYPERLINK], "http", "https") VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection 2" ZBA_HYPERLINK Replace( [ZBA_HYPERLINK], "http", "https") VB #
CalculateField "Boundaries & Transportation\Addresses" ALTUNITID "[UNITID1] & [UNITID2]" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" FULLADDR Replace([FULLADDR], "OLD SPANISH TRL", "LA 631") VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" FULLADDR Replace([FULLADDR], "OLD HWY 90", "LA 631") VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" COMPLETEAD Replace( [COMPLETEAD], "OLD HWY 90", "LA 631") VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" COMPLETEAD Replace( [COMPLETEAD], "OLD SPANISH TRL", "LA 631") VB #
CalculateField "Addresses by Status" STATUS "Current" VB #
CalculateField "Addresses by Status" STATUS "Current" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" PI_CODE " " VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADNUM [ADDNUM] VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & "MOONLIGHT COVE LN"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " MOONLIGHT COVE LN"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " MOONLIGHT COVE LN"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & "ENGLE COVE CT"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " ENGLE COVE CT"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS COMPLETEAD "[FULLADDR] & " " & [MUNICIPALI]" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS COMPLETEAD "[FULLADDR] & " " &"LULING"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS COMPLETEAD "[COMPLETEAD] & " LA"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS RID "W7-F10-STR-3821" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS RID "W7-F10-STR-3818" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS RID "W7-F10-STR-3819" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADNUM [ADDNUM] VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection selection" SITEADDID "[SITEADDID] & "-" & [STREETID] & "-" & [ADDNUM]" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection selection" ET_ID "[TOWNID] & "-" & [STREETID] & "-" & [ADDNUM]" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection selection" SITEADDID "[TOWNID] & "-" & [STREETID] & "-" & [ADDNUM]" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection selection" STREETID "813" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection selection" SITEADDID "[TOWNID] & "-" & [STREETID] & "-" & [ADDNUM]" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " " & "BELLE ORMOND CIR"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS COMPLETEAD "[FULLADDR] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS FULLADDR "[ADDNUM] & " ST. PAUL PL"" VB #
CalculateField SCPDATA.DBO.ADDRESS_PTS COMPLETEAD "[FULLADDR] & " " & [MUNICIPALI] & " " & [STATE]" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" COMPLETEAD "[ADDNUM] & " " & "CHRISTINA CT " & [MUNICIPALI] + " " & [STATE]" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" FULLADNUM Left( [FULLADDR],3 ) VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" ADDNUM Left( [FULLADDR],3 ) VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" COMPLETEAD "[FULLADDR] & " HAHNVILLE LA"" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" STREETID "[TOWNID] & "-" & " " & "-" & [ADDNUM]" VB #
CalculateField "SCPDATA.DBO.ADDRESS_PTS selection" SITEADDID "[TOWNID] & "-" & " " & "-" & [ADDNUM]" VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" fulladnum [addnum] VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" completead "[fulladdr] & " " & [municipali] & " " & [state]" VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" completead "[fulladdr] & " " & "HAHNVILLE" & " " & [state]" VB #
CalculateField scpdata.lmartinez.address_pts fulladdr Left( [completead],19 ) VB #
CalculateField scpdata.lmartinez.address_pts fulladdr Left( [completead],18 ) VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" fulladdr Replace( [fulladdr], "ST" , "LN" ) VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" completead Replace( [completead], "ST" , "LN" ) VB #
CalculateField scpdata.lmartinez.address_pts zba_case "IDA CORRECTI" VB #
CalculateField scpdata.lmartinez.address_pts x " "
VB #
CalculateField scpdata.lmartinez.address_pts completead "[fulladdr] & " AMA LA"" VB #
CalculateField scpdata.lmartinez.address_pts fulladdr UCase( [fulladdr] ) VB #
CalculateField scpdata.lmartinez.address_pts completead UCase( [completead] ) VB #
CalculateField scpdata.lmartinez.address_pts siteaddid " " VB #
CalculateField "MISSING SITEADDID" townid "BTE" VB #
CalculateField "MISSING SITEADDID" streetid "495" VB #
CalculateField "MISSING STREET ID" streetid "814" VB #
CalculateField "MISSING STREET ID" streetid "818" VB #
CalculateField "MISSING STREET ID" siteaddid ""HNV-" & [streetid] & "-" & [addnum]" VB #
CalculateField "MISSING STREET ID" siteaddid "[townid] &"-" & [streetid] & "-" & [addnum]" VB #
CalculateField "MISSING SITEADDID selection" siteaddid "[townid] & "-" & [streetid] & "-" & [addnum]" VB #
CalculateField "MISSING SITEADDID selection" fulladdr "[addnum] & " " & [streetname] & "-" & [unittype] & "-" & [unitid1]" VB #
CalculateField "MISSING SITEADDID selection" fulladdr "[addnum] & " " & [streetname] & "-" & [unittype] & "-" & [unitid1]" VB #
CalculateField "MISSING SITEADDID selection" fulladdr "[addnum] & "MITZI LN" & [unittype] & " " & [unitid1]" VB #
CalculateField "MISSING SITEADDID selection" fulladdr "[addnum] & " MITZI LN" & [unittype] & " " & [unitid1]" VB #
CalculateField "MISSING SITEADDID selection" fulladdr "[addnum] & " MITZI LN " & [unittype] & " " & [unitid1]" VB #
CalculateField "MISSING SITEADDID selection" completead "[addnum] & " MITZI LN " & [unittype] & " " & [unitid1] & " BOUTTE LA " " VB #
CalculateField "scpdata.lmartinez.address_pts selection" streetid "538" VB #
CalculateField "scpdata.lmartinez.address_pts selection" siteaddid "BTE-538-14485" VB #
CalculateField "scpdata.lmartinez.address_pts selection" fulladdr "[addnum] & " LA 631 " & [unittype] & " " & [altunitid]" VB #
CalculateField "scpdata.lmartinez.address_pts selection" fulladdr "[addnum] & " LA 631 " & [unittype] & " " & [altunitid]" VB #
CalculateField "scpdata.lmartinez.address_pts selection" fulladdr "[addnum] & " LA 631 " & [unittype] & " " & [altunitid]" VB #
CalculateField "scpdata.lmartinez.address_pts selection" completead "[fulladdr] & " BOUTTE LA"" VB #
CalculateField "scpdata.lmartinez.address_pts selection" rid "W4-D13-STR-" VB #
CalculateField "scpdata.lmartinez.address_pts selection" rid "W4-D13-STR-2562" VB #
CalculateField scpdata.lmartinez.address_pts rid " " VB #
CalculateField scpdata.lmartinez.address_pts rid Replace( [rid], "E14","E13" ) VB #
CalculateField scpdata.lmartinez.address_pts rid Replace( [rid], "E14","E13" ) VB #
CalculateField scpdata.lmartinez.address_pts streetid " " VB #
CalculateField scpdata.lmartinez.address_pts designatio "CT" VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" fulladnum [addnum] VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" fulladdr "[addnum] & " " & [streetname] " VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" fulladdr "[addnum] & " SOPHIA DR"" VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" fulladdr "[addnum] & " OLIVIA DR"" VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" completead "[fulladdr] & " LULING LA"" VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" siteaddid "[streetid] & "-" & [townid]& "-" & [addnum]" VB #
CalculateField "SCP DATA \SCPDATA.DBO.ADDRESS_PTS" siteaddid "[townid] & "-" & [streetid]& "-" & [addnum]" VB #
CalculateField scpdata.lmartinez.address_pts fulladnum " "
VB #
CalculateField scpdata.lmartinez.address_pts rid "W1-E5-STR-3838" VB #
CalculateField scpdata.lmartinez.address_pts rid "W1-D5-STR-3832" VB #
CalculateField scpdata.lmartinez.address_pts rid "W1-D6-STR-3840" VB #
CalculateField scpdata.lmartinez.address_pts rid "W7-G11-STR-3813" VB #
CalculateField scpdata.lmartinez.address_pts fulladdr "[addnum] & " " & [streetname]" VB #
CalculateField scpdata.lmartinez.address_pts fulladdr "[addnum] & " OLIVIA DR"" VB #
CalculateField scpdata.lmartinez.address_pts completead "[fulladdr] & " " & [municipali] & " " & [state]" VB #
CalculateField scpdata.lmartinez.address_pts completead "[fulladdr] & " " & "LULING" & " " & [state]" VB #
CalculateField scpdata.lmartinez.address_pts fulladnum [addnum] VB #
CalculateField scpdata.lmartinez.address_pts rid "W2-H12-STR-3847" VB #
CalculateField scpdata.lmartinez.address_pts siteaddid "[siteaddid] & [addnum]" VB #
CalculateField scpdata.lmartinez.address_pts rid "W2-H12-STR-3849" VB #
CalculateField scpdata.lmartinez.address_pts rid "W2-H12-STR-3847" VB #
CalculateField scpdata.lmartinez.address_pts rid "W2-H12-STR-3848" VB #
CalculateField scpdata.lmartinez.address_pts pi_code "760469A1A6E1" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField scpdata.lmartinez.address_pts fulladdr "[fulladdr] & " PRETTY ACRES AVE"" VB #
CopyFeatures "E:\luis\projects\scpgis\scpdata (old).sde\scpdata.lmartinez.addresses\scpdata.lmartinez.address_pts" "E:\luis\projects\scpgis\scpgis (new).sde\scpgis.gisadmin.addresses\scpgis.gisadmin.address_pts" # # # #
20240124
14472400
20240124
14472400
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 20348) ; Esri ArcGIS 13.1.3.41833
Address Map_MIL1
1
-90.540273
-90.268346
30.099849
29.777551
Addresses
Enterprise Geodatabase Feature Class
dataset
EPSG
8.2.10(10.3.1)
0
Simple
FALSE
0
TRUE
FALSE
scpgis.gisadmin.address_pts
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
ET_ID
ET_ID
Integer
4
10
0
SITEADDID
SITEADDID
String
254
0
0
STREETID
STREETID
String
254
0
0
TOWNID
TOWNID
String
254
0
0
PREADDRNUM
PREADDRNUM
String
254
0
0
ADDNUM
ADDNUM
Integer
4
10
0
ADDRNUMSUF
ADDRNUMSUF
String
254
0
0
ADDRRANGE
ADDRRANGE
String
254
0
0
UNITTYPE
UNITTYPE
String
254
0
0
UNITID1
UNITID1
String
254
0
0
UNITID2
UNITID2
String
254
0
0
ALTUNITTYP
ALTUNITTYP
String
254
0
0
ALTUNITID
ALTUNITID
String
254
0
0
STREETNAME
STREETNAME
String
254
0
0
FULLADDR
FULLADDR
String
254
0
0
DESIGNATIO
DESIGNATIO
String
254
0
0
MUNICIPALI
MUNICIPALI
String
254
0
0
STATE
STATE
String
254
0
0
ZIP
ZIP
Integer
4
10
0
COMPLETEAD
COMPLETEAD
String
254
0
0
STATUS
STATUS
String
254
0
0
POINTTYPE
POINTTYPE
String
254
0
0
MSAG
MSAG
String
254
0
0
CDIST
CDIST
SmallInteger
2
5
0
ESN
ESN
SmallInteger
2
5
0
CAPTUREMET
CAPTUREMET
String
254
0
0
PI_CODE
PI_CODE
String
254
0
0
X
X
Double
8
38
8
Y
Y
Double
8
38
8
FULLADNUM
FULLADNUM
String
20
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
RID
RID
String
20
0
0
ZBA_CASE
ZBA CASE
String
12
0
0
ZBA_HYPERLINK
ZBA HYPERLINK
String
50
0
0
ZBA_Comments
ZBA Comments
String
255
0
0
ec_crs
Elevation Certificate
String
250
0
0
roadid
roadid
String
12
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
20240124
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiql9fRWEIkkWV8naFijLkn6Cs7z
tav32wwpYQf89JsPIfoo4H41Dmk7dSXJLQ2S6hgpYAnoM8mn1mWejW1pMbgmSa4brLKxJ/D0rTpx
be41fqFFFFUMKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiimspZCASpIwCO
1ADZJEiQvIyqo6ljgVnW+spd3fkW1vPIgJDzbNqLj3PX8KjTQY5X8y/nlvGzkLIcIP8AgI4rWRFR
AiAKoGAB2rNc7fYn3n5D6KKK0KCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACs651a1tpRDv8AMuD0ij+Zv/rfjSXl
hcXs2DevFbFcNFGoBb/gXXFT2mn2tgmy2hSMdyByfqah8zdloTq2U0TVLi8WR5Ut7RSGEYXLt7E1
oXN1DZwNNPIEjXqTWbPqGoTXD21hZMu0kNcXI2oP90dWp8GiQpcm6uZJLqc95WJVf91egqE3tElN
9CzYX8eoRNJFHIsYOAzrjd7irtIAAMDgUtaq6WpaCiiimMKKqXt/bafD5tzKsadBnqT7DvTrS6W8
tlmWORA3QSLtP1xS5le3UV1exZooopjCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigArFlu9Turh4bS1EEakhri4784+VR1/Gtqipl
FvqJq5lWujW9vO1xI0lxcN/y0mYtjvgA8AVq0UU4xUVZAklsFFFFMYUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRR
QAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRR
QAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFFFFAH//Z