20240403
09072900
1.0
FALSE
DefineProjection Addresses_exported4 PROJCS["NAD_1983_HARN_StatePlane_Ohio_North_FIPS_3401_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",40.43333333333333],PARAMETER["Standard_Parallel_2",41.7],PARAMETER["Latitude_Of_Origin",39.66666666666666],UNIT["Foot_US",0.3048006096012192]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Meter",1.0]]
ExportFeatures Addresses_exported4 C:\Users\jsrougeaux\AppData\Local\Temp\ArcGISProTemp28956\Untitled\SQLServer-GIS2SQL-GISData(sa).sde\GISData.DBO.Address\GISData.DBO.Address_April2024 # NOT_USE_ALIAS "XMIN "XMIN" true true false 25 Double 15 24,First,#,Addresses_exported4,XMIN,-1,-1;XMAX "XMAX" true true false 25 Double 15 24,First,#,Addresses_exported4,XMAX,-1,-1;YMIN "YMIN" true true false 25 Double 15 24,First,#,Addresses_exported4,YMIN,-1,-1;YMAX "YMAX" true true false 25 Double 15 24,First,#,Addresses_exported4,YMAX,-1,-1;ID "ID" true true false 12 Double 0 12,First,#,Addresses_exported4,ID,-1,-1;FEATUREID "FEATUREID" true true false 12 Double 0 12,First,#,Addresses_exported4,FEATUREID,-1,-1;HOUSENUM "HOUSENUM" true true false 12 Double 0 12,First,#,Addresses_exported4,HOUSENUM,-1,-1;UNITNUM "UNITNUM" true true false 12 Text 0 0,First,#,Addresses_exported4,UNITNUM,0,11;LHN "LHN" true true false 120 Text 0 0,First,#,Addresses_exported4,LHN,0,119;STRUC_TYPE "STRUC_TYPE" true true false 12 Double 0 12,First,#,Addresses_exported4,STRUC_TYPE,-1,-1;POI_NAME "POI_NAME" true true false 75 Text 0 0,First,#,Addresses_exported4,POI_NAME,0,74;HNRANGE "HNRANGE" true true false 32 Text 0 0,First,#,Addresses_exported4,HNRANGE,0,31;UNITEXTRA "UNITEXTRA" true true false 64 Text 0 0,First,#,Addresses_exported4,UNITEXTRA,0,63;BUILDING "BUILDING" true true false 16 Text 0 0,First,#,Addresses_exported4,BUILDING,0,15;FLOOR "FLOOR" true true false 8 Text 0 0,First,#,Addresses_exported4,FLOOR,0,7;SEGID "SEGID" true true false 12 Double 0 12,First,#,Addresses_exported4,SEGID,-1,-1;ST_PREFIX "ST_PREFIX" true true false 4 Text 0 0,First,#,Addresses_exported4,ST_PREFIX,0,3;ST_NAME "ST_NAME" true true false 75 Text 0 0,First,#,Addresses_exported4,ST_NAME,0,74;ST_TYPE "ST_TYPE" true true false 16 Text 0 0,First,#,Addresses_exported4,ST_TYPE,0,15;ST_SUFFIX "ST_SUFFIX" true true false 4 Text 0 0,First,#,Addresses_exported4,ST_SUFFIX,0,3;ST_SUFFIX2 "ST_SUFFIX2" true true false 10 Text 0 0,First,#,Addresses_exported4,ST_SUFFIX2,0,9;LSN "LSN" true true false 120 Text 0 0,First,#,Addresses_exported4,LSN,0,119;MUNI "MUNI" true true false 50 Text 0 0,First,#,Addresses_exported4,MUNI,0,49;VILLAGE "VILLAGE" true true false 50 Text 0 0,First,#,Addresses_exported4,VILLAGE,0,49;COUNTY "COUNTY" true true false 24 Text 0 0,First,#,Addresses_exported4,COUNTY,0,23;STATE "STATE" true true false 2 Text 0 0,First,#,Addresses_exported4,STATE,0,1;FIPSCODE "FIPSCODE" true true false 5 Text 0 0,First,#,Addresses_exported4,FIPSCODE,0,4;ZIPCODE "ZIPCODE" true true false 10 Text 0 0,First,#,Addresses_exported4,ZIPCODE,0,9;USPS_CITY "USPS_CITY" true true false 50 Text 0 0,First,#,Addresses_exported4,USPS_CITY,0,49;SUBDIV "SUBDIV" true true false 50 Text 0 0,First,#,Addresses_exported4,SUBDIV,0,49;COMM "COMM" true true false 50 Text 0 0,First,#,Addresses_exported4,COMM,0,49;ALTPREFIX "ALTPREFIX" true true false 10 Text 0 0,First,#,Addresses_exported4,ALTPREFIX,0,9;ALTNAME "ALTNAME" true true false 75 Text 0 0,First,#,Addresses_exported4,ALTNAME,0,74;ALTTYPE "ALTTYPE" true true false 20 Text 0 0,First,#,Addresses_exported4,ALTTYPE,0,19;ALTSUFFIX "ALTSUFFIX" true true false 10 Text 0 0,First,#,Addresses_exported4,ALTSUFFIX,0,9;ALTSUFFIX2 "ALTSUFFIX2" true true false 10 Text 0 0,First,#,Addresses_exported4,ALTSUFFIX2,0,9;ALSN "ALSN" true true false 120 Text 0 0,First,#,Addresses_exported4,ALSN,0,119;TSSEGID "TSSEGID" true true false 12 Double 0 12,First,#,Addresses_exported4,TSSEGID,-1,-1;ROADTYPE "ROADTYPE" true true false 4 Text 0 0,First,#,Addresses_exported4,ROADTYPE,0,3;ROADNUMBER "ROADNUMBER" true true false 20 Text 0 0,First,#,Addresses_exported4,ROADNUMBER,0,19;DOT_ID "DOT_ID" true true false 16 Text 0 0,First,#,Addresses_exported4,DOT_ID,0,15;SIDE "SIDE" true true false 12 Double 0 12,First,#,Addresses_exported4,SIDE,-1,-1;ABSSIDE "ABSSIDE" true true false 2 Text 0 0,First,#,Addresses_exported4,ABSSIDE,0,1;PT_LEN "PT_LEN" true true false 25 Double 15 24,First,#,Addresses_exported4,PT_LEN,-1,-1;MPVAL "MPVAL" true true false 25 Double 15 24,First,#,Addresses_exported4,MPVAL,-1,-1;SOURCE "SOURCE" true true false 12 Double 0 12,First,#,Addresses_exported4,SOURCE,-1,-1;NOTE "NOTE" true true false 100 Text 0 0,First,#,Addresses_exported4,NOTE,0,99;LANDMARK "LANDMARK" true true false 255 Text 0 0,First,#,Addresses_exported4,LANDMARK,0,254;HN_ANOMALY "HN_ANOMALY" true true false 12 Double 0 12,First,#,Addresses_exported4,HN_ANOMALY,-1,-1;ERRORCOUNT "ERRORCOUNT" true true false 12 Double 0 12,First,#,Addresses_exported4,ERRORCOUNT,-1,-1;ISMARKER "ISMARKER" true true false 1 Short 0 0,First,#,Addresses_exported4,ISMARKER,-1,-1" #
ExportFeatures C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024 C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address_Planning\GISData.DBO.AddressPoints_Planning # NOT_USE_ALIAS "XMIN "XMIN" true true false 8 Double 15 24,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,XMIN,-1,-1;XMAX "XMAX" true true false 8 Double 15 24,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,XMAX,-1,-1;YMIN "YMIN" true true false 8 Double 15 24,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,YMIN,-1,-1;YMAX "YMAX" true true false 8 Double 15 24,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,YMAX,-1,-1;ID "ID" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ID,-1,-1;FEATUREID "FEATUREID" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,FEATUREID,-1,-1;HOUSENUM "HOUSENUM" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,HOUSENUM,-1,-1;UNITNUM "UNITNUM" true true false 12 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,UNITNUM,0,11;LHN "LHN" true true false 120 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,LHN,0,119;STRUC_TYPE "STRUC_TYPE" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,STRUC_TYPE,-1,-1;POI_NAME "POI_NAME" true true false 75 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,POI_NAME,0,74;HNRANGE "HNRANGE" true true false 32 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,HNRANGE,0,31;UNITEXTRA "UNITEXTRA" true true false 64 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,UNITEXTRA,0,63;BUILDING "BUILDING" true true false 16 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,BUILDING,0,15;FLOOR "FLOOR" true true false 8 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,FLOOR,0,7;SEGID "SEGID" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,SEGID,-1,-1;ST_PREFIX "ST_PREFIX" true true false 4 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ST_PREFIX,0,3;ST_NAME "ST_NAME" true true false 75 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ST_NAME,0,74;ST_TYPE "ST_TYPE" true true false 16 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ST_TYPE,0,15;ST_SUFFIX "ST_SUFFIX" true true false 4 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ST_SUFFIX,0,3;ST_SUFFIX2 "ST_SUFFIX2" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ST_SUFFIX2,0,9;LSN "LSN" true true false 120 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,LSN,0,119;MUNI "MUNI" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,MUNI,0,49;VILLAGE "VILLAGE" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,VILLAGE,0,49;COUNTY "COUNTY" true true false 24 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,COUNTY,0,23;STATE "STATE" true true false 2 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,STATE,0,1;FIPSCODE "FIPSCODE" true true false 5 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,FIPSCODE,0,4;ZIPCODE "ZIPCODE" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ZIPCODE,0,9;USPS_CITY "USPS_CITY" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,USPS_CITY,0,49;SUBDIV "SUBDIV" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,SUBDIV,0,49;COMM "COMM" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,COMM,0,49;ALTPREFIX "ALTPREFIX" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ALTPREFIX,0,9;ALTNAME "ALTNAME" true true false 75 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ALTNAME,0,74;ALTTYPE "ALTTYPE" true true false 20 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ALTTYPE,0,19;ALTSUFFIX "ALTSUFFIX" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ALTSUFFIX,0,9;ALTSUFFIX2 "ALTSUFFIX2" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ALTSUFFIX2,0,9;ALSN "ALSN" true true false 120 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ALSN,0,119;TSSEGID "TSSEGID" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,TSSEGID,-1,-1;ROADTYPE "ROADTYPE" true true false 4 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ROADTYPE,0,3;ROADNUMBER "ROADNUMBER" true true false 20 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ROADNUMBER,0,19;DOT_ID "DOT_ID" true true false 16 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,DOT_ID,0,15;SIDE "SIDE" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,SIDE,-1,-1;ABSSIDE "ABSSIDE" true true false 2 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ABSSIDE,0,1;PT_LEN "PT_LEN" true true false 8 Double 15 24,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,PT_LEN,-1,-1;MPVAL "MPVAL" true true false 8 Double 15 24,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,MPVAL,-1,-1;SOURCE "SOURCE" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,SOURCE,-1,-1;NOTE "NOTE" true true false 100 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,NOTE,0,99;LANDMARK "LANDMARK" true true false 255 Text 0 0,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,LANDMARK,0,254;HN_ANOMALY "HN_ANOMALY" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,HN_ANOMALY,-1,-1;ERRORCOUNT "ERRORCOUNT" true true false 8 Double 0 12,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ERRORCOUNT,-1,-1;ISMARKER "ISMARKER" true true false 2 Short 0 5,First,#,C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\SQLServer-GIS3SQL-GISData.sde\GISData.DBO.Address\GISData.DBO.Address_April2024,ISMARKER,-1,-1" #
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence>
ImportAttributeRules GISData.DBO.AddressPoints_Planning C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\AddressPointsAttributeRules2.CSV
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>PL_AppNum</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_PIN</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_Applicant</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_DateIssued</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_Notes</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_DateNotified</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_AssignedBy</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_Acreage</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_AmountPaid</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PL_PaymentMethod</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Populate PL_PIN</rule_name><rule_type>CALCULATION</rule_type><expression>// Create reference to the Parcels layer in the map
var zones = FeatureSetByName($datastore,"GISData.DBO.Parcels_Online",["PIN"],true)
// Get a feature set of zones that intersect the address
var intersectingZones = Intersects(zones, Geometry($feature))
// Select the first record in the feature set
var matchedZone = First(intersectingZones)
// Return the PIN value of the selected zone
return IIf(IsEmpty(matchedZone), null, matchedZone.PIN);</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Populate the PL_PIN field with the from Parcels</rule_description><field_name>PL_PIN</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Populate PL_PIN</rule_name><evaluation_order>20</evaluation_order></ReorderAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Populate Jurisdiction</rule_name><rule_description>Populate the COMM field with the jurisdiction</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>// Create reference to the Jurisdictions layer in the map
var zones = FeatureSetByName($datastore,"GISData.DBO.Jurisdictions",["Name"],true)
// Get a feature set of zones that intersect the address
var intersectingZones = Intersects(zones, Geometry($feature))
// Select the first record in the feature set
var matchedZone = First(intersectingZones)
// Return the Jurisdictions value of the selected zone
return IIf(IsEmpty(matchedZone), null, matchedZone.Name);</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>PL_StreetName</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Populate PL_Acreage</rule_name><rule_type>CALCULATION</rule_type><expression>// Create reference to the Parcels layer in the map
var zones = FeatureSetByName($datastore,"GISData.DBO.Parcels_Online",["Acreage"],true)
// Get a feature set of zones that intersect the address
var intersectingZones = Intersects(zones, Geometry($feature))
// Select the first record in the feature set
var matchedZone = First(intersectingZones)
// Return the PIN value of the selected zone
return IIf(IsEmpty(matchedZone), null, matchedZone.Acreage);</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Populate the PL_Acreage field from Parcels</rule_description><field_name>PL_Acreage</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Populate PL_Acreage</rule_name><evaluation_order>21</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Populate PL_StreetName</rule_name><rule_type>CALCULATION</rule_type><expression>// Calculate the full address by concatenating several street/address field values
// List the fields to combine
var parts = [$feature.ST_PREFIX,$feature.ST_NAME, $feature.ST_TYPE, $feature.ST_SUFFIX, $feature.ST_SUFFIX2];
// Loop through the address parts, if not null or empty add them to a new array
var filteredparts = [];
for (var i in parts) {
var value = parts[i];
if (IsEmpty(value)) continue;
filteredparts[Count(filteredparts)] = value
}
// Concatenate with a space
return Trim(Concatenate(filteredparts, " "));</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Populate the PL_StreetName field with full street name</rule_description><field_name>PL_StreetName</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Populate PL_StreetName</rule_name><evaluation_order>22</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Populate PL_DateIssud</rule_name><rule_type>CALCULATION</rule_type><expression>$feature.created_date</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Populate the PL_DateIssued field with edit date</rule_description><field_name>PL_DateIssued</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Populate PL_DateIssud</rule_name><evaluation_order>23</evaluation_order></ReorderAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Populate PL_PIN</rule_name><rule_description>Populate the PL_PIN field from Parcels</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>// Create reference to the Parcels layer in the map
var zones = FeatureSetByName($datastore,"GISData.DBO.Parcels_Online",["PIN"],true)
// Get a feature set of zones that intersect the address
var intersectingZones = Intersects(zones, Geometry($feature))
// Select the first record in the feature set
var matchedZone = First(intersectingZones)
// Return the PIN value of the selected zone
return IIf(IsEmpty(matchedZone), null, matchedZone.PIN);</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Populate LHN</rule_name><rule_description>Populate LHN field with the full house number including unit number</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>// Calculate the full address by concatenating several street/address field values
// First determine if there is unit information
// If there is, add 'Unit' prefix to it
var subaddress = null;
if (!IsEmpty($feature.UNITNUM)){
subaddress = '';
} else {
subaddress = 'Unit ' + $feature.UNITNUM;
}
// List the fields to combine
var parts = [$feature.HOUSENUM, subaddress];
// Loop through the address parts, if not null or empty add them to a new array
var filteredparts = [];
for (var i in parts) {
var value = parts[i];
if (IsEmpty(value)) continue;
filteredparts[Count(filteredparts)] = value
}
// Concatenate with a space
return Concatenate(filteredparts, " ");</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Populate LSN field</rule_name><rule_description>Populate LSN field with the full street address</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>// Calculate the full address by concatenating several street/address field values
// First determine if there is unit information
// If there is, add 'Unit' prefix to it
var subaddress = null;
if (!IsEmpty($feature.UNITNUM)){
subaddress = '';
} else {
subaddress = 'Unit ' + $feature.UNITNUM;
}
// List the fields to combine
var parts = [$feature.HOUSENUM, $feature.ST_PREFIX,$feature.ST_NAME, $feature.ST_TYPE, $feature.ST_SUFFIX, $feature.ST_SUFFIX2, subaddress];
// Loop through the address parts, if not null or empty add them to a new array
var filteredparts = [];
for (var i in parts) {
var value = parts[i];
if (IsEmpty(value)) continue;
filteredparts[Count(filteredparts)] = value
}
// Concatenate with a space
return Trim(Concatenate(filteredparts, " "));</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Populate LSN field</rule_name><rule_description>Populate LSN field with the full street address</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>// Calculate the full address by concatenating several street/address field values
// First determine if there is unit information
// If there is, add 'Unit' prefix to it
var subaddress = null;
if (!IsEmpty($feature.UNITNUM)){
subaddress = '';
} else {
subaddress = 'Unit ' + $feature.UNITNUM;
}
// List the fields to combine
var parts = [$feature.HOUSENUM, $feature.ST_PREFIX,$feature.ST_NAME, $feature.ST_TYPE, $feature.ST_SUFFIX, $feature.ST_SUFFIX2, subaddress];
// Loop through the address parts, if not null or empty add them to a new array
var filteredparts = [];
for (var i in parts) {
var value = parts[i];
if (IsEmpty(value)) continue;
filteredparts[Count(filteredparts)] = value
}
// Concatenate with a space
var lsnAddress = Trim(Concatenate(filteredparts, " "));
return Replace(lsnAddress,' ',' ');
//return Trim(Concatenate(filteredparts, " "));</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Populate LSN field</rule_name><rule_description>Populate LSN field with the full street address</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>// Calculate the full address by concatenating several street/address field values
// First determine if there is unit information
// If there is, add 'Unit' prefix to it
var subaddress = null;
if (!IsEmpty($feature.UNITNUM)){
subaddress = '';
} else {
subaddress = 'Unit ' + $feature.UNITNUM;
}
// List the fields to combine
var parts = [$feature.HOUSENUM, $feature.ST_PREFIX,$feature.ST_NAME, $feature.ST_TYPE, $feature.ST_SUFFIX, $feature.ST_SUFFIX2, subaddress];
// Loop through the address parts, if not null or empty add them to a new array
var filteredparts = [];
for (var i in parts) {
var value = parts[i];
if (IsEmpty(value)) continue;
filteredparts[Count(filteredparts)] = value
}
// Concatenate with a space
var lsnAddress = Trim(Concatenate(filteredparts, " "));
lsnAddress = Replace(lsnAddress,' ',' ');
return Replace(lsnAddress,' ',' ');
//return Trim(Concatenate(filteredparts, " "));</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.2.0'><FeatureDataset>GISData.DBO.Address_Planning</FeatureDataset><WorkspaceConnectionString>SERVER=GIS3SQL;INSTANCE=sde:sqlserver:GIS3SQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS3SQL;DATABASE=GISData;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISData.DBO.AddressPoints_Planning</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Populate PL_DateIssud</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>"
ExportFeatures "Address Points" C:\Users\jrbranch\Documents\ArcGIS\Projects\AddressSolution\AddressPoints_Export_2024_0510.gdb\AddressPoints_2024_0521 # NOT_USE_ALIAS "XMIN "XMIN" true true false 8 Double 15 24,First,#,Address Points,XMIN,-1,-1;XMAX "XMAX" true true false 8 Double 15 24,First,#,Address Points,XMAX,-1,-1;YMIN "YMIN" true true false 8 Double 15 24,First,#,Address Points,YMIN,-1,-1;YMAX "YMAX" true true false 8 Double 15 24,First,#,Address Points,YMAX,-1,-1;ID "ID" true true false 8 Double 0 12,First,#,Address Points,ID,-1,-1;FEATUREID "FEATUREID" true true false 8 Double 0 12,First,#,Address Points,FEATUREID,-1,-1;HOUSENUM "HOUSENUM" true true false 8 Double 0 12,First,#,Address Points,HOUSENUM,-1,-1;UNITNUM "UNITNUM" true true false 12 Text 0 0,First,#,Address Points,UNITNUM,0,11;LHN "LHN" true true false 120 Text 0 0,First,#,Address Points,LHN,0,119;STRUC_TYPE "STRUC_TYPE" true true false 8 Double 0 12,First,#,Address Points,STRUC_TYPE,-1,-1;POI_NAME "POI_NAME" true true false 75 Text 0 0,First,#,Address Points,POI_NAME,0,74;HNRANGE "HNRANGE" true true false 32 Text 0 0,First,#,Address Points,HNRANGE,0,31;UNITEXTRA "UNITEXTRA" true true false 64 Text 0 0,First,#,Address Points,UNITEXTRA,0,63;BUILDING "BUILDING" true true false 16 Text 0 0,First,#,Address Points,BUILDING,0,15;FLOOR "FLOOR" true true false 8 Text 0 0,First,#,Address Points,FLOOR,0,7;SEGID "SEGID" true true false 8 Double 0 12,First,#,Address Points,SEGID,-1,-1;ST_PREFIX "ST_PREFIX" true true false 4 Text 0 0,First,#,Address Points,ST_PREFIX,0,3;ST_NAME "ST_NAME" true true false 75 Text 0 0,First,#,Address Points,ST_NAME,0,74;ST_TYPE "ST_TYPE" true true false 16 Text 0 0,First,#,Address Points,ST_TYPE,0,15;ST_SUFFIX "ST_SUFFIX" true true false 4 Text 0 0,First,#,Address Points,ST_SUFFIX,0,3;ST_SUFFIX2 "ST_SUFFIX2" true true false 10 Text 0 0,First,#,Address Points,ST_SUFFIX2,0,9;LSN "LSN" true true false 120 Text 0 0,First,#,Address Points,LSN,0,119;MUNI "MUNI" true true false 50 Text 0 0,First,#,Address Points,MUNI,0,49;VILLAGE "VILLAGE" true true false 50 Text 0 0,First,#,Address Points,VILLAGE,0,49;COUNTY "COUNTY" true true false 24 Text 0 0,First,#,Address Points,COUNTY,0,23;STATE "STATE" true true false 2 Text 0 0,First,#,Address Points,STATE,0,1;FIPSCODE "FIPSCODE" true true false 5 Text 0 0,First,#,Address Points,FIPSCODE,0,4;ZIPCODE "ZIPCODE" true true false 10 Text 0 0,First,#,Address Points,ZIPCODE,0,9;USPS_CITY "USPS_CITY" true true false 50 Text 0 0,First,#,Address Points,USPS_CITY,0,49;SUBDIV "SUBDIV" true true false 50 Text 0 0,First,#,Address Points,SUBDIV,0,49;COMM "COMM" true true false 50 Text 0 0,First,#,Address Points,COMM,0,49;ALTPREFIX "ALTPREFIX" true true false 10 Text 0 0,First,#,Address Points,ALTPREFIX,0,9;ALTNAME "ALTNAME" true true false 75 Text 0 0,First,#,Address Points,ALTNAME,0,74;ALTTYPE "ALTTYPE" true true false 20 Text 0 0,First,#,Address Points,ALTTYPE,0,19;ALTSUFFIX "ALTSUFFIX" true true false 10 Text 0 0,First,#,Address Points,ALTSUFFIX,0,9;ALTSUFFIX2 "ALTSUFFIX2" true true false 10 Text 0 0,First,#,Address Points,ALTSUFFIX2,0,9;ALSN "ALSN" true true false 120 Text 0 0,First,#,Address Points,ALSN,0,119;TSSEGID "TSSEGID" true true false 8 Double 0 12,First,#,Address Points,TSSEGID,-1,-1;ROADTYPE "ROADTYPE" true true false 4 Text 0 0,First,#,Address Points,ROADTYPE,0,3;ROADNUMBER "ROADNUMBER" true true false 20 Text 0 0,First,#,Address Points,ROADNUMBER,0,19;DOT_ID "DOT_ID" true true false 16 Text 0 0,First,#,Address Points,DOT_ID,0,15;SIDE "SIDE" true true false 8 Double 0 12,First,#,Address Points,SIDE,-1,-1;ABSSIDE "ABSSIDE" true true false 2 Text 0 0,First,#,Address Points,ABSSIDE,0,1;PT_LEN "PT_LEN" true true false 8 Double 15 24,First,#,Address Points,PT_LEN,-1,-1;MPVAL "MPVAL" true true false 8 Double 15 24,First,#,Address Points,MPVAL,-1,-1;SOURCE "SOURCE" true true false 8 Double 0 12,First,#,Address Points,SOURCE,-1,-1;NOTE "NOTE" true true false 100 Text 0 0,First,#,Address Points,NOTE,0,99;LANDMARK "LANDMARK" true true false 255 Text 0 0,First,#,Address Points,LANDMARK,0,254;HN_ANOMALY "HN_ANOMALY" true true false 8 Double 0 12,First,#,Address Points,HN_ANOMALY,-1,-1;ERRORCOUNT "ERRORCOUNT" true true false 8 Double 0 12,First,#,Address Points,ERRORCOUNT,-1,-1;ISMARKER "ISMARKER" true true false 2 Short 0 5,First,#,Address Points,ISMARKER,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Address Points,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0,First,#,Address Points,created_user,0,254;created_date "created_date" false true false 8 Date 0 0,First,#,Address Points,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,Address Points,last_edited_user,0,254;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,Address Points,last_edited_date,-1,-1;PL_AppNum "PL_AppNum" true true false 50 Text 0 0,First,#,Address Points,PL_AppNum,0,49;PL_PIN "PL_PIN" true true false 50 Text 0 0,First,#,Address Points,PL_PIN,0,49;PL_Applicant "PL_Applicant" true true false 255 Text 0 0,First,#,Address Points,PL_Applicant,0,254;PL_DateIssued "PL_DateIssued" true true false 8 Date 0 0,First,#,Address Points,PL_DateIssued,-1,-1;PL_Notes "PL_Notes" true true false 255 Text 0 0,First,#,Address Points,PL_Notes,0,254;PL_DateNotified "PL_DateNotified" true true false 8 Date 0 0,First,#,Address Points,PL_DateNotified,-1,-1;PL_AssignedBy "PL_AssignedBy" true true false 50 Text 0 0,First,#,Address Points,PL_AssignedBy,0,49;PL_Acreage "PL_Acreage" true true false 8 Double 1 7,First,#,Address Points,PL_Acreage,-1,-1;PL_AmountPaid "PL_AmountPaid" true true false 8 Double 1 7,First,#,Address Points,PL_AmountPaid,-1,-1;PL_PaymentMethod "PL_PaymentMethod" true true false 50 Text 0 0,First,#,Address Points,PL_PaymentMethod,0,49;PL_StreetName "PL_StreetName" true true false 255 Text 0 0,First,#,Address Points,PL_StreetName,0,254" #
ExportFeatures C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521 C:\Users\jrbranch\AppData\Local\Temp\4\ArcGISProTemp58764\ec83aba8-0497-4363-b24e-edd403bcfd97\GIS2SQL.sde\GISData.DBO.Address_Planning\GISData.DBO.AddressPointsPlanning # NOT_USE_ALIAS "XMIN "XMIN" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,XMIN,-1,-1;XMAX "XMAX" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,XMAX,-1,-1;YMIN "YMIN" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,YMIN,-1,-1;YMAX "YMAX" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,YMAX,-1,-1;ID "ID" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ID,-1,-1;FEATUREID "FEATUREID" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,FEATUREID,-1,-1;HOUSENUM "HOUSENUM" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,HOUSENUM,-1,-1;UNITNUM "UNITNUM" true true false 12 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,UNITNUM,0,12;LHN "LHN" true true false 120 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,LHN,0,120;STRUC_TYPE "STRUC_TYPE" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,STRUC_TYPE,-1,-1;POI_NAME "POI_NAME" true true false 75 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,POI_NAME,0,75;HNRANGE "HNRANGE" true true false 32 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,HNRANGE,0,32;UNITEXTRA "UNITEXTRA" true true false 64 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,UNITEXTRA,0,64;BUILDING "BUILDING" true true false 16 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,BUILDING,0,16;FLOOR "FLOOR" true true false 8 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,FLOOR,0,8;SEGID "SEGID" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,SEGID,-1,-1;ST_PREFIX "ST_PREFIX" true true false 4 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ST_PREFIX,0,4;ST_NAME "ST_NAME" true true false 75 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ST_NAME,0,75;ST_TYPE "ST_TYPE" true true false 16 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ST_TYPE,0,16;ST_SUFFIX "ST_SUFFIX" true true false 4 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ST_SUFFIX,0,4;ST_SUFFIX2 "ST_SUFFIX2" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ST_SUFFIX2,0,10;LSN "LSN" true true false 120 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,LSN,0,120;MUNI "MUNI" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,MUNI,0,50;VILLAGE "VILLAGE" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,VILLAGE,0,50;COUNTY "COUNTY" true true false 24 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,COUNTY,0,24;STATE "STATE" true true false 2 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,STATE,0,2;FIPSCODE "FIPSCODE" true true false 5 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,FIPSCODE,0,5;ZIPCODE "ZIPCODE" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ZIPCODE,0,10;USPS_CITY "USPS_CITY" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,USPS_CITY,0,50;SUBDIV "SUBDIV" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,SUBDIV,0,50;COMM "COMM" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,COMM,0,50;ALTPREFIX "ALTPREFIX" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ALTPREFIX,0,10;ALTNAME "ALTNAME" true true false 75 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ALTNAME,0,75;ALTTYPE "ALTTYPE" true true false 20 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ALTTYPE,0,20;ALTSUFFIX "ALTSUFFIX" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ALTSUFFIX,0,10;ALTSUFFIX2 "ALTSUFFIX2" true true false 10 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ALTSUFFIX2,0,10;ALSN "ALSN" true true false 120 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ALSN,0,120;TSSEGID "TSSEGID" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,TSSEGID,-1,-1;ROADTYPE "ROADTYPE" true true false 4 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ROADTYPE,0,4;ROADNUMBER "ROADNUMBER" true true false 20 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ROADNUMBER,0,20;DOT_ID "DOT_ID" true true false 16 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,DOT_ID,0,16;SIDE "SIDE" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,SIDE,-1,-1;ABSSIDE "ABSSIDE" true true false 2 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ABSSIDE,0,2;PT_LEN "PT_LEN" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PT_LEN,-1,-1;MPVAL "MPVAL" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,MPVAL,-1,-1;SOURCE "SOURCE" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,SOURCE,-1,-1;NOTE "NOTE" true true false 100 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,NOTE,0,100;LANDMARK "LANDMARK" true true false 255 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,LANDMARK,0,255;HN_ANOMALY "HN_ANOMALY" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,HN_ANOMALY,-1,-1;ERRORCOUNT "ERRORCOUNT" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ERRORCOUNT,-1,-1;ISMARKER "ISMARKER" true true false 2 Short 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,ISMARKER,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,created_user,0,255;created_date "created_date" true true false 8 Date 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,last_edited_user,0,255;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,last_edited_date,-1,-1;PL_AppNum "PL_AppNum" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_AppNum,0,50;PL_PIN "PL_PIN" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_PIN,0,50;PL_Applicant "PL_Applicant" true true false 255 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_Applicant,0,255;PL_DateIssued "PL_DateIssued" true true false 8 Date 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_DateIssued,-1,-1;PL_Notes "PL_Notes" true true false 255 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_Notes,0,255;PL_DateNotified "PL_DateNotified" true true false 8 Date 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_DateNotified,-1,-1;PL_AssignedBy "PL_AssignedBy" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_AssignedBy,0,50;PL_Acreage "PL_Acreage" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_Acreage,-1,-1;PL_AmountPaid "PL_AmountPaid" true true false 8 Double 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_AmountPaid,-1,-1;PL_PaymentMethod "PL_PaymentMethod" true true false 50 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_PaymentMethod,0,50;PL_StreetName "PL_StreetName" true true false 255 Text 0 0,First,#,C:\Users\jrbranch\Documents\AddressPoints_Export_2024_0521.gdb\AddressPoints_2024_0521,PL_StreetName,0,255" #
Rename C:\Users\jrbranch\AppData\Local\Temp\4\ArcGISProTemp14364\c6dcc75e-71e3-4924-b656-db0d241832a0\GIS2SQL.sde\GISData.DBO.Address_Planning\GISData.DBO.AddressPointsPlanning C:\Users\jrbranch\AppData\Local\Temp\4\ArcGISProTemp14364\c6dcc75e-71e3-4924-b656-db0d241832a0\GIS2SQL.sde\GISData.DBO.Address_Planning\GISData.DBO.AddressPoints_Planning FeatureClass
GISData.DBO.AddressPointsPlanning
002
Server=GIS2SQL; Service=sde:sqlserver:GIS2SQL; Database=GISData; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_NAD_1983_2011
Linear Unit: Foot_US (0.304801)
NAD_1983_2011_StatePlane_Ohio_North_FIPS_3401_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.0.0'><WKT>PROJCS["NAD_1983_2011_StatePlane_Ohio_North_FIPS_3401_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",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",40.43333333333333],PARAMETER["Standard_Parallel_2",41.7],PARAMETER["Latitude_Of_Origin",39.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",6549]]</WKT><XOrigin>-118963900</XOrigin><YOrigin>-96373800</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>103129</WKID><LatestWKID>6549</LatestWKID></ProjectedCoordinateSystem>
20240521
03284100
20240521
03284100
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 14393) ; Esri ArcGIS 13.0.3.36057
AddressPoints_Planning
Enterprise Geodatabase Feature Class
dataset
EPSG
8.2.10(10.3.1)
0
Simple
FALSE
0
TRUE
FALSE
GISData.DBO.AddressPointsPlanning
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
XMIN
XMIN
Double
8
38
8
XMAX
XMAX
Double
8
38
8
YMIN
YMIN
Double
8
38
8
YMAX
YMAX
Double
8
38
8
ID
ID
Double
8
38
8
FEATUREID
FEATUREID
Double
8
38
8
HOUSENUM
HOUSENUM
Double
8
38
8
UNITNUM
UNITNUM
String
12
0
0
LHN
LHN
String
120
0
0
STRUC_TYPE
STRUC_TYPE
Double
8
38
8
POI_NAME
POI_NAME
String
75
0
0
HNRANGE
HNRANGE
String
32
0
0
UNITEXTRA
UNITEXTRA
String
64
0
0
BUILDING
BUILDING
String
16
0
0
FLOOR
FLOOR
String
8
0
0
SEGID
SEGID
Double
8
38
8
ST_PREFIX
ST_PREFIX
String
4
0
0
ST_NAME
ST_NAME
String
75
0
0
ST_TYPE
ST_TYPE
String
16
0
0
ST_SUFFIX
ST_SUFFIX
String
4
0
0
ST_SUFFIX2
ST_SUFFIX2
String
10
0
0
LSN
LSN
String
120
0
0
MUNI
MUNI
String
50
0
0
VILLAGE
VILLAGE
String
50
0
0
COUNTY
COUNTY
String
24
0
0
STATE
STATE
String
2
0
0
FIPSCODE
FIPSCODE
String
5
0
0
ZIPCODE
ZIPCODE
String
10
0
0
USPS_CITY
USPS_CITY
String
50
0
0
SUBDIV
SUBDIV
String
50
0
0
COMM
COMM
String
50
0
0
ALTPREFIX
ALTPREFIX
String
10
0
0
ALTNAME
ALTNAME
String
75
0
0
ALTTYPE
ALTTYPE
String
20
0
0
ALTSUFFIX
ALTSUFFIX
String
10
0
0
ALTSUFFIX2
ALTSUFFIX2
String
10
0
0
ALSN
ALSN
String
120
0
0
TSSEGID
TSSEGID
Double
8
38
8
ROADTYPE
ROADTYPE
String
4
0
0
ROADNUMBER
ROADNUMBER
String
20
0
0
DOT_ID
DOT_ID
String
16
0
0
SIDE
SIDE
Double
8
38
8
ABSSIDE
ABSSIDE
String
2
0
0
PT_LEN
PT_LEN
Double
8
38
8
MPVAL
MPVAL
Double
8
38
8
SOURCE
SOURCE
Double
8
38
8
NOTE
NOTE
String
100
0
0
LANDMARK
LANDMARK
String
255
0
0
HN_ANOMALY
HN_ANOMALY
Double
8
38
8
ERRORCOUNT
ERRORCOUNT
Double
8
38
8
ISMARKER
ISMARKER
SmallInteger
2
5
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
GlobalID
GlobalID
GlobalID
38
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
PL_AppNum
PL_AppNum
String
50
0
0
PL_PIN
PL_PIN
String
50
0
0
PL_Applicant
PL_Applicant
String
255
0
0
PL_DateIssued
PL_DateIssued
Date
8
0
0
PL_Notes
PL_Notes
String
255
0
0
PL_DateNotified
PL_DateNotified
Date
8
0
0
PL_AssignedBy
PL_AssignedBy
String
50
0
0
PL_Acreage
PL_Acreage
Double
8
38
8
PL_AmountPaid
PL_AmountPaid
Double
8
38
8
PL_PaymentMethod
PL_PaymentMethod
String
50
0
0
PL_StreetName
PL_StreetName
String
255
0
0
20240521
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2s5TP
92kmWZ7SRbZ1SVlwrsMhD64746479OKkIyDVC81F7CMGOzuLpm6pCASo9TkioAdp1vfW6v8AbdQF
4TjafIEe38jzV6obaYz20cphkhLDJjkGGX61NQAd6DRRQAU0nAJpc80jc8CgBNpABHXv70cZ+7T+
o+lJQA3v3/Ol6ccinYBpKAEHPfNVNRhv54o0sbtLVt2WkaLzMjHTBxj61bKg4IHIpiu/msrH5QAR
+tACWqTx2yJcTCaYD5pAm0N+Hape1GQBknigEHnNAC0UhPGaWgAooNFABSUtJQAtN6mlJ7d6AMCg
BaKKQnnAoARulKOW+gpvf1P8qcB19aAKtzqlhZyiK5vIIZCN22Rwpxzzz9D+VZN54qA1ZdO023iv
ZgCHBn8rawzkDK89DWzLZWs7B57eKVx0aRAxH5iqeoaZc3XlfZtRks441xiNAxb65pO4GkjFlBIw
SMnnOKdTIgyoFY5IGM+vvT6YBRRSUAFLRRQAUUUlACmmjhm9x/WnVHJIEKrgkvx9O/8ASgByk8g9
u9Opo4Y/TOKzdQ8QabpU6RX1yInkGVUqT/KgDUpKMgrkHI65rNOu2Y1EWP7wylguQhK5Pv0oA0h1
pcc0YxVe9uhZ2zS+XJIRwscYyzH0A70AT9DSms221aK4iMtxFNYgHAW7AjJ6c9ffFRDX4JbwW8Vn
ezQk4F1FEHhPGchgefTp1ouBrA9qDz3rGTXvJuNupW39nwNu2TXEqqhxjHJxyc9OvFW7uS9nton0
lrZ9/wAwlmO6Mr7bTkk+3HBpXAtzGQQSGEIZdp2BzhS2OM+2axo4NcvYp0up7eybcAklrlyQOT97
8RWtbi6+xAXRh+1YOTEDsz2wDz6VUsNKazuHnOoX1xuG3y55QyDvkDA54oAsWdrLb24jmuXuHBP7
xgATU5yBknj1PapM1HI6BSHClSMEEZzTS6IHZGfYa3Y6jcNBayl3Ubm+QgAZx16dasX9/a6Xb/aL
p9iZxkDJzR9qOfljXj2pL7TrfU4lS6DMnB2hiAfyqp05RWpEKkZ7ElleQ6haJc25YxPnBZSM4OOh
qYuoOCwB9Car2Wn2+nR7LZSqk5wWJGfx+lQXWi2F7dfabqIyycAEsRgDoMD6mp1LNAkKMkgD3qjq
Or2ulxRyT+YyucDy0LY+uOgovNOTUV8q8Yy2+d3lKNuCORyOeMUR6RYw6adPih22pzlNx5yckZ60
tQH299bXFpHdLKFik5BkO0j2OelWBcQkBhNGQehDDms//hHtKFmbQWiiJiGxuJOQMAgk9gaJfD2k
zeWr2iHYMIASNoznjB9aNQLpvbUT+R9ph87/AJ57xu/Kke4Ty3aNhIyjO1Dkn8qrPo2mvcm7+yx+
djHmAc9ufrwPyplnoGl2MryWlnHE7rtZlzyOPf2FGoCaXqN5dzyx3dlHbBR8u24WQscnIwOn/wBe
tUVQs9IsLOc3FvapHKckuucnPU1oFm/vH86aAxNRvdRi1AQ2k2lohA+S7lIdj7Adv65q1qQ1Zwi6
YbRDty7XKswJzxjafr19RT5dLsLi6NxPZxSzcfvJFDEfQmsvX9Vu9MEbG8t7ZHOFeZC4Y+mBz+NI
DctxKIEE5Qy4+coOM98VLVSxnNxp9tN5iyl1BLopAb3waY2s6bHIY5NRtEcZLI06grg4ORn1pgXq
Kgtry1vEZ7W5hnVTtYxOGAPocVBqOr2GlBDfXUcAfO3ecZx1oAvUVlDxJpBnaEX0ZcdRg8cZ649q
s2WqWWpKzWdwkwXhivai4FykqkdYsBemza5QXIYKYznOTggfqKiuNf0y1uZLea6CyxkB12McEgHs
PQii6A0jWfqNlf3Yi+xXqWuw7md4/MzxjGMgVcAlcgnag9M5NYevahrVlcQmygWSB2CsqRF2UZ5P
H1GPoaTA2bWOWK1jW5mFxMow8gTYGPrtycfnVfUNItdVCi6DhUbcFR9vPqccn8atQyebbJKUZCyh
trDBHHQ1Ip4wae4EP2WNNPFmoYw7NmM5JX6mq+maPY6OrLZQGIOAGzIz/wDoRPqa0KTrRYB2TRuP
qaSigCC7sra/iEd3CkyA5CuMjNJbWVtZxLHbwJGi8gKOlWKKAIpreG5QLcQxyqDkCRQwB/GnxxpD
GI4kVEXgKowB+FOooASnAYX8ab3qC8knEBjtdn2lvub/ALo9SaAJzVKQmafaOnSix/tBYWGoNA8u
flMIIGMd80+1H71z6CtqLsnLsY1ldqPcmSFUjKjnPrSpGU6Mcdwak70nes3Jvc0UEthaQgHqKXpR
2qSgpvPbHWnUlAAOlLSDrSmgBAKSlFBoAFPBA9aU00HHPrTqAILpJHgIjZ1ccjYQCfbniuRvop7f
VIbi6n1JrgtlYorxUUqDkAoPXgH19K6/7RH53lfNv/3Dj88YrK1jw+NQ2S28kMFyH3G4lhExGOQA
px35/D3pMBbe11G8nS8lvbi1jc5ay2qQBwMbsZ7Z/E1dGj6aNp+wwEgY3FMlvqep9ec881JZx3EV
qqXVwLiYZ3SiMIG/DPFWe1FgIoLe3tVK29vFEGOSI1C5P4UTW8Fxt86FH2nI3DOKlpKYFWfTraZJ
QIo0kkXG/aDgjocHisI+HL60tpmttUkMxO5Fgijh3HuCcHrx9MV0/egjP4UrIDmLTQbi9tYxqBur
GeLgSwXCb5ec5ZlUcj+proIbSGGFI9gkKjBeQAsx9Se5NTc5GetLTSAKq32pWWlw/aL64SCIkIGf
pk9B+lWzUb+VHmZwoKKfmPYdx+goAZa3VvfW6XNtIssLj5XXoRUmMYHWqOnaxBqbMsUFzHtGf30R
StBe5oATp1pwxjIpKQHacHpQA6ijk/SigAooqOWJZl2vkr1xnrQBJTJJEiALsFBOBk05FCKFXgDp
QQCc4oAEZXUMpBB5BFRyZ8+I/UVKBiq982zT7g+Y0fyH5kGW/wCA/wC16e+KAJj0NNgj8tDn7x61
jeH2ciZXbU2KgfNerjP05rdpqTtYTir3CiigUhhRR3pO9ABQaWkoABQaWg0AFFFFACEZpM4+nenU
lABgDkcDqa5vXTpAv0a/v76KUKCqW5k27eRzsBGc5/T2roxxx2qC7sLe9t3hnTdG7BnUcbsdM457
Ck0BOORkHINOHSs/TbJNPVre3tEgt8lhiQsSeOx/xq/TAWiikoAByaWk70tABRRRQAyRWeMqjlCf
4gM4qGWUWlpI0lxGpxgPMwVcnpk1Zqre28U1u7SwpNsQsEfJUkDjIwc/kaGBU0lLggzvqyX8LAhS
irtznqCPyrUXpXNeGk1OKVoLmBoLVUJRfJjjUtkcgJ+NdMBjikgCmsMg06kNMAXkZ70tNHDEfjS8
0AFLSd6WgAooooAKOoP0opG3bH2AF9p2gnAJ+vNAB7Uvas6ytdRgl3XeoC4TaRt8pV5zweBWiDxQ
AGkFL2qE3MKziEv+8P8ADg0ATUUUlABRRRQAUtJ3paACiiigAoopKAEOCcUoJC8jv1pMfNnP4Vz/
AIpe1WzDTyzFiCsSI7KobuWK846evTgUN2A6KisrQJLx9Mja5WHyyF8gxu5Ypjq+8A5rV60AFFFR
tPEkgjaRA56KTzQA+lopKAFooFBoAKQ5524LYOATilrG1Hw7Y6vdrd3Cy+fGhRGWeRV4yRlVYA8n
Pr70AT2EGqRXGb28hmiK8KkW0g8f/XrS71zehPpo1FlttZvbuchgYppXZB0zgNxxXRkgGkgFpKKK
YDT97PfFOHI9qQjNAzkigBaWiigAooooAKUDn8DSUq/eoAaaDxWfa65YXt4bSCSYzDPDW8ijjrhi
oB6etaNACUAAdABmkFOx0oASloooASlpKWgBKUUlFAC0UUUAFFJRQAH2qhqOjWWrIq3sbuEIK7ZG
TBHfKkHvV+lA4b6UAQWVrDZWUNtbpshiUKikk4A9zzU9IvTFLQAU3auc7Rn1xTqKACiiigBO9Opl
OoASqepSXcdm32OKOSZsKol+4MnndznGPSrtNePzU2ZxnHNAFTTBqAtj/aKWqzA4X7MDt24Hr75q
7RRQAh6UUtFACU0fepx4FN/iFADzRRSGgBaKSloAKhueLdzyeOQKmpCoYbSSAeOKAAAKAAAAOAB2
pOmaWjHFACDinZpByKOlAC0UgpetACUtFFABSUtJQAoopKWgAoNFHegBKimlljIEcBkBwGIYDaPW
pjTHPAHqaAHL3paOgo7UAFFAooAKQ88UvWk70AA60tJ3p1ACUq/eH1pKiuTcCB/soQ3BH7vf90N2
J9qAJaSqOmjVQsv9qNaFt37v7MGGB7571eoAWiiigBDTRzyaU0AZU0AO4FJ1Oe1FHSgBaQUtIetA
DZS6p+7UM2ehOBSxlyoMihWz0BzTqY8ixIXc4VRk0AO70p6VQ0/WLbUndYEuFKjcTLAyDGexI5q9
QALQaOlLQAgoPHNHSlPSgAoopKAFooooAKSlqFJmeQr5Mir/AHjjB/XNAEwopBS44oAhuvO+ySi2
UNMVITPTPYn2rkvDdzYnW5opH/07lV2GdlPXcSW+XnHb8KvXtnr1naSGG/mvHcgAAKhUZBJB/MY9
O+avaDFeR2A+3tIZ2kJ/ebSQPwqd2Br59DRRRVABoBooFABRSUtAAaQZxQaWgAFMklEKF9rMQMhV
GSad0pw7UAY1prklzK8MmnywSjGEeRcnP41rISyAlSpI5B7Vz6W5Gub10EmMOD9uecbjx97Yfmz2
rohSQBTJRIUIjYK394jOPwp1LTAZGrBcO25vXGKD8vNPFIRmgA7UvamrxwadQAlKaTvQSM4oAUUj
KG6gH60oooAVuCfrTac33jSUANan0zrT6AGml7UUgPagBaKAKKAEPFAoNAoAWkpaKACmTzw2sLTX
EqRRLjc8jBQMnA5PvT6q3K2d7tt5XjkKsT5RfIJA6Fc849D357UAOtry2v4jNa3EU8YYrvicMMjq
Mips9DTILeG3i8uGGOJeu1FAGfwp5HGKAH03vSKTnBNOIoAOtFFFABSUtRNBG8okIJYdDmgCSlpK
KAMTxB4ig0SCI5jeWUkIrvtBx15weeRx3rR0+8a50uK9mjWIOm/CtuGO3P0qcIgcsFAbpnvj/JNO
ZEkXa6hl9CMigDFHizSZFdkeZtuCQIWzzntj2rVs7qO9tlniDBGzjcuDwcVK6Bnz35GfalUYAFGo
Dtp9vzo2n2/OkooAXafb8xVe8na1tzIsLTPkARp1NT008nkAjtQBm2es21wdlwy2lxv2CCeQByeM
YHvmtASktjynAzjJxiq8un2ck/nvaxNMOjlRn86uDkUICO4doYHdEMjgfKgz8x7DOOPr2rOt21PU
bSWO7tRpkhACtHOJWwc5wQBgjj1rVNJQBV0+yezWRZL6e53NkGYg7eOgwKuEGm9xS5oAcVOehqve
XUNhavc3T+XCnLMQTjnHapz/AEFQyIjSKzAEryM9qAIbG/tdUtvtFlKJoScbgCOfxq4eBk8AVH6C
pKAMCfUNRg1JjNNp6aYDuaQ7t+3sM5xnP86fpepXupXJaJLRrIMQzLKTIvoCOmfWtmSNJV2yKHX0
YZFNjijhBEUaICckKuM0rAUr9tY83bp0VrsA5a4J5Ptg/wA6nu71NPsxPc5YjA2xLksf9kdT6/QV
ZpCgJB9KYHN6h4pH2IfYLe7+0ORt8y2Yhe53enFQ3niO90q0sjcyae0s67izyMowcYACgnv3x7e3
SXtlDf2zQThjGxBO1ivQ5HSm2NhBp9t5FuHVASfmcsc/U5pWYyP+04l0xbxv3gMQcCIEhyRwFz3J
4H1rLuPENy9q62+l6glyVO3fB909iR35/OtG10HS7O8a8t7NI7hyS0ik5JPXvU895FbFnuMQxKcG
Z2VV9PX14o1EQ6R/aL2nnai8e6QAoqoVZOOjD1pYNG0+2uvtMNsqzkkmTkkk9T9ar2utyX94Y7ay
MtmGK/allUjP+71rWoVgAUhp1NJpgJjn3p2cgGmgFjk8D0p9ACA0tFIKAFpKWigBKKWkoAKXvQKQ
0AOP3j9aTpTY3MkSucZYZOKU0AOpKOlFABik706mkfNQAhGeKVDlRQeBSJwPxoAXkigDApelJQAo
Heg0VWv5bqG1L2duLiYEYjLhcj6mgC1TGAzk9awo7vXZrZHgsLaCVmYyJcufXjbj6d/UVtxGRoEM
oUSbRvC9M98e1LcBR96pKjU/Nj2p/Q0wA55waSnUlAAaKDRQA1pY1IVnUE9iaWmmNGbcygn1IzTq
AFHA5rL1bUrOzMcdzbT3G/JCRRGTHbkfj+ntWpWTrqbLP7RD5q3W9VRoEDyY7hQSAeAfwzQwL9oI
fsyNBCIY3G4Js2Yz6j1qasrw+90+mk3b3bSByM3UQjcgY5wCRitPdzQgHUijP0/nRjPXpTh0oATo
aWkNLQAUg60ppB1oAWig0CgBKKWkoAWg0daCAQQRkHsaAOdTxIZdVGnafaG6ReDK0oU8deG5OK6H
vWZdPqMV+EsbC3aDABd22H3xj2rTPSkgFNJSmkFMBaBQelJQANSKeopTzSDhvwoAcaSlPSigAHSo
Ly3kubZoorl7dzjEiAEj86nFMmMoUeSF3erdBQBjm31q2KxWk1vMudzzXgO5ifQL6Y71sxhvKXzN
u/HzbemfahQ/lLv278c7elO7UJAMztfPanmo2qWgBo9Kd2po60pNACUUUtACGilpKACq97dC0s3l
MUkuCAI4gC7n0AJGT3qfk+wrPh8QaVMJlivEbyl3vgH5QOp6e9AEun3n26FnNpdW+1tu24QKTx1A
BPFXMAVUsdTstS3mznEoTG7AIxn61cNCASlFIaAaAFNFFFACUDrRQKAF70UUUAJS0UUAJjuOtKDn
iiigBW6/gKhaeNJBGx+bjjB70UUMCWiiigAJ4PrUUcciEl5i4PYgDH5UUUASE01eXz7UUUAPJpKK
KAHU0nmiigBeNg+tJRRQAhpw5FFFACUUUUALRRRQAU088UUUAOqpPZKbeVbZIo5nXaJCg+XnrjHO
M5xRRQBFpdneWaut3ffai2Nv7lY9v5davmiigApcUUUAFJRRQAUtFFABRRRQAUlFFAH/2Q==