superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, LAYER = 10 and MNG_AGENCY = 521
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
463 | 463 | 462 | {"type": "Polygon", "coordinates": [[[-122.39117, 37.78541], [-122.39071, 37.78573], [-122.39028, 37.78609], [-122.39017, 37.78649], [-122.38985, 37.78623], [-122.39103, 37.78533], [-122.39117, 37.78541]]]} | Open Access 1 | Rincon Hill Dog Park | https://www.rinconhilldogpark.org/about | 33503 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.621 | Rincon Hill Dog Park | 2007 |
789 | 789 | 788 | {"type": "Polygon", "coordinates": [[[-122.39104, 37.75772], [-122.39035, 37.75777], [-122.39033, 37.7576], [-122.39101, 37.75756], [-122.39104, 37.75772]]]} | Open Access 1 | Woods Yard | https://www.sfparksalliance.org/our-parks/parks/woods-yard | 33552 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.275 | Woods Yard | |
802 | 802 | 801 | {"type": "Polygon", "coordinates": [[[-122.39106, 37.77842], [-122.38914, 37.77987], [-122.38862, 37.78032], [-122.38843, 37.78055], [-122.38828, 37.78079], [-122.38819, 37.78101], [-122.38806, 37.78144], [-122.388, 37.78149], [-122.38791, 37.78151], [-122.38783, 37.7815], [-122.38776, 37.78145], [-122.38774, 37.78141], [-122.38768, 37.7806], [-122.38752, 37.77914], [-122.38746, 37.77826], [-122.38762, 37.77821], [-122.38757, 37.77825], [-122.3878, 37.78026], [-122.38849, 37.78024], [-122.38857, 37.78028], [-122.391, 37.77836], [-122.39106, 37.77842]]]} | Open Access 1 | South Beach Park | https://www.sfparksalliance.org/our-parks/parks/south-beach-park | 33553 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 2.85 | South Beach Park | |
819 | 819 | 818 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47841, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47837, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.4773, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47764, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | Robert Pender Park | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | 33555 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 2.547 | Robert Pender Park | |
4028 | 4028 | 4027 | {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.7664], [-122.44881, 37.76647], [-122.44849, 37.76654], [-122.44848, 37.76657], [-122.44806, 37.76662], [-122.44802, 37.76642], [-122.44844, 37.76637], [-122.44847, 37.7664], [-122.44872, 37.76635], [-122.44892, 37.76627], [-122.44902, 37.7662], [-122.44899, 37.76602], [-122.4495, 37.76595], [-122.44958, 37.76633]]]} | Open Access 1 | Richard Gamble Memorial Park | https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park | 33627 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.913 | Richard Gamble Memorial Park |
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]);