search

GreenInfo-Network / Stanford-BOE2017

0 stars 0 forks source link

Retailer to School (Euclidean) #13

Closed AmandaGIN closed 6 years ago

AmandaGIN commented 6 years ago

Generate a table of schools that are within 1/2 mile buffer of retailers

Generate Near Table Input Features: P:\proj_p_s\Stanford_PRC\BOE_2017\data\BOE2017_2018_01_17.shp (pnt) Near Features: P:\proj_p_s\Stanford_PRC\BOE_2017\data\Schools\CSCD_2016_publicSchools_K12.shp (poly) Output: P:\proj_p_s\Stanford_PRC\BOE_2017\data\Retailers\gennear_retailpntschlbndry Search Radius: 0.5 miles Uncheck all 3 boxes (location, angel, find only closest feature) Maximum number of closest matches: default (no limit) Method: PLANAR

AmandaGIN commented 6 years ago

In output table, code the starting place IN_FID back tot he unique retailer license number:

AmandaGIN commented 6 years ago

QA/QC on Euclidean results:

Long Form: 1) There are the correct number of unique retailers (33,044) 2) Using a buffer (half-mile) of retail points, run a 'select if intersect' with 'school polygons' There are five additional schools in the cost matrix vs. the spatial join: LicenseNum | SpatialJoin | Cost Matrix 91216350 | 3 | 4 91234317 | 3 | 4 91360862 | 2 | 3 91375325 | 2 | 3 91388890 | 8 | 9 91389633 | 1 | 2 In each case, verified that there is a school boundary right on the edge of the half-mile buffer. In the cost matrix it is included. The additional 6 were kept in the final table.

Matrix: 1) There are the correct number of unique retailers (33,044) 2) There are the same number of 'near' schools as the Long Form (69,171)

AmandaGIN commented 6 years ago

QA/QC on Network Analyst results: Long Form: 1)There are the correct number of unique retailers (33,044) 2)Using the cost matrix there are 27,766 school instances. A comparable method of looking at service area polygons out of SMP generated a similar (but known to contain some errors) figure. 27,766 confirmed as most accurate result.

Matrix Form: 1)There are the correct number of unique retailers (33,044) 2) Proper schools of (27,766)

AmandaGIN commented 6 years ago

File sent to client on dropbox: https://www.dropbox.com/s/dsbhj3it0g50edm/Retailers_to_Schools_HalfMileNetworkAndEuclidean.xlsx?dl=0

On server: P:\proj_p_s\Stanford_PRC\BOE_2017\data\Retailers_to_Schools_HalfMileNetworkAndEuclidean.xlsx

AmandaGIN commented 6 years ago

Added the geographic jurisdiction information (city name, city fips, county name, county fips - incorporate or unincorporated). Using P:\proj_p_s\Stanford_PRC\SmokefreeLoopholes\data\C_Merge_CityIncorp_CountyUnincorp.prj

Also included tab of table field attributes