units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by DES_TP
This data as json, copyable, CSV (advanced)
DES_TP >30
LAYER 3 ✖
- City 218
- County 1
- Special District 1
ACCESS_TYP 2
- Open Access 218
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 220
MNG_AGENCY 1
- San Francisco, City and County of · 220 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1116 | 1116 | 1115 | {"type": "Polygon", "coordinates": [[[-122.44267, 37.78575], [-122.44248, 37.78578], [-122.4424, 37.7854], [-122.4426, 37.78538], [-122.44267, 37.78575]]]} | Open Access 1 | 6560 | Bush & Broderick Mini Park | 33394 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | https://sfrecpark.org/destination/bush-broderick-mini-park/ | San Francisco 13 | 0.182 | Bush & Broderick MP | 0 | Local Park 2 | 4 |
1525 | 1525 | 1524 | {"type": "Polygon", "coordinates": [[[-122.46518, 37.78019], [-122.46486, 37.7802], [-122.46483, 37.77994], [-122.46516, 37.77993], [-122.46518, 37.78019]]]} | Open Access 1 | 15947 | Muriel Leff Mini Park | 22604 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.206 | Muriel Leff MP | 0 | Local Park 2 | 4 | |
1706 | 1706 | 1705 | {"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 | 6538 | Fillmore & Turk St. Mini Park | 18898 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.203 | Fillmore & Turk St. MP | 0 | Local Park 2 | 4 | |
1722 | 1722 | 1721 | {"type": "Polygon", "coordinates": [[[-122.43935, 37.79177], [-122.4363, 37.79215], [-122.43599, 37.79058], [-122.43904, 37.79019], [-122.43935, 37.79177]]]} | Open Access 1 | 14881 | Alta Plaza | 15419 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 11.905 | Alta Plaza | 0 | Local Park 2 | 4 | |
1919 | 1919 | 1918 | {"type": "MultiPolygon", "coordinates": [[[[-122.38471, 37.73094], [-122.38443, 37.73124], [-122.38438, 37.73135], [-122.38424, 37.73144], [-122.38424, 37.73146], [-122.38417, 37.73151], [-122.38412, 37.73152], [-122.38406, 37.73146], [-122.38408, 37.73144], [-122.38396, 37.73131], [-122.38365, 37.7315], [-122.38384, 37.7317], [-122.38371, 37.73178], [-122.38341, 37.73147], [-122.38319, 37.73141], [-122.38328, 37.73126], [-122.38329, 37.73111], [-122.38319, 37.73087], [-122.38332, 37.73074], [-122.38337, 37.73076], [-122.38341, 37.73076], [-122.38352, 37.73068], [-122.38354, 37.73064], [-122.38353, 37.7306], [-122.38345, 37.73054], [-122.38342, 37.73053], [-122.38361, 37.73031], [-122.38471, 37.73094]]], [[[-122.38538, 37.73098], [-122.38518, 37.7312], [-122.38511, 37.73116], [-122.38531, 37.73094], [-122.38538, 37.73098]]]]} | Open Access 1 | 5932 | Adam Rogers Park | 15256 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.806 | Adam Rogers Park | 0 | Local Park 2 | 4 | |
2056 | 2056 | 2055 | {"type": "Polygon", "coordinates": [[[-122.41317, 37.74214], [-122.41315, 37.74224], [-122.41294, 37.74222], [-122.41295, 37.74212], [-122.41317, 37.74214]]]} | Open Access 1 | 15690 | Bernal Heights Community Garden | 16025 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.056 | Bernal Heights Community Garden | 0 | Local Park 2 | 4 | |
2059 | 2059 | 2058 | {"type": "Polygon", "coordinates": [[[-122.412, 37.74019], [-122.41199, 37.74026], [-122.41175, 37.74024], [-122.41175, 37.74018], [-122.412, 37.74019]]]} | Open Access 1 | 15688 | Prentiss Mini Park | 23985 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.04 | Prentiss MP | 0 | Local Park 2 | 4 | |
2119 | 2119 | 2118 | {"type": "Polygon", "coordinates": [[[-122.43912, 37.75734], [-122.43895, 37.75734], [-122.43893, 37.75709], [-122.43911, 37.75715], [-122.43912, 37.75734]]]} | Open Access 1 | 15928 | Corwin Community Garden | 17668 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.092 | Corwin Community Garden | 0 | Local Park 2 | 4 | |
2121 | 2121 | 2120 | {"type": "Polygon", "coordinates": [[[-122.44339, 37.74797], [-122.44285, 37.74806], [-122.44281, 37.74805], [-122.44331, 37.74755], [-122.44337, 37.74755], [-122.44339, 37.74797]]]} | Open Access 1 | 15924 | Clipper Terrace Community Garden | 17430 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.341 | Clipper Terrace Community Garden | 0 | Local Park 2 | 4 | |
2122 | 2122 | 2121 | {"type": "Polygon", "coordinates": [[[-122.40673, 37.74516], [-122.40672, 37.74526], [-122.4065, 37.74539], [-122.40645, 37.74534], [-122.40673, 37.74516]]]} | Open Access 1 | 15925 | Wolfe Lane Community Garden | 27672 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.055 | Wolfe Lane Community Garden | 0 | Local Park 2 | 4 | |
2123 | 2123 | 2122 | {"type": "Polygon", "coordinates": [[[-122.39784, 37.75746], [-122.39715, 37.7575], [-122.39713, 37.75732], [-122.39782, 37.75728], [-122.39784, 37.75746]]]} | Open Access 1 | 15932 | Connecticut Friendship Garden | 17590 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.302 | Connecticut Friendship Garden | 0 | Local Park 2 | 4 | |
2124 | 2124 | 2123 | {"type": "Polygon", "coordinates": [[[-122.39829, 37.75743], [-122.39812, 37.75744], [-122.3981, 37.75726], [-122.39827, 37.75725], [-122.39829, 37.75743]]]} | Open Access 1 | 15934 | Arkansas Friendship Garden | 15586 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.075 | Arkansas Friendship Garden | 0 | Local Park 2 | 4 | |
2128 | 2128 | 2127 | {"type": "Polygon", "coordinates": [[[-122.42537, 37.77361], [-122.42519, 37.77364], [-122.42512, 37.77331], [-122.42531, 37.77329], [-122.42537, 37.77361]]]} | Open Access 1 | 15941 | Page & Laguna Mini Park | 23315 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.151 | Page & Laguna MP | 0 | Local Park 2 | 4 | |
2130 | 2130 | 2129 | {"type": "Polygon", "coordinates": [[[-122.41041, 37.79043], [-122.40994, 37.79049], [-122.40993, 37.79044], [-122.4104, 37.79038], [-122.41041, 37.79043]]]} | Open Access 1 | 15957 | Hooker Alley Community Garden | 20075 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.056 | Hooker Alley Community Garden | 0 | Local Park 2 | 4 | |
2175 | 2175 | 2174 | {"type": "Polygon", "coordinates": [[[-122.42293, 37.76245], [-122.42257, 37.76248], [-122.42255, 37.7623], [-122.42292, 37.76228], [-122.42293, 37.76245]]]} | Open Access 1 | 16300 | Dearborn Community Garden | 17980 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.154 | Dearborn Community Garden | 0 | Local Park 2 | 4 | |
2207 | 2207 | 2206 | {"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 | 16523 | Franklin Square | 19068 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 5.148 | Franklin Square | 0 | Local Park 2 | 4 | |
2259 | 2259 | 2258 | {"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 | 16745 | Grand View Park | 19426 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.115 | Grand View Park | 0 | Local Park 2 | 4 | |
2267 | 2267 | 2266 | {"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.7497], [-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.47001, 37.7506], [-122.46986, 37.75066], [-122.4697, 37.75069], [-122.46886, 37.75074], [-122.46871, 37.75071]]]} | Open Access 1 | 16728 | Golden Heights Park | 19362 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 5.623 | Golden Heights Park | 0 | Local Park 2 | 4 | |
2307 | 2307 | 2306 | {"type": "Polygon", "coordinates": [[[-122.45896, 37.71653], [-122.4562, 37.71655], [-122.45618, 37.71501], [-122.45894, 37.71499], [-122.45896, 37.71653]]]} | Open Access 1 | 18309 | Ocean View Park | 23060 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 10.297 | Ocean View Park | 0 | Local Park 2 | 4 | |
2342 | 2342 | 2341 | {"type": "Polygon", "coordinates": [[[-122.42726, 37.78198], [-122.42421, 37.78237], [-122.42406, 37.78162], [-122.42711, 37.78123], [-122.42726, 37.78198]]]} | Open Access 1 | 17070 | Jefferson Square | 20384 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 5.644 | Jefferson Square | 0 | 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]);