20230609
21223500
1.0
FALSE
FeatureClassToFeatureClass "Census Block Groups 2020" "C:\Working Map\Default.gdb" BlockGroups # "GEOID "GEOID" true true false 12 Text 0 0,First,#,Census Block Groups 2020,BlockGroups_2020.GEOID,0,12;NAMELSAD "NAMELSAD" true true false 13 Text 0 0,First,#,Census Block Groups 2020,BlockGroups_2020.NAMELSAD,0,13;GEOCODE "GEOCODE" true true false 8 Double 0 0,First,#,Census Block Groups 2020,BlockGroups_2020.GEOCODE,-1,-1;Total_Pop "Total Population" true true false 4 Long 0 0,First,#,Census Block Groups 2020,Hispanic.txt.Total:,-1,-1;Hispanic_or_Latino "Hispanic or Latino" true true false 4 Long 0 0,First,#,Census Block Groups 2020,Hispanic.txt.Hispanic or Latino,-1,-1;Not_Hispanic_or_Latino_ "Not Hispanic or Latino" true true false 4 Long 0 0,First,#,Census Block Groups 2020,Hispanic.txt.Not Hispanic or Latino:,-1,-1;Age_18Plus "Age 18 and Older" true true false 4 Long 0 0,First,#,Census Block Groups 2020,Age18.txt.Total:,-1,-1;Population_of_one_race "Population of one race" true true false 4 Long 0 0,First,#,Census Block Groups 2020,race.txt.Population of one race,-1,-1;White "White" true true false 4 Long 0 0,First,#,Census Block Groups 2020,race.txt.White,-1,-1;Black_or_African_American "Black or African American" true true false 4 Long 0 0,First,#,Census Block Groups 2020,race.txt.Black or African American,-1,-1;American_Indian_and_Alaska_Native "American Indian and Alaska Native" true true false 4 Long 0 0,First,#,Census Block Groups 2020,race.txt.American Indian and Alaska Native,-1,-1;Asian "Asian" true true false 4 Long 0 0,First,#,Census Block Groups 2020,race.txt.Asian,-1,-1;Native_Hawaiian_and_Other_Pacific_Islander "Native Hawaiian and Other Pacific Islander" true true false 4 Long 0 0,First,#,Census Block Groups 2020,race.txt.Native Hawaiian and Other Pacific Islander,-1,-1;Some_Other_Race "Some Other Race" true true false 4 Long 0 0,First,#,Census Block Groups 2020,race.txt.Some Other Race,-1,-1;Population_of_two_or_more_races "Population of two or more races" true true false 4 Long 0 0,First,#,Census Block Groups 2020,race.txt.Population of two or more races,-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.8.0'><WorkspaceConnectionString>DATABASE=C:\Working Map\Default.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>BlockGroups</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>PercentMinority</field_name><field_type>DOUBLE</field_type><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>PercentHispanic</field_name><field_type>DOUBLE</field_type><field_alias>Percent Hispanic or Latino</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_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 BlockGroups PercentMinority Sum($feature.Black_or_African_American,$feature.American_Indian_and_Alaska_Native,$feature.Asian,$feature.Native_Hawaiian_and_Other_Pacific_Islander,$feature.Some_Other_Race)/$feature.Total_Pop Arcade # Text NO_ENFORCE_DOMAINS
CalculateField BlockGroups PercentMinority "Sum($feature.Black_or_African_American,$feature.American_Indian_and_Alaska_Native,$feature.Asian,$feature.Native_Hawaiian_and_Other_Pacific_Islander,$feature.Some_Other_Race)/$feature.Total_Pop *100" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField BlockGroups PercentHispanic "$feature.Hispanic_or_Latino / $feature.Total_Pop * 100" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField BlockGroups PercentHispanic "$feature.Hispanic_or_Latino / $feature.Total_Pop * 100" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField BlockGroups PercentHispanic "$feature.Hispanic_or_Latino / $feature.Total_Pop*100" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField BlockGroups PercentAge18 "$feature.Age_18Plus / $feature.Total_Pop * 100" Arcade # Text NO_ENFORCE_DOMAINS
CopyFeatures BlockGroups "T:\Amanda\_SHP\New File Geodatabase.gdb\BlockGroups" # # # #
CopyFeatures Block_Groups_2020 C:\Users\hagana\Documents\ArcGIS\Projects\MyProject\w2k12-arcgis.sde\delcogis.PLANNING.civic_Census_Data\delcogis.PLANNING.Block_Groups_2020_1 # # # #
Rename "C:\F\ArcGISPro_Projects\CountywideMapping\GIS Delcopa Planning.sde\PLANNING.civic_Census_Data\PLANNING.Block_Groups_2020_1" "C:\F\ArcGISPro_Projects\CountywideMapping\GIS Delcopa Planning.sde\PLANNING.civic_Census_Data\PLANNING.Block_Groups_2020" FeatureClass
delcogis.PLANNING.Block_Groups_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
14303100
20211112
14303100
Microsoft Windows 10 Version 10.0 (Build 19042) ; Esri ArcGIS 12.4.0.19948
Map
delco
census
US Census Block Groups 2020, in Delaware County PA
Enterprise Geodatabase Feature Class
dataset
EPSG
6.12(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
delcogis.PLANNING.Block_Groups_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
12
0
0
NAMELSAD
NAMELSAD
String
13
0
0
GEOCODE
GEOCODE
Double
8
38
8
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
Age_18Plus
Age 18 and Older
Integer
4
10
0
Population_of_one_race
Population of one race
Integer
4
10
0
White
White
Integer
4
10
0
American_Indian_and_Alaska_Nati
American Indian and Alaska Native
Integer
4
10
0
Black_or_African_American
Black or African American
Integer
4
10
0
Native_Hawaiian_and_Other_Pacif
Native Hawaiian and Other Pacific Islander
Integer
4
10
0
Asian
Asian
Integer
4
10
0
Some_Other_Race
Some Other Race
Integer
4
10
0
Population_of_two_or_more_races
Population of two or more races
Integer
4
10
0
PercentMinority
Percent Minority
Double
8
38
8
PercentHispanic
Percent Hispanic or Latino
Double
8
38
8
PercentAge18
Percent Ages 18 and Over
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+iiigAooooAKKKKACiiigAooooAKKKKACkJAGScCoJruOAYJLN/dXk1lzXk1wT/CoOAq8g/WpckjGpWjD1NiOVJVJRgwBxxUlYlpdiOZd/yhuGzW3RF3Q6VT2kbhRRRVGoUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU1huUrkjIxkdqdVe5uBAuBguegobsKUlFXZjyx+XNIrkq2c7s9T/X/AOvUaIWDFQF9+9SyktIJWJPPP+NI4b5tozuHr0PrXMeRJpvQi4Cq6uDj1XJNaunXIlj8ok7lAxnqRWaw2ycfxDsOfpQm63kSRMK+cBR3+tVF2ZdKpySudFRVC2v/ADpijLtHb2PpV+tk09j04TU1dBRRRTKCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAq3N2sPyrgyHt6VmOu9i5J3n+KtO5uIolYON5xyo61khyyjb6fePT/69ZVNzz8U3zWuHm4Byp469MfrTFkxld64AyCOfwpNrNIHyME4GV68daTLHJBVtpznpurM5h2T5g3My+hP+cU51VULZ9Dkn3pgmG4sQCCAODUUjYwEJ64AOCBQBK7MWDoOD79a2bK6FzACT8w6/wCNc+OOGYDOckjNWbWQwSAr2PdjyPTFXF2ZtRqckvI6Kiiitj0wooooAKKKKACiiigAooooAKKKKACiiigAooqrcXaxEovzP6dh9aG7Eykoq7J3dUUsxAA7ms+a+Z2KRgquPvdz/hVdpnnO9yc+npUUgO9SGIzkcVlKd9EcNTEuWkdBShHzKTu9z1qIsQpQKSpH/fNTqdyA+ozULFfMLAnnjcD0/wAazOYcxEi7m/1a8/71NZGzuKruzx/hQy7VxsIzxlTxQ+9duWyAeuP50ANePDksVBYcH0/+vTSAyrt2hcHI3elTOoVN+SSvIJNRuF2mTAZupwOKAIwFKYC5HYdAfqaEP7zC7iQeDj0H+e9I8R6tlBnuM0by2B1PcAUxlqLVp4/lwH54z1rXsp2uLZZXABbsK5soN2D2H15Hatywu4zCkZBXHAJ71pGWup10Kr5rSZo0UUVodoUUUUAFFFFABRRRQAUUUUAFFFFAETzIjKrHDN0HrWTPcPNJkwlWX5Tz1qW7k8y4bIxt+XrVcsRIdzEhuck96xnK+h59etzXghnJk4yhI54zmjeBlH5PbjrSlhJgKSD1U4oRVdCCOejc85qDlGhWGA3CE4256fjTsBmCgDavBprPmNlPLj07Y705Q4XA2qPzoAbk7Sh4C8Mx9KYpU8FmwP8AaOTnpSspYkhspkA56E0Iu2QMcEAld2f8/SgYAEhMthwcBR/Oo9x3bSTgHnHfmpZuGypxuHzEf596iOwA5fLZHTgYpjAkFRtx16AYH6+1NCliWII7nJx04PWgk7N5zjsc9KbkFOSxPXb/AFoAfn5eBgAnGT+n/wBetDTIUlkeUr8owAvoetZxXzMFnJI9e3vW3pcXl2YP985qoLU3w8bz1L9FFFbHohRRRQAUUUUAFFFFABRRRQAVlXl2WyoUBUbk9+O/tU91eBCFjYZB+YkcfSs95VySzZY8+5rOcuiOPEVvsxYxzGpyQCfSmhN6gF/u84I6elIS0asvCDqoPU0RjdltocE+uTWRxClzKoCEBuuc0oVTyitu7nOOfenM8bDGNx9AOaaA0eSeQ3b0NACBvKDAgvjqQO/vSqRj942AuOCMf/rpW2oEViAC2ST370NzLlCpIXvQIYWw20Z2HOAO+O1N8tNi4XDdCMVI7AqAnDA+nSoGBAJUHceM9Oec/wBKYyR9u2N1G3dwcD9KYcjMmAecD+ef1pQ6lChGc44A6Gm/eGTwAMAHpnsKBiDONobqv1/zmj7owP4jn8O+aeyu3y45I4P+e1CDZkHIC/N1x1oAktYXaYKmMMcA54/zxXQqoRAo6AYFYSSNHMrL8+35hn/PNXU1ByG3xAH+HB/nVwkludOHqQinfc0qKzUv3yN4XGeSOOK0QcjI6VopJ7HXTqRmrxFooopmgUUUUAFFFFABRRRQBiTbJZXcIuGPYdRUKEqoQL8w46cfWrUseZJDGvyocHA6VCwZkOzrjg1ztO55M4y5nciYkPh3UYwRxzSAMFDYK4GGPc+9PZdiqwRgQQTwc0jNIeAowffJpEWaBgkfIO1vzzQ24oS44/uj+tJ8oXYqncRj5hTiWjXsw6cnmgRGFZd+0gnuAO3tSAKpUkgKARxnINBBCrkFSq884z7VJgbwVyxH+etAxnAjZm3YP8XqPpUWz90G4UdM45zUkm4ErkYPJA7VGThwUXHABxg0wQ0DaASOvG4mpoYw65YkgHI5I5qSC1aUiPG7uV7fU1qxWMUQy3zMeTnp+VNRcjanRlU2MgkmQKQW25749MU9YxuLFAOMetbojQDARQPpTfJizny0z/uir9mbfVH3MRABKVAJJ6f4VZS2mk6IQPVuK1Qqr91QPoKdQqa6lRwkV8TuU4bJUIaQ729McVcooq0ktjpjCMVaIUUUUygooooAKKKKACiiigBAAOg60tFFABTWRW+8oP1FOooArNZQNz5YU+q8VVm00sB5bg4OcNWnRScUzOVGEt0c/LC8bbJVfbngdc/jTCWjTqFXsCea6FlDAhgCD2NUZtPXJeHhv7p/p6Vm4W2OWphWtYmWoLqU+UZGcnkmpbS3aU/KBu6MccLU8NizscqyLuySev4VqRRJCgRBgUowvuTSw7lrLYSGFIE2qOe57mpaKK2O9JJWQUUUUDCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA//Z