20220603
09402400
1.0
FALSE
DefineProjection C:\esri\NTXShape\production\ambulance.shp 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]]
CalculateField ambulance KEYWORD2 [KEYWORD] VB #
CalculateField ambulance KEYWORD [KEYWORD2] VB #
FeatureClassToFeatureClass C:\esri\NTXShape\production\ambulance.shp C:\esri\NTXShape\production\property.mdb ambulance # "RECNO "RECNO" true true false 12 Double 0 12 ,First,#,C:\esri\NTXShape\production\ambulance.shp,RECNO,-1,-1;AREA "AREA" true true false 16 Double 4 15 ,First,#,C:\esri\NTXShape\production\ambulance.shp,AREA,-1,-1;DISPX "DISPX" true true false 18 Double 8 17 ,First,#,C:\esri\NTXShape\production\ambulance.shp,DISPX,-1,-1;DISPY "DISPY" true true false 18 Double 8 17 ,First,#,C:\esri\NTXShape\production\ambulance.shp,DISPY,-1,-1;SIZE_ "SIZE_" true true false 14 Double 6 13 ,First,#,C:\esri\NTXShape\production\ambulance.shp,SIZE,-1,-1;ANGLE "ANGLE" true true false 8 Float 3 7 ,First,#,C:\esri\NTXShape\production\ambulance.shp,ANGLE,-1,-1;USERNUM "USERNUM" true true false 12 Double 0 12 ,First,#,C:\esri\NTXShape\production\ambulance.shp,USERNUM,-1,-1;FCODE "FCODE" true true false 12 Text 0 0 ,First,#,C:\esri\NTXShape\production\ambulance.shp,FCODE,-1,-1;DATATYPE "DATATYPE" true true false 4 Short 0 4 ,First,#,C:\esri\NTXShape\production\ambulance.shp,DATATYPE,-1,-1;DESCFLAGS "DESCFLAGS" true true false 12 Double 0 12 ,First,#,C:\esri\NTXShape\production\ambulance.shp,DESCFLAGS,-1,-1;THEMENUM "THEMENUM" true true false 12 Double 0 12 ,First,#,C:\esri\NTXShape\production\ambulance.shp,THEMENUM,-1,-1;INDEXKEY "INDEXKEY" true true false 12 Text 0 0 ,First,#,C:\esri\NTXShape\production\ambulance.shp,INDEXKEY,-1,-1;SUPERFLAGS "SUPERFLAGS" true true false 12 Double 0 12 ,First,#,C:\esri\NTXShape\production\ambulance.shp,SUPERFLAGS,-1,-1;SOURCEID "SOURCEID" true true false 12 Text 0 0 ,First,#,C:\esri\NTXShape\production\ambulance.shp,SOURCEID,-1,-1;KEYWORD "KEYWORD" true true false 50 Text 0 0 ,First,#,C:\esri\NTXShape\production\ambulance.shp,KEYWORD,-1,-1" #
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\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\pmtidd 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.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance # # # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
Append E:\Geolinc\civic_import_\govgisapp03.gov.pe.ca.sde\CIVIC_PROD.DBO.ambulance E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance TEST # #
TruncateTable E:\Geolinc\civic_import_\TPR_OWNER_PRODUCTION.sde\TPR.TPR_OWNER.ambulance
FeatureClassToFeatureClass C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.ambulance C:\Users\joshawry\Downloads\PubOwner.sde ambulance_TPR # "USERNUM "USERNUM" true true false 8 Double 8 38,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.ambulance,USERNUM,-1,-1;FCODE "FCODE" true true false 12 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.ambulance,FCODE,0,12;SOURCEID "SOURCEID" true true false 12 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.ambulance,SOURCEID,0,12;KEYWORD "KEYWORD" true true false 50 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.ambulance,KEYWORD,0,50;created_user "created_user" true true false 255 Text 0 0,First,#,C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.ambulance,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.ambulance,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.ambulance,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.ambulance,last_edited_date,-1,-1" #
TruncateTable C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.ambulance_TPR
TruncateTable C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.ambulance_TPR
TruncateTable C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.ambulance_TPR
Append C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.ambulance C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.ambulance_TPR "Input fields must match target fields" # # #
TruncateTable C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.ambulance_TPR
Append C:\Users\joshawry\Downloads\TPR.sde\TPR.TPR_OWNER.ambulance C:\Users\joshawry\Downloads\PubOwner.sde\gispub.PUBOWNER.ambulance_TPR "Input fields must match target fields" # # #
gispub.PUBOWNER.ambulance_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>
20220622
14092900
20220622
14092900
ISO 19139 Metadata Implementation Specification
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 14393) ; Esri ArcGIS 12.9.3.32739
ambulance_TPR
ambulance
taxation
tpr
geolinc
Ambulance
Taxation Property Records
Enterprise Geodatabase Feature Class
dataset
EPSG
6.2(9.3.0.0)
0
Simple
FALSE
0
TRUE
FALSE
gispub.PUBOWNER.ambulance_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.
USERNUM
USERNUM
Double
8
38
8
FCODE
FCODE
String
12
0
0
SOURCEID
SOURCEID
String
12
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
KEYWORD
KEYWORD
String
50
0
0
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
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==