superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 175
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 177
MNG_AGENCY 1
- San Francisco, City and County of · 177 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3851 | 3851 | 3850 | {"type": "Polygon", "coordinates": [[[-122.4606, 37.74202], [-122.46018, 37.74226], [-122.4602, 37.74231], [-122.4599, 37.74259], [-122.45924, 37.74241], [-122.45915, 37.74237], [-122.45931, 37.74181], [-122.45932, 37.74173], [-122.4593, 37.74167], [-122.45933, 37.7414], [-122.4596, 37.74141], [-122.45972, 37.74147], [-122.45971, 37.74151], [-122.45981, 37.74163], [-122.45974, 37.74167], [-122.45974, 37.74169], [-122.46007, 37.74186], [-122.46026, 37.74166], [-122.4606, 37.74202]]]} | Open Access 1 | Edgehill Mountain | 18435 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.347 | Edgehill Mtn. | ||
4057 | 4057 | 4056 | {"type": "Polygon", "coordinates": [[[-122.39139, 37.76151], [-122.3907, 37.76155], [-122.3906, 37.76046], [-122.39128, 37.76042], [-122.39131, 37.76095], [-122.39137, 37.76124], [-122.39139, 37.76151]]]} | Open Access 1 | Esprit Park | 18718 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.813 | Esprit Park | ||
4111 | 4111 | 4110 | {"type": "Polygon", "coordinates": [[[-122.43383, 37.72008], [-122.4332, 37.72091], [-122.43261, 37.72063], [-122.43324, 37.7198], [-122.43383, 37.72008]]]} | Open Access 1 | Excelsior Playground | 18772 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.612 | Excelsior Playground | ||
4145 | 4145 | 4144 | {"type": "Polygon", "coordinates": [[[-122.42952, 37.73851], [-122.42949, 37.73855], [-122.4295, 37.73861], [-122.42928, 37.73867], [-122.42929, 37.73892], [-122.4288, 37.73859], [-122.4288, 37.73837], [-122.42926, 37.73806], [-122.42928, 37.73835], [-122.42952, 37.73851]]]} | Open Access 1 | Fairmount Plaza | 18812 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.744 | Fairmount Plaza | ||
4186 | 4186 | 4185 | {"type": "Polygon", "coordinates": [[[-122.41802, 37.80306], [-122.41775, 37.80309], [-122.41767, 37.80272], [-122.41794, 37.80269], [-122.41802, 37.80306]]]} | Open Access 1 | Fay Park | 18857 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.25 | Fay Park | ||
4213 | 4213 | 4212 | {"type": "MultiPolygon", "coordinates": [[[[-122.39677, 37.7962], [-122.39676, 37.79625], [-122.39672, 37.79629], [-122.39642, 37.79637], [-122.39569, 37.79646], [-122.39559, 37.79643], [-122.39549, 37.79636], [-122.39539, 37.79625], [-122.39511, 37.79605], [-122.39507, 37.79597], [-122.39504, 37.79575], [-122.39664, 37.79555], [-122.39677, 37.7962]]], [[[-122.39801, 37.79614], [-122.39756, 37.7962], [-122.39752, 37.79607], [-122.39728, 37.79599], [-122.39703, 37.79601], [-122.39695, 37.79553], [-122.39786, 37.79541], [-122.39801, 37.79614]]]]} | Open Access 1 | Ferry Park | 18887 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 4.177 | Ferry Park | ||
4235 | 4235 | 4234 | {"type": "Polygon", "coordinates": [[[-122.43198, 37.78028], [-122.43163, 37.78033], [-122.43159, 37.78009], [-122.43193, 37.78005], [-122.43198, 37.78028]]]} | Open Access 1 | Fillmore & Turk St. Mini Park | 18898 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.203 | Fillmore & Turk St. MP | ||
3498 | 3498 | 3497 | {"type": "Polygon", "coordinates": [[[-122.41034, 37.7655], [-122.40841, 37.76562], [-122.40829, 37.76452], [-122.41023, 37.76441], [-122.41034, 37.7655]]]} | Open Access 1 | Franklin Square | 19068 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 5.147 | Franklin Square | ||
3531 | 3531 | 3530 | {"type": "Polygon", "coordinates": [[[-122.48736, 37.77357], [-122.48654, 37.77361], [-122.48651, 37.7732], [-122.48733, 37.77316], [-122.48736, 37.77357]]]} | Open Access 1 | Fulton Playground | 19149 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.819 | Fulton Playground | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-122.41273, 37.75089], [-122.41188, 37.75094], [-122.41174, 37.74952], [-122.41259, 37.74946], [-122.41273, 37.75089]]]} | Open Access 1 | Garfield Center | 19212 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.93 | Garfield Ctr. | ||
4322 | 4322 | 4321 | {"type": "Polygon", "coordinates": [[[-122.44587, 37.72056], [-122.4458, 37.72066], [-122.44507, 37.72037], [-122.44513, 37.72028], [-122.44518, 37.72027], [-122.44529, 37.72033], [-122.44587, 37.72056]]]} | Open Access 1 | Geneva Ave Strip | 19256 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.231 | Geneva Ave Strip | ||
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-122.42112, 37.80171], [-122.41972, 37.80189], [-122.41956, 37.80114], [-122.42097, 37.80097], [-122.42112, 37.80171]]]} | Open Access 1 | Geo Sterling Park (alice Marble Tennis Courts) | 19258 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.597 | Geo Sterling Park (alice Marble Tennis Courts) | ||
4567 | 4567 | 4566 | {"type": "MultiPolygon", "coordinates": [[[[-122.38909, 37.71702], [-122.38813, 37.71809], [-122.387, 37.71745], [-122.3879, 37.71646], [-122.38796, 37.71642], [-122.38806, 37.71643], [-122.38909, 37.71702]]], [[[-122.38859, 37.71548], [-122.38852, 37.71556], [-122.38854, 37.71568], [-122.38853, 37.71576], [-122.3884, 37.71602], [-122.38833, 37.71612], [-122.38848, 37.71638], [-122.38857, 37.71643], [-122.38856, 37.71644], [-122.38841, 37.71636], [-122.38834, 37.71628], [-122.38804, 37.71536], [-122.38827, 37.7151], [-122.3884, 37.71518], [-122.38859, 37.71548]]]]} | Open Access 1 | Gilman Playground | 19297 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 5.206 | Gilman Playground | ||
4622 | 4622 | 4621 | {"type": "Polygon", "coordinates": [[[-122.43354, 37.77968], [-122.43341, 37.7797], [-122.43336, 37.77948], [-122.4335, 37.77946], [-122.43354, 37.77968]]]} | Open Access 1 | Golden Gate & Steiner Mini Park | 19359 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.075 | Golden Gate & Steiner MP | ||
4632 | 4632 | 4631 | {"type": "Polygon", "coordinates": [[[-122.46871, 37.75071], [-122.46863, 37.75066], [-122.46858, 37.7506], [-122.4685, 37.75044], [-122.46845, 37.75026], [-122.46847, 37.74986], [-122.46844, 37.74971], [-122.4684, 37.74959], [-122.4684, 37.74951], [-122.46844, 37.74939], [-122.46856, 37.74928], [-122.46867, 37.74925], [-122.46886, 37.74927], [-122.469, 37.7493], [-122.46927, 37.74943], [-122.46944, 37.74949], [-122.4696, 37.74951], [-122.4699, 37.74951], [-122.47004, 37.74953], [-122.47016, 37.74958], [-122.47025, 37.74964], [-122.47035, 37.74973], [-122.4704, 37.74982], [-122.47044, 37.74994], [-122.47045, 37.75002], [-122.47044, 37.75012], [-122.4704, 37.75021], [-122.47022, 37.75044], [-122.47, 37.7506], [-122.46986, 37.75066], [-122.4697, 37.75069], [-122.46886, 37.75074], [-122.46871, 37.75071]]]} | Open Access 1 | Golden Heights Park | 19362 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 5.623 | Golden Heights Park | ||
4668 | 4668 | 4667 | {"type": "Polygon", "coordinates": [[[-122.42113, 37.73994], [-122.42098, 37.74018], [-122.42082, 37.74011], [-122.42098, 37.73987], [-122.42113, 37.73994]]]} | Open Access 1 | Good Prospect Community Garden | 19402 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.114 | Good Prospect Community Garden | ||
4675 | 4675 | 4674 | {"type": "Polygon", "coordinates": [[[-122.51189, 37.77681], [-122.51151, 37.77685], [-122.5112, 37.77653], [-122.51112, 37.77641], [-122.51112, 37.77625], [-122.51093, 37.77611], [-122.51078, 37.77588], [-122.51061, 37.77568], [-122.51028, 37.77523], [-122.51108, 37.7752], [-122.51109, 37.77541], [-122.51113, 37.77564], [-122.5112, 37.77588], [-122.51128, 37.77607], [-122.51149, 37.7764], [-122.51189, 37.77681]]]} | Open Access 1 | Gr.hwy/balboa Natural Area | 19412 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.868 | Gr.hwy/balboa Natural Area | ||
4689 | 4689 | 4688 | {"type": "Polygon", "coordinates": [[[-122.4722, 37.75635], [-122.47194, 37.75665], [-122.4718, 37.75686], [-122.47157, 37.75675], [-122.47149, 37.75665], [-122.47146, 37.75655], [-122.47149, 37.75606], [-122.47155, 37.75595], [-122.47157, 37.75583], [-122.47177, 37.75593], [-122.47194, 37.75605], [-122.47205, 37.75617], [-122.4722, 37.75635]]]} | Open Access 1 | Grand View Park | 19426 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.115 | Grand View Park | ||
100 | 100 | 99 | {"type": "Polygon", "coordinates": [[[-122.47273, 37.75508], [-122.47256, 37.75525], [-122.47257, 37.75529], [-122.47226, 37.75545], [-122.47219, 37.75536], [-122.47216, 37.75526], [-122.47213, 37.75504], [-122.47212, 37.75467], [-122.47216, 37.75465], [-122.4722, 37.75466], [-122.47236, 37.75482], [-122.47273, 37.75508]]]} | Open Access 1 | Grand View Pk. Open Space | 19427 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.642 | Grand View Pk. OS | ||
3738 | 3738 | 3737 | {"type": "Polygon", "coordinates": [[[-122.4521, 37.76279], [-122.45096, 37.76293], [-122.45085, 37.7624], [-122.45199, 37.76225], [-122.4521, 37.76279]]]} | Open Access 1 | Grattan Playground | 19450 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.519 | Grattan Playground |
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]);