units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, MNG_AGENCY = 372 and YR_EST = 1984
This data as json, copyable, CSV (advanced)
DES_TP 2
- Local Park 3
- None 1
MNG_AG_TYP 1
MNG_AGENCY 1
- Newark, City of · 4 ✖
ACCESS_TYP 1
- Open Access · 4 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8297 | 8297 | 8296 | {"type": "Polygon", "coordinates": [[[-122.02239, 37.53645], [-122.02193, 37.53702], [-122.0216, 37.53688], [-122.0216, 37.53681], [-122.02155, 37.53674], [-122.02091, 37.5364], [-122.02082, 37.5363], [-122.02073, 37.53612], [-122.02064, 37.536], [-122.0205, 37.53588], [-122.0203, 37.53577], [-122.02028, 37.53573], [-122.02049, 37.53547], [-122.02239, 37.53645]]]} | Open Access 1 | 12790 | Byington Park | 16617 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 2.957 | Byington Park | 1984 | Local Park 2 | 4 | |
8313 | 8313 | 8312 | {"type": "Polygon", "coordinates": [[[-122.05539, 37.53459], [-122.05494, 37.53486], [-122.05338, 37.53409], [-122.05373, 37.53374], [-122.05382, 37.53347], [-122.05426, 37.53356], [-122.05443, 37.53361], [-122.05462, 37.53369], [-122.05477, 37.53378], [-122.05494, 37.53391], [-122.05514, 37.53414], [-122.05539, 37.53459]]]} | Open Access 1 | 12763 | Bridgepointe Park | 16377 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 3.527 | Bridgepointe Park | 1984 | Local Park 2 | 4 | |
8320 | 8320 | 8319 | {"type": "Polygon", "coordinates": [[[-122.00438, 37.52428], [-122.0038, 37.52499], [-122.00248, 37.52434], [-122.00277, 37.52397], [-122.00264, 37.5239], [-122.00292, 37.52355], [-122.00438, 37.52428]]]} | Open Access 1 | 12799 | Eucalyptus Grove Park (South) | 18737 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 3.373 | Eucalyptus Grove Park (South) | 1984 | None 692 | ||
8323 | 8323 | 8322 | {"type": "Polygon", "coordinates": [[[-122.01182, 37.51583], [-122.01166, 37.51629], [-122.01053, 37.51879], [-122.01011, 37.51977], [-122.00949, 37.51959], [-122.0089, 37.51936], [-122.00863, 37.51996], [-122.00771, 37.51964], [-122.00981, 37.51481], [-122.01051, 37.51513], [-122.01045, 37.51521], [-122.01046, 37.51523], [-122.01182, 37.51583]]]} | Open Access 1 | 12802 | Newark Sportsfield Park | 22713 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 25.97 | Newark Sportsfield Park | 1984 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);