20250521
16560100
1.0
FALSE
CreateFeatureclass \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb tempFC Point \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\temptable No No "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision" # 0 0 0 #
XYTableToPoint \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\temptable \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC Longitude Latitude # "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision"
SpatialJoin \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\FireUpdate.gdb\DashboardAreas \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFCwAreas "Join one to one" KEEP_ALL "Incident_Number "Incident Number" true true false 4 Long 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Incident_Number,-1,-1;Incident_Date "Incident Date" true true false 8 Date 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Incident_Date,-1,-1;Alarm_Time "Alarm Time" true true false 8 Date 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Alarm_Time,-1,-1;Station "Station" true true false 8000 Text 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Station,0,8000;Incident_Address "Incident Address" true true false 8000 Text 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Incident_Address,0,8000;Incident_Type_Code "Incident Type Code" true true false 8000 Text 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Incident_Type_Code,0,8000;Latitude "Latitude" true true false 8 Double 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Latitude,-1,-1;Longitude "Longitude" true true false 8 Double 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Longitude,-1,-1;Incident_Number2 "Incident Number2" true true false 4 Long 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFC,Incident_Number2,-1,-1;Ward "Ward" true true false 256 Text 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\FireUpdate.gdb\DashboardAreas,Ward,0,256;Spec_Area "Special Area" true true false 256 Text 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\FireUpdate.gdb\DashboardAreas,Spec_Area,0,256;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\FireUpdate.gdb\DashboardAreas,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,\\gis\GIS\Projects\GIS\Fire\NightlyUpdate\FireUpdate.gdb\DashboardAreas,Shape_Area,-1,-1" Intersect # #
DeleteField \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFCwAreas Join_Count;TARGET_FID "Delete Fields"
CopyMultiple "M:\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFCwAreas FeatureClass" M:\GIS\Projects\GIS\ArcGISProProjects\MainMap\PublicSafetyPD.sde tempFCwAreas "tempFCwAreas FeatureClass PublicSafety.PD.tempFCwAreas #"
Rename M:\GIS\Projects\GIS\ArcGISProProjects\MainMap\PublicSafetyPD.sde\PublicSafety.PD.tempFCwAreas M:\GIS\Projects\GIS\ArcGISProProjects\MainMap\PublicSafetyPD.sde\PublicSafety.PD.FireCalls FeatureClass
Append M:\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFCwAreas M:\GIS\Projects\GIS\SDEConnections\PublicSafety@PD.sde\PublicSafety.PD.FireCalls TEST # # # "Incident_Number Incident_Number" NOT_UPDATE_GEOMETRY NO_ENFORCE_DOMAINS
Append \\gis\GIS\Projects\GIS\Fire\NightlyUpdate\Scratch.gdb\tempFCwAreas \\gis\GIS\Projects\GIS\SDEConnections\PublicSafety@PD.sde\PublicSafety.PD.FireCalls "Input fields must match target fields" # # # "Incident_Number Incident_Number" NOT_UPDATE_GEOMETRY
tempFCwAreas
002
Server=gis; Service=sde:sqlserver:gis; Database=PublicSafety; User=pd; Version=sde.DEFAULT
ArcSDE Connection
Geographic
GCS_WGS_1984
Angular Unit: Degree (0.017453)
<GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WKT>GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",4326]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>999999999.99999988</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.983152841195215e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4326</WKID><LatestWKID>4326</LatestWKID></GeographicCoordinateSystem>
20250521
16242800
20250521
16242800
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 14393) ; Esri ArcGIS 13.1.0.41833
FireCalls
File Geodatabase Feature Class
dataset
EPSG
6.2(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
tempFCwAreas
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
Join_Count
Join_Count
Integer
4
0
0
TARGET_FID
TARGET_FID
Integer
4
0
0
Incident_Number
Incident Number
Integer
4
0
0
Incident_Date
Incident Date
Date
8
0
0
Alarm_Time
Alarm Time
Date
8
0
0
Station
Station
String
8000
0
0
Incident_Address
Incident Address
String
8000
0
0
Incident_Type_Code
Incident Type Code
String
8000
0
0
Latitude
Latitude
Double
8
0
0
Longitude
Longitude
Double
8
0
0
Incident_Number2
Incident Number2
Integer
4
0
0
Ward
Ward
String
256
0
0
Spec_Area
Special Area
String
256
0
0
20250521
/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
KKKACiiigAooooAKKjkjaQxkSum1txC4+YehyOlSUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFF
FFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUU
UAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUyZpFiZooxI46K
W25/Gn0ARyiVgvlOqncC25c5XPI69fepKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKCcAnGaACimQyGWBJDG8ZZQSj/eX2PvT6ACikZ1
QAswUE4GTjmlJAGScCgCOKJYQwUudzFjuYnk+meg9qWORZVJQkgEqcjHI4qO2e2lEk9tIkgdvmdG
3AkcfpjFRrqdk+oNYLcxm7UbjDn5sdc0AWyMjFNjjWKJY1ztUYGSSfzNOooAKKKKACiiigBG3bG2
Y3Y4z0zQm7Yu/G7HOOmaWigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAopjSojIrMAznCg9zjP8AIGn0AV7sTGJPJjjkYSISJOm3IyR7gcivNfG/iuW11+fR
LtoJbERLK0ZDAyDOduUyVYY46epr0LWLu2tLJftciRwzSLCxZ2X73HBXnP5fWuevdY8LafMlkb11
mvpMrKjM5QgccnOBwBjoe9RP1Ezyibxtdaf4fn0jRrdbaKZPnI3g4bJLLkkL1x+Aqjb+J9b0y0tl
t9VuIrVn89Q7ZYAHGAT1Ht0r0/xJoOkDw7NrdhD9tWKGULGQT5hdwW3cggLzwMYrxPUdWlv7gOIY
YVQBFWFduFAxg9M1zzvHdkPQ9a8PfFC7mN1HqMSGc+WsMgkBiyQSoIHOT7Z5xwK9Ut5JJbeN5ovJ
kZctHuDbT6ZHWvmLR/CWr67FFdWCogRtvmTyLGA4GcAE5PGO1eu+CvFtnBZ6Zo8+rm/unPlMRC3y
OwLAM54OMEfl6VpTm/tFJ9z0WiiitygooooAKKKKACiiigAopCQCASMnoPWloAKKKYkUcbSMigGR
tzH1OAP5AUAPooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAQgEYIBHvTDb
wmXzTDGZMAb9ozgcjn8TUlFAEc0Mc8EkMi5jkUqw6ZB61nSeGdDkChtJs/lORiEDnGO3tWrTGEnm
oVZRGAdwK8n0we1KwHLar4NsNSlk+3XUkcRctbRxSeWE/dgH64254rK0T4eaZpAtGtdZuSY7qOZ1
83KO4XO0AYHOc85OK7t1l2TZZSefL2ryvHueTn6VFpy3QsoxfeW046si7c+hI7H2FLlVxWLdNeRI
9u91XcdoycZPpTqQgHGQDjmqGLRRRQAUUUUAFFFFADGhjeRJGjVnjzsYjlc9cU+iigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiikZgilmIC
gZJPYUALRSKyuoZSCpGQR3FLQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABR1oooAOlFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRR
RQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUyWMyx7RI8ZyDuTGeDnHPr0p9ABRRRQA
UUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABR
RRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/2Q==