Intersect NETS DUNS_MOVE records with 2010 Census Tracts

[sjmelly]

Are we excluding NETS locations geocoded to ZIP Code or worse?

[stfran22]

I haven't excluded them yet. Might as well keep them in in case someone wants to do zip code level analysis?

[sjmelly]

We can keep them in the NETS dataset, but when we link to tracts do we think it will be accurate to include a ZIP code in the tract where it's centroid is located? Actually I'm not sure how ArcGISPro geocodes ZIP Codes they probably use ZIP Code point data not ZCTA centroids.

[stfran22]

I feel good about excluding them when we link to tracts.

[sjmelly]

For tract boundaries use ResearchAndData\UHC_Data\Census2010\Geodatabases\Census2010_US20230607.gdb\AlbersContUS\CT_2010_ContUSlandRepair. Repair geometry tool was used to remove self intersections from Ct_2010_ContUSland which may have been causing problems with the Zonal Statistics tool

[sjmelly]

consult with Brisa re. use of poor accuracy NETS locations in tract and buffer measures

[sjmelly]

-Use all records that were geocoded -Set environment to Albers USGS projection -Add XY coordinates -Save this feature class as record of geocoding results

[sjmelly]

@stfran22 When you did spatial join to tracts did you use "Closest" option? Are there records that fall outside tracts? Check the frequencies of matchcoderank for records that fall outside tracts. We may want to look at some examples of records with matchcoderank < 10 that fall outside of tracts

[stfran22]

Spatial and tabular versions of this dataset have been created. Spatial \\files.drexel.edu\colleges\SOPH\Shared\UHC\Projects\NETS\Data\NETS2019_Spatial\NETS_Locs.gdb\NETS_locs_CT10AEAC_20230627 Tabular \\files.drexel.edu\colleges\SOPH\Shared\UHC\Projects\NETS\Data\NETS2019_Python\NETS_locs_CT10AEAC_20230627.csv

Columns

• Address ID
• displayX
• displayY
• projX
• projY
• matchcoderank
• addr_type
• status
• score
• GEOID10
• ct10_distance
• ALAND10km (ALAND10 from census converted to km)
• area10km (sum of ALAND10 and AWATER10 from census converted to km)

Spatial join details:

[stfran22]

Spatial join completed. See #6 for more details on geocoding.