units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21
This data as json, copyable, CSV (advanced)
DES_TP 37
- Local Park 97
- Local Recreation Area 68
- Local Conservation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 198
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 200
MNG_AGENCY 1
- San Francisco, City and County of · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1139 | 1139 | 1138 | {"type": "Polygon", "coordinates": [[[-122.51189, 37.77681], [-122.51151, 37.77685], [-122.5112, 37.77653], [-122.51112, 37.77641], [-122.51112, 37.77626], [-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 | 6699 | Gr.hwy/balboa Natural Area | 19412 | 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.868 | Gr.hwy/balboa Natural Area | 0 | Local Conservation Area 4 | 2 | |
1141 | 1141 | 1140 | {"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 | 6711 | Geneva Ave Strip | 19256 | 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.231 | Geneva Ave Strip | None 102 | |||
1261 | 1261 | 1260 | {"type": "Polygon", "coordinates": [[[-122.42247, 37.74924], [-122.42242, 37.74925], [-122.42198, 37.74959], [-122.42198, 37.74954], [-122.42196, 37.74954], [-122.42188, 37.7496], [-122.42189, 37.74966], [-122.42158, 37.7499], [-122.4215, 37.7499], [-122.42149, 37.74982], [-122.42246, 37.74908], [-122.42247, 37.74924]]]} | Open Access 1 | 5676 | Juri Commons | 20535 | 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.325 | Juri Commons | None 108 | |||
1286 | 1286 | 1285 | {"type": "Polygon", "coordinates": [[[-122.40599, 37.75123], [-122.4053, 37.75127], [-122.40521, 37.75114], [-122.40432, 37.7512], [-122.40423, 37.75028], [-122.40457, 37.75026], [-122.40459, 37.75027], [-122.40492, 37.75015], [-122.40474, 37.74979], [-122.40524, 37.74962], [-122.40597, 37.751], [-122.40599, 37.75123]]]} | Open Access 1 | 5708 | Potrero Del Sol Park (la Roza) | 23923 | 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 | 4.37 | Potrero Del Sol Park (la Roza) | None 112 | |||
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 | |
1707 | 1707 | 1706 | {"type": "Polygon", "coordinates": [[[-122.42707, 37.78105], [-122.42623, 37.78115], [-122.42616, 37.78084], [-122.42539, 37.78093], [-122.42538, 37.78094], [-122.42545, 37.78125], [-122.42402, 37.78144], [-122.42387, 37.78069], [-122.42692, 37.7803], [-122.42707, 37.78105]]]} | Open Access 1 | 6549 | Margaret S Hayward Playground | 21802 | 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.03 | Margaret S Hayward Playground | 0 | Local Recreation Area 3 | 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 | |
1901 | 1901 | 1900 | {"type": "Polygon", "coordinates": [[[-122.49902, 37.73817], [-122.49804, 37.73822], [-122.49793, 37.73657], [-122.49883, 37.73653], [-122.49891, 37.73763], [-122.49898, 37.73763], [-122.49902, 37.73817]]]} | Open Access 1 | 16303 | South Sunset Playground | 25681 | 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 | 3.725 | South Sunset Playground | 0 | Local Recreation Area 3 | 4 | |
1902 | 1902 | 1901 | {"type": "Polygon", "coordinates": [[[-122.4742, 37.72523], [-122.47387, 37.72523], [-122.4735, 37.72527], [-122.47349, 37.72487], [-122.47322, 37.72486], [-122.47322, 37.7248], [-122.47411, 37.72426], [-122.47414, 37.72425], [-122.47416, 37.72427], [-122.47426, 37.72486], [-122.4742, 37.72523]]]} | Open Access 1 | 16307 | Junipero Serra Playground | 20533 | 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.545 | Junipero Serra Playground | 2000 | Local Recreation Area 3 | 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 | |
1972 | 1972 | 1971 | {"type": "MultiPolygon", "coordinates": [[[[-122.45856, 37.77926], [-122.45682, 37.77948], [-122.45662, 37.77952], [-122.45657, 37.77952], [-122.45653, 37.77948], [-122.45628, 37.77823], [-122.45689, 37.77815], [-122.45692, 37.7782], [-122.45697, 37.77824], [-122.4571, 37.77827], [-122.45847, 37.7781], [-122.45856, 37.77926]]], [[[-122.45804, 37.77801], [-122.45765, 37.77806], [-122.45759, 37.77775], [-122.45798, 37.7777], [-122.45804, 37.77801]]]]} | Open Access 1 | 6076 | Angelo J Rossi Playground | 15497 | 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 | 6.474 | Angelo J Rossi Playground | 0 | Local Recreation Area 3 | 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 | |
2091 | 2091 | 2090 | {"type": "Polygon", "coordinates": [[[-122.45164, 37.78404], [-122.45123, 37.78411], [-122.45025, 37.78434], [-122.45022, 37.78432], [-122.45027, 37.78419], [-122.45041, 37.78403], [-122.45048, 37.78392], [-122.4505, 37.78381], [-122.45049, 37.78367], [-122.45093, 37.78362], [-122.45095, 37.78367], [-122.45156, 37.78366], [-122.45164, 37.78404]]]} | Open Access 1 | 6087 | Laurel Hill Playground | 21096 | 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.471 | Laurel Hill Playground | 0 | Local Recreation Area 3 | 4 | |
2115 | 2115 | 2114 | {"type": "Polygon", "coordinates": [[[-122.4377, 37.76639], [-122.43764, 37.76652], [-122.43754, 37.76654], [-122.4374, 37.7666], [-122.43728, 37.7667], [-122.4372, 37.76683], [-122.43709, 37.76684], [-122.43706, 37.76652], [-122.43734, 37.76641], [-122.43747, 37.76637], [-122.43765, 37.76638], [-122.4377, 37.76639]]]} | Open Access 1 | 15926 | Roosevelt & Henry Stairs | 24593 | 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.349 | Roosevelt & Henry Stairs | None 170 | |||
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 |
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]);