20230609
21224800
1.0
FALSE
FeatureClassToFeatureClass Census_Munis2 "C:\Working Map\Default.gdb" CensusMunicipalities_2020 # "GEOID "GEOID" true true false 10 Text 0 0,First,#,Census_Munis2,Census_Munis2.GEOID,0,10;NAMELSAD "Municipality" true true false 100 Text 0 0,First,#,Census_Munis2,Census_Munis2.NAMELSAD,0,100;Total_Pop "Total Population" true true false 4 Long 0 0,First,#,Census_Munis2,Census_Munis2.Total_Pop,-1,-1;Hispanic_or_Latino "Hispanic or Latino" true true false 4 Long 0 0,First,#,Census_Munis2,Census_Munis2.Hispanic_or_Latino,-1,-1;Not_Hispanic_or_Latino "Not Hispanic or Latino" true true false 4 Long 0 0,First,#,Census_Munis2,Census_Munis2.Not_Hispanic_or_Latino,-1,-1;Ages18_Over "Ages 18 and Over" true true false 4 Long 0 0,First,#,Census_Munis2,Census_Munis2.Ages18_Over,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Census_Munis2,Census_Munis2.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Census_Munis2,Census_Munis2.Shape_Area,-1,-1;Muni "Muni" true true false 8000 Text 0 0,First,#,Census_Munis2,MinorityRace.csv.Muni,0,8000;Minority_2020 "Minority_2020" true true false 4 Long 0 0,First,#,Census_Munis2,MinorityRace.csv.Minority_2020,-1,-1;Minority_2010 "Minority_2010" true true false 4 Long 0 0,First,#,Census_Munis2,MinorityRace.csv.Minority_2010,-1,-1;Minority_Percentage_Change "Minority_Percentage_Change" true true false 8 Double 0 0,First,#,Census_Munis2,MinorityRace.csv.Minority_Percentage_Change,-1,-1" #
CopyFeatures CensusMunicipalities_2020 "T:\Amanda\_SHP\New File Geodatabase.gdb\CensusMunicipalities_2020" # # # #
CopyFeatures Municipalities_2020 C:\Users\hagana\Documents\ArcGIS\Projects\MyProject\w2k12-arcgis.sde\delcogis.PLANNING.civic_Census_Data\delcogis.PLANNING.Municipalities_2020_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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686238755634736653566b555a6b534f397864666149585066376b314e4776584471374c577a586a4b6e66633d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterField><field_name>Total_Pop</field_name><new_field_name>Total_Pop_20</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AddField><field_name>MuniLabel</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Muni Label</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Total_Pop_10</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Total Population 2010</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Per_Pop_Change</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Percent Population Change 2010-2020</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686238755634736653566b555a6b534f397864666149585066376b314e4776584471374c577a586a4b6e66633d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterField><field_name>Total_Pop</field_name><new_field_name>Total_Pop_20</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AddField><field_name>Total_Pop_10</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Total Population 2010</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PercentPop_Change</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Percent Population Change 2010-2020</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Census Municipalities" PercentPop_Change "($feature.Total_Pop_20 - $feature.Total_Pop_10) / $feature.Total_Pop_10 * 100" Arcade #
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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6836553477476342544d596d6431304c6a70665a4e71513677434b5441686e6130644c4f65666a334d6d41553d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Race_One</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Population of One Race</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>White</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>White</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Black</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Black or African American</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Indian_Alaska</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>American Indian and Alaska Native</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Asian</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Asian</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Hawaiian</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Native Hawaiian and Other Pacific Islander</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Race_Other</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Some Other Race</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Race_Two</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Population Two or More Races</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6836553477476342544d596d6431304c6a70665a4e71513677434b5441686e6130644c4f65666a334d6d41553d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Race_One</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Population of One Race</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>White</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>White</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Black</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Black or African American</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Indian_Alaska</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>American Indian and Alaska Native</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Asian</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Asian</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Hawaiian</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Native Hawaiian and Other Pacific Islander</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Race_Other</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Some Other Race</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Race_Two</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Population Two or More Races</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686a6956614a2f6f6b69634674524e77485a5176426d424a656768636c634473767975427741653631546a733d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>White</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>White</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686a6956614a2f6f6b69634674524e77485a5176426d424a656768636c634473767975427741653631546a733d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>White</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>White</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686a6956614a2f6f6b69634674524e77485a5176426d424a656768636c634473767975427741653631546a733d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>White</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>White</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686a6956614a2f6f6b69634674524e77485a5176426d424a656768636c634473767975427741653631546a733d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>One_Race</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Population of One Race</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Black</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Black or African American</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Indian</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>American Indian and Alaska Native</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Asian</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Asian</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Hawaiian</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Native Hawaiian and Other Pacific Islander</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Other_Race</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Some Other Race</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Two_Race</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Population of 2 or more races</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68776e66372b6f72634d4d584152327a574e504a684e4f35576d6233584a494f32307338394636496c4f364d3d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Field</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e684e494c4976484e646d3176715a41634561536e776b586d742b776369796f685537776d676768464a3156383d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Field</field_name></DeleteField></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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e684e494c4976484e646d3176715a41634561536e776b586d742b776369796f685537776d676768464a3156383d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>PercentMinority</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Percent Minority</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PercentAge18</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Percent Ages 18 and Older</field_alias><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/2.4.0'><FeatureDataset>delcogis.PLANNING.civic_Census_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e684e494c4976484e646d3176715a41634561536e776b586d742b776369796f685537776d676768464a3156383d2a00;SERVER=w2k12-arcgis;INSTANCE=sde:sqlserver:w2k12-arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=w2k12-arcgis;DATABASE=delcogis;USER=Planning;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>delcogis.PLANNING.Municipalities_2020_1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Percent_Minority10</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Percent Minority 2010</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Percent_Minority20</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Percent Minority 2020</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PercentHispanic</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Percent Hispanic</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PercentAge18</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Percent Ages 18 and Over</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Census Municipalities" PercentAge18 "$feature.Ages18_Over / $feature.Total_Pop_20 * 100 " Arcade #
CalculateField "Census Municipalities" Percent_Minority10 "$feature.Minority_2010 / $feature.Total_Pop_10 * 100" Arcade #
CalculateField "Census Municipalities" Percent_Minority20 "$feature.Minority_2020 / $feature.Total_Pop_20 * 100" Arcade #
CalculateField "Census Municipalities" PercentHispanic "$feature.Hispanic_or_Latino / $feature.Total_Pop_20 * 100" Arcade #
Rename "C:\F\ArcGISPro_Projects\CountywideMapping\GIS Delcopa Planning.sde\PLANNING.civic_Census_Data\PLANNING.Municipalities_2020_1" "C:\F\ArcGISPro_Projects\CountywideMapping\GIS Delcopa Planning.sde\PLANNING.civic_Census_Data\PLANNING.Municipalities_2020" FeatureClass
delcogis.PLANNING.Municipalities_2020_1
002
Server=gis-sql-managed.ef1755ffe9e8.database.windows.net; Service=sde:sqlserver:gis-sql-managed.ef1755ffe9e8.database.windows.net; Database=GIS_PROD; User=Planning; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Pennsylvania_South_FIPS_3702_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_Pennsylvania_South_FIPS_3702_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",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-77.75],PARAMETER["Standard_Parallel_1",39.93333333333333],PARAMETER["Standard_Parallel_2",40.96666666666667],PARAMETER["Latitude_Of_Origin",39.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2272]]</WKT><XOrigin>-119214200</XOrigin><YOrigin>-96198500</YOrigin><XYScale>3048.0060960121918</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>102729</WKID><LatestWKID>2272</LatestWKID></ProjectedCoordinateSystem>
20211112
14305500
20211112
14305500
Microsoft Windows 10 Version 10.0 (Build 19042) ; Esri ArcGIS 12.4.0.19948
Map
delco
census
US Census Municipalities includes 2010 and 2020 population changes in Delaware County, PA
Enterprise Geodatabase Feature Class
dataset
EPSG
6.12(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
delcogis.PLANNING.Municipalities_2020_1
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.
GEOID
GEOID
String
10
0
0
NAMELSAD
Municipality
String
100
0
0
Total_Pop
Total Population
Integer
4
10
0
Hispanic_or_Latino
Hispanic or Latino
Integer
4
10
0
Not_Hispanic_or_Latino
Not Hispanic or Latino
Integer
4
10
0
Ages18_Over
Ages 18 and Over
Integer
4
10
0
Muni
Muni
String
1073741822
0
0
Minority_2020
Minority_2020
Integer
4
10
0
Minority_2010
Minority_2010
Integer
4
10
0
Minority_Percentage_Change
Minority_Percentage_Change
Double
8
38
8
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20211112
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooAKKKKACiiigAooooAKKKKACkJAGScCopJ0j46t6CqzyNJ948eg6VnOrGJLkkXEdXBKnOOKfVGN/Lk3HoeDV6inPnVxp3CiiitBhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABTWG5SMkZHUU6oZphGMDlj+lJtJXYFQgqSpGCDzRTXJDeYSTn73+NOrzXa+hgwqzbyceWe3T6VWpC5jIYfezwBV058shxdmaVFVopyz4YAA9MVZrujJSV0ap3CiiiqGFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBXmnCHapBf+VVu5JOSepqzPLGisGAY45AqqOgrjr3vuZz3FqMMI8qx4HIPtUlR/6xh/dBzn1NYECF2J6bF9SP8AOKeqgHPU+pp1MThmXsORQA/rVuGXzFwT8w6+9VKPM8pg+cEH8/atKU+VlRdmaNFFFd5qFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFQSzhCVUZb9BSlJRV2JuxKzKi5Y4FVXnZ+E+VfXuah3mX52Jz6HtS1yTrt6RIcuwVHu8ttpBK4yMc4qSog4EjHBIP8Q6D2rAgX/Wj0T/0L/wCtUnSmCNR0GPocUZKYDnI/vY/nQA+mdJRjoQc/pTmYKhY9qjaMkBiNzdx6j0oAdvLf6vn/AGj0/wDr0oQA5PJ9TQHGQCpGemaGYghVHJ7noKAJFllUYVgfQNzVm3d5I9z4zntWbI7QtksSCM9M8/5NXLaYBQjKV5OCa6aM3ezZcX3LlFFFdRoFFFFABRRRQAUUUUAFFFFABRRRQBG0iowUnlulVHcyNuKhT0IBpZm3ysSOny9aZXHWq3vEzlK+gwod2VbGevFIH2nY2Sw6cdRShw2Qp5xwcURYxn+Lo2etYEBtZ/v8D+6P604qCu3HGMYpaKAGK2FO4/dPNHmDB3AjHY96bIuPmBwMjP8AjQoZpNxwduRkDrQARLkDceV4A9KlqM5EuFxlh39v/wBdMkk2rh2wQRyOP896AHS7iyBevX+X9CajbJwVLAKeST09aeQ4UyE8gHAPp/jTSVXD/Mwzk8cU0ALltzKN23oW6/TFXLdFkYseQOn1qo3JD71VsZUf41eslxBv5y5zzWtGN5FRWpaooortNQooooAKKKKACiiigAooooAKoXExPGAEVuT3+tSzTkHah6dTioOvXmuatV+yjOUuiGlwvAGT6Ck2FuX/ACHSkjAQlPxFSVykDXUsODhh0NMVEYBhkN3OefxqWo2JQ7gMg8Ee9AAHKsynLY7gfpTlcMSBkEeoxQi7Vx36k0jhhl05OOh70AOPQ8Z9qgjUIECEhujD9TmpS+7hOp/SmHEMm7aTuAHHrzQA6Rgjq2D6HFJ5Ydi7DHp/jQzq4AXJJPBx0/GnPgsoY4XnPvQAwncvlxkH5epoyxRVPIYfe9qGLFgVxnoox1Hf8KVYjgBm+VemDigBY42WTYij5zwc9OP/AK1aaqFUKOgGKzkBRw27O3oDVgXL85Ue2K6KM4xWu5cWkW6Kpi4kBG7aRnnirYORkdK6ITU9i00xaKKKsYUUUUAFFFFABRRRQBnswZmYDAJyKSnOPnk2r8qnt2qNySh2nmvPnF8xi07jT80mM424IxUlMBVEzgj2xzSBnbptA+uTUNMQ9mC9ep6AdTUb5KEsOP7v+NPVQvue5PU0O21c4yc4xQA0KyDIO4dSv+FO8xcZz+HehFKoqnqBilwM5wM+tAEZOcsFcEjqMc0wlnUFiFxkZAzk08kpIFXbhucE9DSovzlygXj9e9MBVIlTke1NVAyfMST35qZQWbaoyasR20acn5ieT6flVwpueo1Fsoqcy4J5QEfnjFS1eEaAYCqB9KTyo/7if981r9X8yuQpZHrT1ikboh+p4q4FVfuqB9BTqpYdLdjUCulsBy53H07VYooraMVFWRSVgoooqhhRRRQAUUUUAFFFFACAAdBS0UUAFNKq33lB+op1FAEJt4z/AA4+hqGS0Y4KOODnkVcoqHTi+gmkZr5jOGVgT7f1pjM2BnCA/ia0yoYYIBHvVaS1AJePr6H+lc88O18JDh2KaLlSjryRnJ6mpoQ0mFA+bv7UqwNKwyCoB+8RirqRqi7VGBSp0XLWWwoxvuJHEsa4HU9T61JRRXWlY1CiiimAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/2Q==