20220613
14112600
1.0
FALSE
gispub.PUBOWNER.civic_addresses_TPR
002
Server=GOVGISPUBP01; Service=sde:sqlserver:GOVGISPUBP01; Database=gispub; User=pubowner; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983_CSRS
Linear Unit: Meter (1.000000)
NAD_1983_CSRS_Prince_Edward_Island
<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/2.9.0'><WKT>PROJCS["NAD_1983_CSRS_Prince_Edward_Island",GEOGCS["GCS_North_American_1983_CSRS",DATUM["D_North_American_1983_CSRS",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Double_Stereographic"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",800000.0],PARAMETER["Central_Meridian",-63.0],PARAMETER["Scale_Factor",0.999912],PARAMETER["Latitude_Of_Origin",47.25],UNIT["Meter",1.0],AUTHORITY["EPSG",2954]]</WKT><XOrigin>-30310600</XOrigin><YOrigin>-29959100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2291</WKID><LatestWKID>2954</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass civic_addresses "C:\esri\NTXShape\new property files\civic.mdb" civic_addresses # "TIME_ "TIME_" true true false 40 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,TIME,-1,-1;X_COORD "X_COORD" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,X_COORD,-1,-1;Y_COORD "Y_COORD" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,Y_COORD,-1,-1;Z_COORD "Z_COORD" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,Z_COORD,-1,-1;PDOP "PDOP" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,PDOP,-1,-1;STREET_NO "STREET_NO" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,STREET_NO,-1,-1;O_ST_NO_1 "O_ST_NO_1" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_ST_NO_1,-1,-1;O_ST_NO_2 "O_ST_NO_2" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_ST_NO_2,-1,-1;O_ST_NO_3 "O_ST_NO_3" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_ST_NO_3,-1,-1;O_ST_NO_4 "O_ST_NO_4" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_ST_NO_4,-1,-1;APT_NO "APT_NO" true true false 5 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,APT_NO,-1,-1;LOC_CODE "LOC_CODE" true true false 5 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,LOC_CODE,-1,-1;STREET_NM "STREET_NM" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,STREET_NM,-1,-1;O_STREET_N "O_STREET_N" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_STREET_N,-1,-1;O_ST_NM_1 "O_ST_NM_1" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_ST_NM_1,-1,-1;O_ST_NM_2 "O_ST_NM_2" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_ST_NM_2,-1,-1;O_ST_NM_3 "O_ST_NM_3" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_ST_NM_3,-1,-1;O_ST_NM_4 "O_ST_NM_4" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_ST_NM_4,-1,-1;COMM_NM "COMM_NM" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,COMM_NM,-1,-1;O_COMM_NM "O_COMM_NM" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_COMM_NM,-1,-1;COMM_ID "COMM_ID" true true false 10 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,COMM_ID,-1,-1;COUNTY "COUNTY" true true false 3 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,COUNTY,-1,-1;PID "PID" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,PID,-1,-1;O_PID "O_PID" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_PID,-1,-1;MOBILE_ID "MOBILE_ID" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,MOBILE_ID,-1,-1;LEASE_CODE "LEASE_CODE" true true false 9 Long 0 9 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,LEASE_CODE,-1,-1;LOT_NO "LOT_NO" true true false 10 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,LOT_NO,-1,-1;INFO "INFO" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,INFO,-1,-1;STREET_CD "STREET_CD" true true false 19 Double 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,STREET_CD,-1,-1;VERIFIED "VERIFIED" true true false 10 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,VERIFIED,-1,-1;SERIAL "SERIAL" true true false 20 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,SERIAL,-1,-1;O_SERIAL "O_SERIAL" true true false 20 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_SERIAL,-1,-1;O_SERIAL_1 "O_SERIAL_1" true true false 20 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,O_SERIAL_1,-1,-1;ESZ_ "ESZ_" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,ESZ_,-1,-1;FIRE_COV "FIRE_COV" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,FIRE_COV,-1,-1;ORIGINAL_T "ORIGINAL_T" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,ORIGINAL_T,-1,-1;UNIQUE_ID "UNIQUE_ID" true true false 7 Text 0 0 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,UNIQUE_ID,-1,-1;MAPINFO_ID "MAPINFO_ID" true true false 9 Long 0 9 ,First,#,C:\esri\NTXShape\new property files\civic_addresses.shp,MAPINFO_ID,-1,-1" #
CalculateField civic_addresses pid2 [PID] VB #
AlterField E:\working\production\civic.mdb\civic_addresses ESZ ESN #
ChangePrivileges 'Database Connections\DSDICKIE@CIVIC_WORK.sde\CIVIC_WORK.DBO.civic_addresses';'Database Connections\DSDICKIE@CIVIC_WORK.sde\CIVIC_WORK.DBO.new_centerline' GOV\klmmackay GRANT GRANT
ChangePrivileges 'Database Connections\DSDICKIE@CIVIC_WORK.sde\CIVIC_WORK.DBO.civic_addresses';'Database Connections\DSDICKIE@CIVIC_WORK.sde\CIVIC_WORK.DBO.new_centerline' GOV\pmtidd GRANT #
CalculateField CIVIC_WORK.DBO.civic_addresses COMM_ID "" VB #
CalculateField "Civic Addressing\civic addresses" STREET_NM "BEECH HILL AV" VB #
CalculateField "Civic Addressing\civic addresses" COMM_NM "CHARLOTTETOWN" VB #
CalculateField "Civic Addressing\civic addresses" COMM_ID "MUNIC" VB #
CalculateField "Civic Addressing\civic addresses" COUNTY "QUN" VB #
CalculateField "Civic Addressing\civic addresses" PID 1149541 VB #
CalculateField "Civic Addressing\civic addresses" pid2 1149541 VB #
CalculateField "Civic Addressing\civic addresses" INFO "SEMI-DETACHED DWELLING" VB #
CalculateField "Civic Addressing\civic addresses" LOT_NO "20-5" VB #
CalculateField "Civic Addressing\civic addresses" SERIAL "MA4020" VB #
CalculateField "Civic Addressing\civic addresses" STREET_NM "KINDRED AV" VB #
CalculateField "Civic Addressing\civic addresses" COMM_NM "CHARLOTTETOWN" VB #
CalculateField "Civic Addressing\civic addresses" COMM_ID "MUNIC" VB #
CalculateField "Civic Addressing\civic addresses" COUNTY "QUN" VB #
CalculateField "Civic Addressing\civic addresses" PID 1129089 VB #
CalculateField "Civic Addressing\civic addresses" pid2 1129089 VB #
CalculateField "Civic Addressing\civic addresses" ESN "2019" VB #
CalculateField "Civic Addressing\civic addresses" FIRE_COV "CHARLOTTETOWN (72)" VB #
CalculateField "Civic Addressing\civic addresses" SERIAL "MA4020" VB #
CalculateField "Civic Addressing\civic addresses" LOT_NO "55" VB #
CalculateField "Civic Addressing\civic addresses" INFO "3 UNIT TOWNHOUSE" VB #
CalculateField "Civic Addressing\civic addresses" STREET_NM "AIDAN ST" VB #
CalculateField "Civic Addressing\civic addresses" COMM_NM "CHARLOTTETOWN" VB #
CalculateField "Civic Addressing\civic addresses" COMM_ID "MUNIC" VB #
CalculateField "Civic Addressing\civic addresses" COUNTY "QUN" VB #
CalculateField "Civic Addressing\civic addresses" PID 1016294 VB #
CalculateField "Civic Addressing\civic addresses" pid2 1016294 VB #
CalculateField "Civic Addressing\civic addresses" FIRE_COV "CHARLOTTETOWN (72)" VB #
CalculateField "Civic Addressing\civic addresses" INFO "SEMI-DETACHED DWELLING" VB #
CalculateField "Civic Addressing\civic addresses" SERIAL "MA4020" VB #
CalculateField "Civic Addressing\civic addresses" ESN "2019" VB #
ChangePrivileges 'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.civic_addresses';'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.new_centerline' GOV\pmtidd GRANT #
ChangePrivileges 'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.civic_addresses';'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.new_centerline' GOV\klmmackay GRANT #
ChangePrivileges 'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.police';'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.new_centerline';'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.fire_coverage';'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.esn';'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.civic_addresses';'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.civic_addressed_community';'Database Connections\DSDICKIE@CIVIC_PROD.sde\CIVIC_PROD.DBO.ambulance' GOV\tlscott GRANT #
CopyFeatures E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.civic_addresses E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.civic_addresses # # # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.civic_addresses
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.civic_addresses
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.civic_addresses E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.civic_addresses TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.civic_addresses
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.civic_addresses E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.civic_addresses TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.civic_addresses
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.civic_addresses E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.civic_addresses TEST # #
FeatureClassToFeatureClass C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses C:\Users\joshawry\Downloads\PubOwner.sde civic_addresses_TPR # "TIME_ "TIME_" true true false 40 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,TIME_,0,40;X_COORD "X_COORD" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,X_COORD,-1,-1;Y_COORD "Y_COORD" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,Y_COORD,-1,-1;Z_COORD "Z_COORD" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,Z_COORD,-1,-1;PDOP "PDOP" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,PDOP,-1,-1;STREET_NO "STREET_NO" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,STREET_NO,-1,-1;O_ST_NO_1 "O_ST_NO_1" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_ST_NO_1,-1,-1;O_ST_NO_2 "O_ST_NO_2" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_ST_NO_2,-1,-1;O_ST_NO_3 "O_ST_NO_3" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_ST_NO_3,-1,-1;O_ST_NO_4 "O_ST_NO_4" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_ST_NO_4,-1,-1;APT_NO "APT_NO" true true false 5 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,APT_NO,0,5;LOC_CODE "LOC_CODE" true true false 5 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,LOC_CODE,0,5;STREET_NM "STREET_NM" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,STREET_NM,0,50;O_STREET_NM "O_STREET_NM" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_STREET_NM,0,50;O_ST_NM_1 "O_ST_NM_1" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_ST_NM_1,0,50;O_ST_NM_2 "O_ST_NM_2" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_ST_NM_2,0,50;O_ST_NM_3 "O_ST_NM_3" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_ST_NM_3,0,50;O_ST_NM_4 "O_ST_NM_4" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_ST_NM_4,0,50;COMM_NM "COMM_NM" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,COMM_NM,0,50;O_COMM_NM "O_COMM_NM" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_COMM_NM,0,50;COMM_ID "COMM_ID" true true false 10 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,COMM_ID,0,10;COUNTY "COUNTY" true true false 3 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,COUNTY,0,3;PID "PID" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,PID,-1,-1;O_PID "O_PID" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_PID,-1,-1;MOBILE_ID "MOBILE_ID" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,MOBILE_ID,0,50;LEASE_CODE "LEASE_CODE" true true false 4 Long 0 10,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,LEASE_CODE,-1,-1;LOT_NO "LOT_NO" true true false 10 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,LOT_NO,0,10;INFO "INFO" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,INFO,0,50;STREET_CD "STREET_CD" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,STREET_CD,-1,-1;VERIFIED "VERIFIED" true true false 10 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,VERIFIED,0,10;SERIAL "SERIAL" true true false 20 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,SERIAL,0,20;O_SERIAL "O_SERIAL" true true false 20 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_SERIAL,0,20;O_SERIAL_1 "O_SERIAL_1" true true false 20 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,O_SERIAL_1,0,20;ESN "ESZ" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,ESN,0,50;FIRE_COV "FIRE_COV" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,FIRE_COV,0,50;ORIGINAL_TABLE "ORIGINAL_TABLE" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,ORIGINAL_TABLE,0,50;UNIQUE_ID "UNIQUE_ID" true true false 7 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,UNIQUE_ID,0,7;MAPINFO_ID "MAPINFO_ID" true true false 4 Long 0 10,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,MAPINFO_ID,-1,-1;created_user "created_user" true true false 255 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,created_user,0,255;created_date "created_date" true true false 8 Date 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,last_edited_user,0,255;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,last_edited_date,-1,-1;pid2 "pid2" true true false 15 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses,pid2,0,15" #
TruncateTable C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.civic_addresses_TPR
TruncateTable C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.civic_addresses_TPR
TruncateTable C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.civic_addresses_TPR
Append C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.civic_addresses_TPR "Input fields must match target fields" # # #
TruncateTable C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.civic_addresses_TPR
Append C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.civic_addresses C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.civic_addresses_TPR "Input fields must match target fields" # # #
20220622
14114200
20220622
14114200
ISO 19139 Metadata Implementation Specification
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 14393) ; Esri ArcGIS 12.9.3.32739
civic_addresses_TPR
civic
address
points
taxation
tpr
geolinc
Civic Address Points
Taxation Property Records
Enterprise Geodatabase Feature Class
dataset
EPSG
6.2(9.3.0.0)
0
Simple
FALSE
0
TRUE
FALSE
gispub.PUBOWNER.civic_addresses_TPR
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
TIME_
TIME_
String
40
0
0
X_COORD
X_COORD
Double
8
38
8
Y_COORD
Y_COORD
Double
8
38
8
Z_COORD
Z_COORD
Double
8
38
8
PDOP
PDOP
Double
8
38
8
STREET_NO
STREET_NO
Double
8
38
8
O_ST_NO_1
O_ST_NO_1
Double
8
38
8
O_ST_NO_2
O_ST_NO_2
Double
8
38
8
O_ST_NO_3
O_ST_NO_3
Double
8
38
8
O_ST_NO_4
O_ST_NO_4
Double
8
38
8
APT_NO
APT_NO
String
5
0
0
LOC_CODE
LOC_CODE
String
5
0
0
O_STREET_NM
O_STREET_NM
String
50
0
0
STREET_NM
STREET_NM
String
50
0
0
O_ST_NM_1
O_ST_NM_1
String
50
0
0
O_ST_NM_2
O_ST_NM_2
String
50
0
0
O_ST_NM_3
O_ST_NM_3
String
50
0
0
O_ST_NM_4
O_ST_NM_4
String
50
0
0
COMM_NM
COMM_NM
String
50
0
0
O_COMM_NM
O_COMM_NM
String
50
0
0
COMM_ID
COMM_ID
String
10
0
0
COUNTY
COUNTY
String
3
0
0
PID
PID
Double
8
38
8
O_PID
O_PID
Double
8
38
8
MOBILE_ID
MOBILE_ID
String
50
0
0
LEASE_CODE
LEASE_CODE
Integer
4
10
0
LOT_NO
LOT_NO
String
10
0
0
INFO
INFO
String
50
0
0
STREET_CD
STREET_CD
Double
8
38
8
VERIFIED
VERIFIED
String
10
0
0
SERIAL
SERIAL
String
20
0
0
O_SERIAL
O_SERIAL
String
20
0
0
ESN
ESZ
String
50
0
0
O_SERIAL_1
O_SERIAL_1
String
20
0
0
ORIGINAL_TABLE
ORIGINAL_TABLE
String
50
0
0
FIRE_COV
FIRE_COV
String
50
0
0
UNIQUE_ID
UNIQUE_ID
String
7
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
pid2
pid2
String
15
0
0
MAPINFO_ID
MAPINFO_ID
Integer
4
10
0
20220622
/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
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigD//2Q==