superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where MNG_AG_TYP = 2 and YR_EST = 1969
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2470 | 2470 | 2469 | {"type": "Polygon", "coordinates": [[[-122.01439, 37.28159], [-122.0142, 37.28159], [-122.01085, 37.27902], [-122.01018, 37.2784], [-122.01043, 37.2783], [-122.01437, 37.28012], [-122.01439, 37.28159]]]} | Open Access 1 | Congress Springs Park | 17589 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 9.658 | Congress Springs Park | 1969 | |
2770 | 2770 | 2769 | {"type": "Polygon", "coordinates": [[[-122.40194, 37.59953], [-122.4014, 37.59984], [-122.40143, 37.5999], [-122.40009, 37.60067], [-122.40003, 37.60074], [-122.40003, 37.60079], [-122.40005, 37.60083], [-122.4001, 37.6009], [-122.39917, 37.60143], [-122.39834, 37.60052], [-122.40124, 37.59884], [-122.40194, 37.59953]]]} | Open Access 1 | Central Park | 17054 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 8.687 | Central Park | 1969 | |
3820 | 3820 | 3819 | {"type": "Polygon", "coordinates": [[[-122.28216, 37.48306], [-122.28213, 37.48341], [-122.28125, 37.48399], [-122.28098, 37.48407], [-122.28012, 37.48408], [-122.27956, 37.48417], [-122.27897, 37.48435], [-122.27847, 37.48457], [-122.27684, 37.48566], [-122.27673, 37.48548], [-122.27626, 37.48571], [-122.27552, 37.48575], [-122.27487, 37.48656], [-122.27458, 37.4865], [-122.2745, 37.48663], [-122.27439, 37.48677], [-122.27428, 37.48687], [-122.27401, 37.48704], [-122.27265, 37.4858], [-122.27186, 37.48639], [-122.27102, 37.48642], [-122.27109, 37.48583], [-122.27075, 37.48584], [-122.27014, 37.48553], [-122.26998, 37.48542], [-122.26985, 37.48526], [-122.26982, 37.48512], [-122.26986, 37.48499], [-122.26994, 37.4849], [-122.26999, 37.48503], [-122.27023, 37.48497], [-122.27018, 37.48461], [-122.27027, 37.48455], [-122.2703, 37.4845], [-122.2703, 37.48445], [-122.27027, 37.4844], [-122.27022, 37.48435], [-122.27009, 37.48433], [-122.26975, 37.48379], [-122.26969, 37.48369], [-122.26984, 37.48362], [-122.26984, 37.48351], [-122.26959, 37.48313], [-122.26957, 37.48306], [-122.26952, 37.48301], [-122.26946, 37.48298], [-122.26937, 37.48297], [-122.2693, 37.48298], [-122.26907, 37.48253], [-122.2691, 37.48232], [-122.27137, 37.48247], [-122.27265, 37.48204], [-122.27293, 37.48224], [-122.27387, 37.48258], [-122.27414, 37.48276], [-122.27434, 37.48286], [-122.27428, 37.48296], [-122.27457, 37.4833], [-122.27501, 37.48346], [-122.27515, 37.48338], [-122.27538, 37.48358], [-122.27536, 37.48394], [-122.27546, 37.48419], [-122.2757, 37.48438], [-122.27653, 37.4849], [-122.27736, 37.48388], [-122.27793, 37.48391], [-122.27875, 37.48321], [-122.27959, 37.48341], [-122.28, 37.48339], [-122.28018, 37.48301], [-122.28045, 37.483], [-122.2806, 37.48301], [-122.28093, 37.4831], [-122.28086, 37.48332], [-122.28119, 37.48355], [-122.28182, 37.48346], [-122.28207, 37.48326], [-122.28209, 37.48307], [-122.28216, 37.48306]]]} | Open Access 1 | Eaton Park | 18411 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 65.363 | Eaton Park | 1969 | |
4289 | 4289 | 4288 | {"type": "Polygon", "coordinates": [[[-122.03509, 37.26725], [-122.0346, 37.26728], [-122.03407, 37.26727], [-122.03406, 37.26691], [-122.03503, 37.2669], [-122.03509, 37.26725]]]} | Open Access 1 | Foothill Park | 18980 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 0.903 | Foothill Park | 1969 | |
4846 | 4846 | 4845 | {"type": "Polygon", "coordinates": [[[-122.31173, 37.50242], [-122.31135, 37.50284], [-122.31132, 37.50307], [-122.31105, 37.50289], [-122.31012, 37.50267], [-122.30983, 37.50267], [-122.30946, 37.5027], [-122.30933, 37.5031], [-122.30891, 37.50302], [-122.30846, 37.503], [-122.30846, 37.5027], [-122.30812, 37.50266], [-122.30792, 37.50242], [-122.30789, 37.50228], [-122.30792, 37.50226], [-122.30909, 37.5021], [-122.30944, 37.50237], [-122.31, 37.50242], [-122.31051, 37.5021], [-122.31173, 37.50242]]]} | Open Access 1 | Hallmark Park | 19610 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 5.093 | Hallmark Park | 1969 | |
5161 | 5161 | 5160 | {"type": "Polygon", "coordinates": [[[-122.06357, 37.30829], [-122.06332, 37.30863], [-122.06196, 37.30869], [-122.06081, 37.30885], [-122.06014, 37.30802], [-122.06014, 37.30757], [-122.06021, 37.30723], [-122.06026, 37.30678], [-122.06084, 37.30684], [-122.06187, 37.30748], [-122.06274, 37.30747], [-122.06338, 37.3078], [-122.06357, 37.30829]]]} | Open Access 1 | Linda Vista Park | 21283 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 11.011 | Linda Vista Park | 1969 | |
8283 | 8283 | 8282 | {"type": "Polygon", "coordinates": [[[-122.43747, 37.7074], [-122.43724, 37.70761], [-122.43697, 37.70744], [-122.43721, 37.70722], [-122.43747, 37.7074]]]} | Open Access 1 | Polaris Park | 23870 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.234 | Polaris Park | 1969 | |
11967 | 11967 | 11966 | {"type": "Polygon", "coordinates": [[[-122.47106, 37.65288], [-122.47049, 37.65305], [-122.47037, 37.65276], [-122.47096, 37.65265], [-122.47106, 37.65288]]]} | Open Access 1 | Canterbury Tot Lot | 28796 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.402 | Canterbury Tot Lot | 1969 |
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]);