superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, MNG_AGENCY = 96 and YR_EST = 1973
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 6 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4885 | 4885 | 4884 | {"type": "Polygon", "coordinates": [[[-122.28747, 37.54971], [-122.28743, 37.54972], [-122.28691, 37.55004], [-122.28681, 37.55003], [-122.28635, 37.54958], [-122.28609, 37.54929], [-122.2869, 37.54882], [-122.28746, 37.54942], [-122.28731, 37.54954], [-122.28747, 37.54971]]]} | Open Access 1 | Lakeshore Park | 20974 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.259 | Lakeshore Park | 1973 | |
6057 | 6057 | 6056 | {"type": "Polygon", "coordinates": [[[-122.28234, 37.53373], [-122.28117, 37.53374], [-122.28116, 37.53302], [-122.28094, 37.53243], [-122.28103, 37.53235], [-122.28112, 37.53224], [-122.28119, 37.53212], [-122.28123, 37.53199], [-122.28125, 37.53196], [-122.28233, 37.53195], [-122.28234, 37.53373]]]} | Open Access 1 | Laurie Meadows | 21110 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 5.285 | Laurie Meadows | 1973 | |
6421 | 6421 | 6420 | {"type": "Polygon", "coordinates": [[[-122.28324, 37.54136], [-122.283, 37.5415], [-122.28293, 37.54158], [-122.28289, 37.54165], [-122.28286, 37.54177], [-122.28286, 37.54186], [-122.28295, 37.54204], [-122.28215, 37.54258], [-122.28309, 37.54348], [-122.2823, 37.54398], [-122.28105, 37.54282], [-122.28103, 37.54282], [-122.28112, 37.54076], [-122.28213, 37.54016], [-122.28324, 37.54136]]]} | Open Access 1 | Los Prados | 21529 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 12.587 | Los Prados | 1973 | |
6674 | 6674 | 6673 | {"type": "Polygon", "coordinates": [[[-122.28903, 37.56304], [-122.28898, 37.56325], [-122.28894, 37.56329], [-122.28866, 37.56332], [-122.28819, 37.56339], [-122.28798, 37.56344], [-122.28786, 37.56339], [-122.28779, 37.56338], [-122.2877, 37.56342], [-122.28766, 37.5635], [-122.28755, 37.56353], [-122.28738, 37.56313], [-122.28731, 37.56303], [-122.28716, 37.56296], [-122.28689, 37.56292], [-122.28681, 37.56287], [-122.28669, 37.56277], [-122.28709, 37.56244], [-122.28709, 37.56242], [-122.28742, 37.56208], [-122.28903, 37.56304]]]} | Open Access 1 | Mariner's Island | 21851 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 4.056 | Mariner's Island | 1973 | |
10332 | 10332 | 10331 | {"type": "Polygon", "coordinates": [[[-122.29224, 37.57021], [-122.2896, 37.5702], [-122.2896, 37.57001], [-122.28967, 37.57007], [-122.28978, 37.5701], [-122.29028, 37.57011], [-122.29047, 37.57006], [-122.29066, 37.56996], [-122.29087, 37.56977], [-122.2909, 37.56972], [-122.29091, 37.56967], [-122.29086, 37.56956], [-122.29087, 37.56951], [-122.29119, 37.56926], [-122.29214, 37.57006], [-122.2922, 37.57013], [-122.29224, 37.57021]]]} | Open Access 1 | Tidelands Park | 26347 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.39 | Tidelands Park | 1973 | |
10344 | 10344 | 10343 | {"type": "Polygon", "coordinates": [[[-122.2895, 37.56963], [-122.28945, 37.56994], [-122.28945, 37.57029], [-122.28938, 37.57034], [-122.28742, 37.57046], [-122.28656, 37.57049], [-122.28485, 37.57046], [-122.28479, 37.57043], [-122.28474, 37.57034], [-122.28476, 37.57016], [-122.28478, 37.56967], [-122.28473, 37.56942], [-122.2847, 37.56908], [-122.2847, 37.56832], [-122.28655, 37.56883], [-122.28697, 37.56869], [-122.28702, 37.56878], [-122.28702, 37.56893], [-122.28707, 37.56909], [-122.28749, 37.56947], [-122.28783, 37.56965], [-122.28815, 37.56978], [-122.28852, 37.56987], [-122.28896, 37.5699], [-122.28912, 37.56978], [-122.28937, 37.56963], [-122.2895, 37.56963]]]} | Open Access 1 | Tidelands | 26345 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 14.753 | Tidelands | 1973 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);