20230609
21224300
1.0
FALSE
FeatureClassToFeatureClass Blocks_2020 "T:\Amanda\_SHP\New File Geodatabase.gdb" Blocks_2020 # "GEOID "GEOID" true true false 16 Text 0 0,First,#,Blocks_2020,Blocks_2020.GEOID,0,16;NAME "NAME" true true false 11 Text 0 0,First,#,Blocks_2020,Blocks_2020.NAME,0,11;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Blocks_2020,Blocks_2020.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Blocks_2020,Blocks_2020.Shape_Area,-1,-1;GEOCODE "GEOCODE" true true false 8 Double 0 0,First,#,Blocks_2020,Blocks_2020.GEOCODE,-1,-1;OID "OID" false true false 4 Long 0 9,First,#,Blocks_2020,Race1.OID,-1,-1;GEOCODE_1 "GEOCODE" true true false 16 Text 0 0,First,#,Blocks_2020,Race1.GEOCODE,0,16;Total_Popu "Total_Popu" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.Total_Popu,-1,-1;Population "Population" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.Population,-1,-1;White "White" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.White,-1,-1;Black_or_A "Black_or_A" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.Black_or_A,-1,-1;American_I "American_I" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.American_I,-1,-1;Asian "Asian" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.Asian,-1,-1;Native_Haw "Native_Haw" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.Native_Haw,-1,-1;Some_Other "Some_Other" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.Some_Other,-1,-1;Populati_1 "Populati_1" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.Populati_1,-1,-1;Total_Mino "Total_Mino" true true false 10 Long 0 10,First,#,Blocks_2020,Race1.Total_Mino,-1,-1;OID_ "OID_" true true false 4 Long 0 0,First,#,Blocks_2020,hISPANIC2.CSV.OID_,-1,-1;GEOCODE_12 "GEOCODE" true true false 16 Text 0 0,First,#,Blocks_2020,hISPANIC2.CSV.GEOCODE,0,16;Hispanic_or_Latino "Hispanic_or_Latino" true true false 4 Long 0 0,First,#,Blocks_2020,hISPANIC2.CSV.Hispanic_or_Latino,-1,-1;Not_Hispanic_or_Latino_ "Not_Hispanic_or_Latino_" true true false 4 Long 0 0,First,#,Blocks_2020,hISPANIC2.CSV.Not_Hispanic_or_Latino_,-1,-1;OID1 "OID_" true true false 4 Long 0 0,First,#,Blocks_2020,Ag1e18.csv.OID_,-1,-1;GEOCODE_12_13 "GEOCODE" true true false 16 Text 0 0,First,#,Blocks_2020,Ag1e18.csv.GEOCODE,0,16;Age18 "Age18" true true false 4 Long 0 0,First,#,Blocks_2020,Ag1e18.csv.Age18,-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=T:\Amanda\_SHP\New File Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Blocks_2020</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>OID_1</field_name><field_name>GEOCODE_1</field_name><field_name>OID_</field_name><field_name>GEOCODE_12</field_name><field_name>OID1</field_name><field_name>GEOCODE_12_13</field_name></DeleteField></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.8.0'><WorkspaceConnectionString>DATABASE=T:\Amanda\_SHP\New File Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Blocks_2020</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</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Percent18</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 Blocks_2020 PercentMinority "$feature.Total_Mino / $feature.Total_Popu * 100" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Blocks_2020 PercentHispanic "$feature.Hispanic_or_Latino / $feature.Total_Popu * 100" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Blocks_2020 PercentHispanic "$feature.Hispanic_or_Latino / $feature.Total_Popu * 100" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Blocks_2020 Percent18 "$feature.Age18 / $feature.Total_Popu * 100" Arcade # Text NO_ENFORCE_DOMAINS
CopyFeatures Blocks_2020 C:\Users\hagana\Documents\ArcGIS\Projects\MyProject\w2k12-arcgis.sde\delcogis.PLANNING.civic_Census_Data\delcogis.PLANNING.Blocks_2020 # # # #
delcogis.PLANNING.Blocks_2020
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
14304000
20211112
14304000
Microsoft Windows 10 Version 10.0 (Build 19042) ; Esri ArcGIS 12.4.0.19948
Map
delco
census 2020
2020 census blocks with demographic data for Delaware County, PA.
Enterprise Geodatabase Feature Class
dataset
EPSG
6.12(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
delcogis.PLANNING.Blocks_2020
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
GEOID
GEOID
String
16
0
0
NAME
NAME
String
11
0
0
GEOCODE
GEOCODE
Double
8
38
8
Total_Popu
Total_Popu
Integer
4
10
0
Population
Population
Integer
4
10
0
White
White
Integer
4
10
0
Black_or_A
Black_or_A
Integer
4
10
0
American_I
American_I
Integer
4
10
0
Asian
Asian
Integer
4
10
0
Native_Haw
Native_Haw
Integer
4
10
0
Some_Other
Some_Other
Integer
4
10
0
Populati_1
Populati_1
Integer
4
10
0
Total_Mino
Total_Mino
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
Age18
Age18
Integer
4
10
0
PercentMinority
Percent Minority
Double
8
38
8
PercentHispanic
Percent Hispanic
Double
8
38
8
Percent18
Percent Ages 18 and OVer
Double
8
38
8
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
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+iiigAooooAKKKKACiiigAooooAKKKKACmkhQSxAA6k1Vu7+C0BDHc/9xeT/APWrDur6a74f5U/uA8de9NRbNIU3I6OGeKdS0ThwDgkVLXN6deC2mUNtVG+Vsfz/AM+9dJQ1YU4cjsFFFFIgKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKY670ZQxUkYyOop9Ur2+S0TGQZCMgenuaBpNuyOflgeGZ45fvZHzetQbD0IbavfpViUyuxnkLbm5yaVfnG7h3fP4GtjuSdtSqCxbeQBjp/jW/o1958Pkv99Bx7isQKpkYZYJ1UEVJHLJbMk4BG3pjofrSauiZw5kdbRWRZ6uLi5MTqEB+59fQmtesmrHHKLi7MKKKKBBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAUb2/W3GxCDJ79F+tYcrrMpmz+9BGSfWtu8ntIlYSIsjHqABn8fSsAOOdqA4GclTzWkDqoLTYa8vmEMTg9MDsKarsjfIdvJz9KXb5smZDjJ7U1wTIU3DA7478VRsBbd1JKjuf1/zinumBneSq8Y9KYCfLUgj9KZucDAJKAk4A6f56UAObhtyMOuOD+NdRY3i3UX3syJw4/rXLEbABkBe5z1PbNWLGdrSZZQe+CvqKUldGdSHMjraKKKyOMKKKKACiiigAooooAKKKKACiiigAooooAKKKpXd+kDGJfmlx07D600rjSbdkWZJUhjLyMFUdSayp9SadmjgOxR1b+I/wCFUJZ3ncSTvuIP3D0H4U2RvueSwB9AOoq1HudMKKWshssJAJOG5OGPb6mojMQjhgTxtGO31qYEy443bh1J6e9McYdmfDcD5x0BqzcYfmyzEk5H1IoCs5LdFAwARmhBuDhdwBOAAehp7ABWyoCg43KOvakIgYEMQhB+lABBA5welStiL94Xw45C98U1gWUyEhmPJwOFoAapUocrnGRu6DP9aVAybSpA68kdaFIKKu/b6tk5pv3cbTx+efz/AAoA0odVuY4l2lWHo55ArZsJ3uLVZZAoJJ+70rlhwgVSFBODg9RW5pl/EsSWzgqV4DEYBqJLQwqwVrpGvRRRUHMFFFFABRRRQAUUUUAFFFFABRRRmgCGW4jhdEdsM/Cj1rAvLpp5tzwbGUbGBbvTtRm8y9+5ygKjBz0/z+lV03NIJHyzHoTxz9a0iranVSp2tIajurbc7dwzz1ppO0Y5JY9cfezTseY2Tjk7gxHH69RTBmZsk4AHPvVm45AQikYweAP8ac2EcbkBwCOD3pjZIbCjd3C+1MLttH7zA9cZoEIGYqCo46E54+n86XYuRv3evc7jTRnO4EEIMnOKfNI0hUrw31pAMVMRnGS4OMDrx3o4DYO7mkVZSSFIx39KUZ3EE89+OKAHE/KAhJ/XH+f60wKScDOOpx6YpoOTgjHFPVgD2zjv0oAF5YApwexNauk2yXDySSpuWNvk+tZm8hVAHHcYrotJVvse9ursSB6UpPQyqu0TQooorI5AooooAKKKKACiiigAooooAKwNUvpHJhRAqK33iecjv7Crl7qHlkLC43KcNxxn0rImniLgllbf8zH1q4x6s6KVPqyMfu5MOuQBk45FAkMjBNwAHTJ6U1GLQum5VAwQKbtyNwQYzzk54rQ6BS7PnqSe+f0/pQCHxnG71B5JpFCsSZeewIHanbioLDOOo9fxpAIxMamPn/gPX8aYUIOSvTHGKfjaMsMc8E0bsfOWJwAcEdfagBuQoGAdpzgnHNINhC7hjAwQRntzUkm0hSSASfXp+H6VEBzySO5wc0AOAA/h+Xv7e1KEUShSPl680kh52hjj+EelIW2rnavXJJ4oAdMAB8pJQfj9abkAbsdPQevvQzhpeq7SOme1Jnk5Und+FAE1tC8tyqIBhugxgA/5/lXWRIIolQdFAFcrbPPFMssaKdpBAPcc1rx6nNtbzIkB/hwen1qZJsxqwlJ6GtRWOuqyiZUZUYZ+YgHgVrAggEHIPSoaaOeUHHcdRRRSJCiiigAooooAKQkAEk4A70tIQCCCMg9qAOXcR3M8kwiBDsSvUAD1/GmiNU+RY8tjDfSrs0A86X7OpVIzghOg/wA81UDuyHZnPc46n0FbJqx3QasQbFSUDcCqgHp79KQF1346dGqWaMgD5CPUbTn8TUK/KudpyT36mgokkTgbhjjr3aocrgg556gdMVYYoylTyf7zDkfWod3ykAZUHOf8aYCqh8rep5XqDzjvxTMbhuyOud2KTuNuQelPUlZA4IwvAz6e9IBpXGDnqO3anIQF3kZX+Y/pTnDO/wAu1s+h6UqwLgOTuII+92pgAUTK4yFw2cjn9ajVcuAIwx65zzVqKB7uURxJ/vH/AD0rbg0yCFfmBdupJPFS5JETqKO5z/2dWbaVzjOc49sULCSQBhOoyFHNdUIYgMCJAPTaKb9ngznyY8/7opc5n9YXY5yNHjbYCpJHBOeaspZXk/BXYvtx+p/wrdVET7qqv0GKfScyXXfRGdbaZHAAWwx/ugcfj61o0UVLdzGUnJ3YUUUUhBRRRQAUUUUAFFFFADQAM4AGeTTqKKACmNGj/eVW+ozT6KAKcmm2kg/1QX3Xis+40IkkwyAj+64/rW5RTTaLU5LZnIS2s1s2Z0Yc9OufoajkGRzhR6dTiuxZFdSrKCD2NZd1pKkF7fhuoQ9Pwq1LubRrJ6SMRCdrfNyBuK55P+FWbe0mu3VQAoHBGOFFWbXTZHYbwygHliMflW1DCkMYRBgevc0SlYc6qWiG29sltHsTk92PU1PRRWZyt3CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP/2Q==