20190514
08021300
1.0
FALSE
AddField H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp AREA DOUBLE # # # # NULLABLE NON_REQUIRED #
CalculateField H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp AREA [A_1] VB #
DeleteField H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp A_1
AddField H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp PERIMETER DOUBLE # # # # NULLABLE NON_REQUIRED #
CalculateField H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp PERIMETER [P_1] VB #
DeleteField H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp P_1
DeleteField H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp OID_
DeleteField H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp PRCL_ID_1
CopyFeatures H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\pbdata.shp H:/SDEPolyBase/BaseMap_Update/TempShpFilesSQL\prclbase.shp # 0 0 0
pbplnb5 H:\SDEPolyBase\BaseMap_Update\TempShpFilesSQL\pbdata.shp H:\SDEPolyBase\BaseMap_Update\MXDLocation\HDrive\CurrParcelMXDs\sdeUpdatePBPLNBSQL.mxd H:\SDEPolyBase\BaseMap_Update\TempShpFilesSQL
CopyFeatures prclbase T:\GIS_Projects\SEE_0073709_to\see0073742\see0073742.gdb\New_Drop_Boxes # # # #
FeatureToPoint New_Drop_Boxes T:\GIS_Projects\SEE_0073709_to\see0073742\see0073742.gdb\New_Drop_Boxes_FeatureToPoin CENTROID
DeleteField New_Drop_Boxes_FeatureToPoin POLY_ID
DeleteField New_Drop_Boxes_FeatureToPoin POLY_CLASS;POLY_CREAT;POLY_DESCR;EXCPTN_LIT;TAX_CD;TAXCDDESCR
DeleteField New_Drop_Boxes_FeatureToPoin USECD_1;USECDCL_1;USECDTY_1;USECDLIT_1;USECD_2;USECDCL_2;USECDTY_2;USECDLIT_2
DeleteField New_Drop_Boxes_FeatureToPoin ACREAGE;LEGAL_DESC;SUBDIV_LIT;NEIGHBORHD;ADDRSTNBR;HOUSE_SFX;ADDRSTDIR
DeleteField New_Drop_Boxes_FeatureToPoin ADDRSTPRFX;ADDRSTNAME;ADDRSTTYPE;ADDRSTPOST;ADDRUNITTY;ADDRUNITNB;ADDRFLOOR
DeleteField New_Drop_Boxes_FeatureToPoin STRUCT_VAL;LAND_VAL;YR_BUILT;WATERSRCCD;SEWERCD;DWELLUNITS;BEDROOMS;IMPR_SQ_FT;HO_XMPT
DeleteField New_Drop_Boxes_FeatureToPoin OWNER_NAME;MAIL_ADDR1;MAIL_ADDR2;MAIL_ADDR3;MAIL_ADDR4;TRA_PRI;TRA_SEC;JURS_LIT
DeleteField New_Drop_Boxes_FeatureToPoin SUPR_LIT;SCHL_DIST;FIRE_DIST;WATER_DIST;AREA;PERIMETER
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.3.0'><WorkspaceConnectionString>DATABASE=T:\GIS_Projects\SEE_0073709_to\see0073742\see0073742.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>New_Drop_Boxes_FeatureToPoin</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Location_Type</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_alias>Location_Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Location_Description</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Location_Description</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.3.0'><WorkspaceConnectionString>DATABASE=T:\GIS_Projects\SEE_0073709_to\see0073742\see0073742.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>New_Drop_Boxes_FeatureToPoin</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Unique_Id</field_name><field_type>LONG</field_type><field_alias>Unique_Id</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
Merge New_Drop_Boxes_FeatureToPoin;'Drop Box and Vote Center Locations' T:\GIS_Projects\SEE_0073709_to\see0073742\see0073742.gdb\Drop_Box_and_Vote_Center_Locations "OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,New_Drop_Boxes_FeatureToPoin,OBJECTID,-1,-1,Drop Box and Vote Center Locations,OBJECTID,-1,-1;PRCL_ID "PRCL_ID" true true false 50 Text 0 0,First,#,New_Drop_Boxes_FeatureToPoin,PRCL_ID,0,50,Drop Box and Vote Center Locations,PRCL_ID,0,50;PRCL_ADDR "PRCL_ADDR" true true false 116 Text 0 0,First,#,New_Drop_Boxes_FeatureToPoin,PRCL_ADDR,0,116,Drop Box and Vote Center Locations,PRCL_ADDR,0,116;ORIG_FID "ORIG_FID" true true false 4 Long 0 0,First,#,New_Drop_Boxes_FeatureToPoin,ORIG_FID,-1,-1,Drop Box and Vote Center Locations,ORIG_FID,-1,-1;Location_Type "Location_Type" true true false 50 Text 0 0,First,#,New_Drop_Boxes_FeatureToPoin,Location_Type,0,50,Drop Box and Vote Center Locations,Location_Type,0,50;Location_Description "Location_Description" true true false 255 Text 0 0,First,#,New_Drop_Boxes_FeatureToPoin,Location_Description,0,255,Drop Box and Vote Center Locations,Location_Description,0,255;Unique_Id "Unique_Id" true true false 4 Long 0 0,First,#,New_Drop_Boxes_FeatureToPoin,Unique_Id,-1,-1,Drop Box and Vote Center Locations,UNIQUE_ID,-1,-1"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.4.0'><WorkspaceConnectionString>DATABASE=I:\GIS_Projects\SEE_0073709_to\see0073742\see0073742.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Drop_Box_and_Vote_Center_Locations</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>DropBoxType</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Drop Box Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>VoteCenterStatus</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Vote Center Status</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Drop Box Locations" DropBoxType "Not on List 8/9/19" "Python 3" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.4.0'><WorkspaceConnectionString>DATABASE=I:\GIS_Projects\SEE_0073709_to\see0073742\see0073742.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Drop_Box_and_Vote_Center_Locations</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>VoteCenterDays</field_name><field_type>SHORT</field_type><field_alias>Vote Center Days</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Drop Box Locations" VoteCenterStatus 'Connection' "Python 3" #
CalculateField "Drop Box Locations" VoteCenterDays 3 "Python 3" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.4.0'><WorkspaceConnectionString>DATABASE=I:\GIS_Projects\SEE_0073709_to\see0073742\see0073742.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Drop_Box_and_Vote_Center_Locations</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>Place</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Place Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Vote Center Locations" VoteCenterDays '11' "Python 3" #
CalculateField "Vote Center Locations" VoteCenterDays '4' "Python 3" #
FeatureClassToFeatureClass Drop_Box_and_Vote_Center_Locations I:\Emma\Elections\Elections.gdb DropBox_VoteCenter # "OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,Drop_Box_and_Vote_Center_Locations,OBJECTID,-1,-1;PRCL_ID "PRCL_ID" true true false 50 Text 0 0,First,#,Drop_Box_and_Vote_Center_Locations,PRCL_ID,0,50;PRCL_ADDR "PRCL_ADDR" true true false 116 Text 0 0,First,#,Drop_Box_and_Vote_Center_Locations,PRCL_ADDR,0,116;ORIG_FID "ORIG_FID" true true false 4 Long 0 0,First,#,Drop_Box_and_Vote_Center_Locations,ORIG_FID,-1,-1;Location_Type "Location_Type" true true false 50 Text 0 0,First,#,Drop_Box_and_Vote_Center_Locations,Location_Type,0,50;Location_Description "Location_Description" true true false 255 Text 0 0,First,#,Drop_Box_and_Vote_Center_Locations,Location_Description,0,255;Unique_Id "Unique_Id" true true false 4 Long 0 0,First,#,Drop_Box_and_Vote_Center_Locations,Unique_Id,-1,-1;DropBoxType "Drop Box Type" true true false 255 Text 0 0,First,#,Drop_Box_and_Vote_Center_Locations,DropBoxType,0,255;VoteCenterStatus "Vote Center Status" true true false 255 Text 0 0,First,#,Drop_Box_and_Vote_Center_Locations,VoteCenterStatus,0,255;VoteCenterDays "Vote Center Days" true true false 2 Short 0 0,First,#,Drop_Box_and_Vote_Center_Locations,VoteCenterDays,-1,-1;Place "Place Name" true true false 255 Text 0 0,First,#,Drop_Box_and_Vote_Center_Locations,Place,0,255" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.4.0'><WorkspaceConnectionString>DATABASE=I:\Emma\Elections\Elections.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DropBox_VoteCenter</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>DropBox</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>DropBox</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>VoteCenter</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>VoteCenter</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PopUp</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>PopUp</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField DropBox_VoteCenter VoteCenter 'Yes' "Python 3" #
CalculateField DropBox_VoteCenter DropBox 'Yes' "Python 3" #
CalculateField DropBox_VoteCenter DropBox 'No' "Python 3" #
CalculateField DropBox_VoteCenter VoteCenter 'No' "Python 3" #
CalculateField DropBox_VoteCenter DropBoxType 'None' "Python 3" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.4.0'><WorkspaceConnectionString>DATABASE=I:\Emma\Elections\Elections.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DropBox_VoteCenter</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Election_ID</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Election_ID</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.4.0'><WorkspaceConnectionString>DATABASE=I:\Emma\Elections\Elections.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DropBox_VoteCenter</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>NormalHours</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>NormalHours</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ElectionDayHours</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>ElectionDayHours</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
DeleteField DropBox_VoteCenter Unique_Id
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.4.0'><WorkspaceConnectionString>DATABASE=I:\Emma\Elections\Elections.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DropBox_VoteCenter</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>VotingDates</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>VotingDates</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
FeatureClassToFeatureClass DropBox_VoteCenter I:\Emma\Elections\Elections.gdb PopUpV2 # "PRCL_ID "PRCL_ID" true true false 50 Text 0 0,First,#,DropBox_VoteCenter,PRCL_ID,0,50;PRCL_ADDR "PRCL_ADDR" true true false 116 Text 0 0,First,#,DropBox_VoteCenter,PRCL_ADDR,0,116;Location_Type "Location_Type" true true false 50 Text 0 0,First,#,DropBox_VoteCenter,Location_Type,0,50;Location_Description "Location_Description" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,Location_Description,0,255;DropBoxType "Drop Box Type" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,DropBoxType,0,255;VoteCenterStatus "Vote Center Status" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,VoteCenterStatus,0,255;VoteCenterDays "Vote Center Days" true true false 2 Short 0 0,First,#,DropBox_VoteCenter,VoteCenterDays,-1,-1;Place "Place Name" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,Place,0,255;DropBox "DropBox" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,DropBox,0,255;VoteCenter "VoteCenter" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,VoteCenter,0,255;PopUp "PopUp" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,PopUp,0,255;Election_ID "Election_ID" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,Election_ID,0,255;NormalHours "NormalHours" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,NormalHours,0,255;ElectionDayHours "ElectionDayHours" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,ElectionDayHours,0,255;VotingDates "VotingDates" true true false 255 Text 0 0,First,#,DropBox_VoteCenter,VotingDates,0,255" #
PopUpV2
002
0.000
file://\\SVDATA\SV-Shared\Emma\Elections\Elections.gdb
Local Area Network
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_California_II_FIPS_0402_Feet
<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.4.0'><WKT>PROJCS["NAD_1983_StatePlane_California_II_FIPS_0402_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-122.0],PARAMETER["Standard_Parallel_1",38.33333333333334],PARAMETER["Standard_Parallel_2",39.83333333333334],PARAMETER["Latitude_Of_Origin",37.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2226]]</WKT><XOrigin>-115211800</XOrigin><YOrigin>-93821500</YOrigin><XYScale>3048.0060960121918</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102642</WKID><LatestWKID>2226</LatestWKID></ProjectedCoordinateSystem>
20200108
15402300
20200108
15402300
Microsoft Windows 10 Version 10.0 (Build 14393) ; Esri ArcGIS 12.4.2.19948
Pop Up V2
Pop Up V2
Pop Up V2
File Geodatabase Feature Class
0.000
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
PopUpV2
Feature Class
0
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
PRCL_ID
PRCL_ID
String
50
0
0
PRCL_ADDR
PRCL_ADDR
String
116
0
0
Location_Type
Location_Type
String
50
0
0
Location_Description
Location_Description
String
255
0
0
DropBoxType
Drop Box Type
String
255
0
0
VoteCenterStatus
Vote Center Status
String
255
0
0
VoteCenterDays
Vote Center Days
SmallInteger
2
0
0
Place
Place Name
String
255
0
0
DropBox
DropBox
String
255
0
0
VoteCenter
VoteCenter
String
255
0
0
PopUp
PopUp
String
255
0
0
Election_ID
Election_ID
String
255
0
0
NormalHours
NormalHours
String
255
0
0
ElectionDayHours
ElectionDayHours
String
255
0
0
VotingDates
VotingDates
String
255
0
0
20200108