units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by YR_EST
This data as json, copyable, CSV (advanced)
DES_TP 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6299 | 6299 | 6298 | {"type": "MultiPolygon", "coordinates": [[[[-122.40683, 37.80313], [-122.40672, 37.80315], [-122.40675, 37.80308], [-122.40676, 37.803], [-122.40673, 37.80285], [-122.40655, 37.80261], [-122.40649, 37.80255], [-122.40635, 37.80231], [-122.40625, 37.8021], [-122.40613, 37.80194], [-122.40604, 37.80186], [-122.40588, 37.80179], [-122.40577, 37.80178], [-122.4056, 37.80178], [-122.40548, 37.80184], [-122.40539, 37.80192], [-122.40533, 37.802], [-122.40532, 37.80214], [-122.40537, 37.80228], [-122.40574, 37.80278], [-122.40576, 37.80288], [-122.40579, 37.80295], [-122.40591, 37.80301], [-122.40604, 37.80301], [-122.40613, 37.80296], [-122.40617, 37.80289], [-122.40617, 37.80283], [-122.40613, 37.80275], [-122.406, 37.80268], [-122.40586, 37.80269], [-122.40571, 37.80264], [-122.40543, 37.80226], [-122.40538, 37.80212], [-122.4054, 37.802], [-122.40546, 37.80192], [-122.40549, 37.80189], [-122.40556, 37.80186], [-122.40565, 37.80184], [-122.40576, 37.80183], [-122.40589, 37.80186], [-122.40597, 37.8019], [-122.4061, 37.80202], [-122.40616, 37.8021], [-122.4064, 37.80258], [-122.40663, 37.80287], [-122.40666, 37.80296], [-122.40665, 37.80306], [-122.40657, 37.80319], [-122.40636, 37.80329], [-122.40622, 37.80339], [-122.40618, 37.80349], [-122.40619, 37.80358], [-122.40508, 37.80373], [-122.40496, 37.80315], [-122.40526, 37.80311], [-122.40528, 37.80318], [-122.40545, 37.80315], [-122.40521, 37.80198], [-122.40524, 37.80192], [-122.40533, 37.80183], [-122.40544, 37.80177], [-122.40609, 37.80171], [-122.40619, 37.80181], [-122.40633, 37.80186], [-122.40641, 37.80225], [-122.40647, 37.80243], [-122.40655, 37.8026], [-122.40671, 37.80258], [-122.40667, 37.80261], [-122.40667, 37.80267], [-122.40672, 37.80272], [-122.40679, 37.80275], [-122.40676, 37.80277], [-122.40683, 37.80313]]], [[[-122.40649, 37.80355], [-122.40635, 37.80356], [-122.40633, 37.80352], [-122.40636, 37.80344], [-122.40645, 37.80336], [-122.40649, 37.80355]]]]} | Open Access 1 | 1426 | Telegraph Hill (Pioneer Park) | 26224 | 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.912 | Telegraph Hill (Pioneer Park) | None 511 | |||
6845 | 6845 | 6844 | {"type": "Polygon", "coordinates": [[[-122.4606, 37.74202], [-122.46017, 37.74227], [-122.4602, 37.74231], [-122.4599, 37.74259], [-122.45924, 37.74241], [-122.45915, 37.74237], [-122.45931, 37.74182], [-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.46008, 37.74186], [-122.46026, 37.74166], [-122.4606, 37.74202]]]} | Open Access 1 | 5470 | Edgehill Mountain | 18435 | 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.345 | Edgehill Mtn. | None 556 | |||
6867 | 6867 | 6866 | {"type": "Polygon", "coordinates": [[[-122.43465, 37.74209], [-122.43433, 37.7421], [-122.4343, 37.74179], [-122.43417, 37.74157], [-122.43411, 37.74157], [-122.43407, 37.74153], [-122.434, 37.7415], [-122.43392, 37.74151], [-122.43382, 37.74159], [-122.43355, 37.74167], [-122.43253, 37.74172], [-122.43239, 37.74168], [-122.43209, 37.74148], [-122.43227, 37.74138], [-122.43249, 37.74131], [-122.43221, 37.74099], [-122.43261, 37.74078], [-122.43282, 37.74088], [-122.43396, 37.74123], [-122.43413, 37.74133], [-122.43427, 37.74146], [-122.43465, 37.74209]]]} | Open Access 1 | 5522 | Billy Goat Hill | 16115 | 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.19 | Billy Goat Hill | None 557 | |||
6879 | 6879 | 6878 | {"type": "MultiPolygon", "coordinates": [[[[-122.4465, 37.74071], [-122.44637, 37.74094], [-122.44626, 37.74096], [-122.44608, 37.74085], [-122.4459, 37.74079], [-122.44511, 37.74067], [-122.44488, 37.74061], [-122.4448, 37.74057], [-122.44463, 37.7403], [-122.44425, 37.74033], [-122.44413, 37.74021], [-122.44454, 37.74017], [-122.44455, 37.74016], [-122.44443, 37.73996], [-122.44399, 37.73962], [-122.44527, 37.7399], [-122.44601, 37.74041], [-122.44595, 37.74052], [-122.4465, 37.74071]]], [[[-122.44398, 37.73962], [-122.44401, 37.7401], [-122.44374, 37.73995], [-122.44369, 37.73955], [-122.44271, 37.7396], [-122.44259, 37.73944], [-122.44368, 37.73938], [-122.44397, 37.7396], [-122.44398, 37.73962]]]]} | Open Access 1 | 5546 | O'Shaugnessy Hollow | 22953 | 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.769 | O'Shaugnessy Hollow | None 559 | |||
6880 | 6880 | 6879 | {"type": "MultiPolygon", "coordinates": [[[[-122.44736, 37.75022], [-122.44723, 37.75056], [-122.44717, 37.75089], [-122.44689, 37.7512], [-122.44672, 37.75149], [-122.44662, 37.75147], [-122.44705, 37.75049], [-122.44687, 37.75043], [-122.44689, 37.75038], [-122.44675, 37.75021], [-122.44662, 37.75022], [-122.44534, 37.7493], [-122.44542, 37.74921], [-122.44552, 37.74932], [-122.44563, 37.74942], [-122.44674, 37.75004], [-122.44699, 37.75014], [-122.44736, 37.75022]]], [[[-122.44813, 37.74837], [-122.44807, 37.74864], [-122.44798, 37.74863], [-122.44804, 37.74853], [-122.44813, 37.74837]]], [[[-122.44996, 37.75106], [-122.44994, 37.75108], [-122.44977, 37.75112], [-122.44966, 37.75095], [-122.44996, 37.75095], [-122.44996, 37.75106]]], [[[-122.4502, 37.74979], [-122.45002, 37.75052], [-122.44997, 37.75081], [-122.44974, 37.75081], [-122.45001, 37.7503], [-122.44998, 37.74979], [-122.4502, 37.74979]]], [[[-122.45601, 37.75981], [-122.45564, 37.76031], [-122.45562, 37.7603], [-122.45519, 37.76058], [-122.45509, 37.76058], [-122.45508, 37.76067], [-122.4538, 37.76173], [-122.45355, 37.76154], [-122.45349, 37.76158], [-122.45248, 37.7614], [-122.45245, 37.76128], [-122.45205, 37.76133], [-122.45203, 37.76127], [-122.45244, 37.76121], [-122.45227, 37.76034], [-122.45201, 37.76037], [-122.45201, 37.7588], [-122.45288, 37.75881], [-122.45288, 37.75995], [-122.45309, 37.7601], [-122.45415, 37.76012], [-122.45483, 37.75976], [-122.4559, 37.75978], [-122.45601, 37.75981]]], [[[-122.45331, 37.75675], [-122.45338, 37.75678], [-122.45348, 37.7569], [-122.45353, 37.757], [-122.45357, 37.75711], [-122.45358, 37.75721], [-122.45356, 37.75733], [-122.45353, 37.75742], [-122.45347, 37.75752], [-122.45326, 37.75768], [-122.45278, 37.75797], [-122.45229, 37.75819], [-122.45206, 37.75825], [-122.45203, 37.75696], [-122.45206, 37.75696], [-122.45213, 37.75704], [-122.45223, 37.7571], [-122.45234, 37.75712], [-122.45244, 37.75712], [-122.45256, 37.75708], [-122.45317, 37.75676], [-122.45324, 37.75674], [-122.45331, 37.75675]]], [[[-122.45251, 37.75697], [-122.45245, 37.75699], [-122.45239, 37.757], [-122.45227, 37.75696], [-122.45251, 37.75697]]], [[[-122.45531, 37.75382], [-122.45511, 37.75413], [-122.45502, 37.75433], [-122.45497, 37.75454], [-122.45492, 37.75493], [-122.45486, 37.75509], [-122.45462, 37.75553], [-122.45417, 37.75615], [-122.45407, 37.75633], [-122.45399, 37.75658], [-122.45394, 37.75697], [-122.45389, 37.7571], [-122.45381, 37.75722], [-122.45377, 37.75705], [-122.45367, 37.75685], [-122.45356, 37.75673], [-122.45342, 37.75666], [-122.45326, 37.75663], [-122.45314, 37.75664], [-122.45272, 37.75685], [-122.45271, 37.75669], [-122.45302, 37.75653], [-122.45319, 37.7565], [-122.45336, 37.7565], [-122.45354, 37.75655], [-122.45369, 37.75663], [-122.45382, 37.75677], [-122.45383, 37.75677], [-122.45388, 37.75651], [-122.454, 37.75622], [-122.45445, 37.75552], [-122.45471, 37.75502], [-122.45478, 37.75478], [-122.45482, 37.75436], [-122.45491, 37.75413], [-122.45514, 37.75376], [-122.45529, 37.75379], [-122.45531, 37.75382]]], [[[-122.45565, 37.75336], [-122.45545, 37.75366], [-122.45542, 37.75366], [-122.45525, 37.75363], [-122.45547, 37.75332], [-122.45565, 37.75336]]], [[[-122.45981, 37.75986], [-122.45974, 37.76001], [-122.45953, 37.76007], [-122.45919, 37.76008], [-122.45907, 37.76011], [-122.45901, 37.7602], [-122.45901, 37.76032], [-122.45909, 37.76051], [-122.4591, 37.76063], [-122.45905, 37.76086], [-122.45899, 37.76093], [-122.45888, 37.76096], [-122.45877, 37.76095], [-122.45869, 37.7609], [-122.45865, 37.76081], [-122.45865, 37.76076], [-122.45869, 37.7607], [-122.45879, 37.76064], [-122.45892, 37.76063], [-122.45897, 37.76059], [-122.45897, 37.76055], [-122.45887, 37.76033], [-122.45887, 37.76018], [-122.45898, 37.76002], [-122.45916, 37.75997], [-122.4595, 37.75996], [-122.45963, 37.75992], [-122.45967, 37.75985], [-122.45962, 37.7597], [-122.45934, 37.75907], [-122.4595, 37.75911], [-122.45975, 37.75966], [-122.45981, 37.75986]]]]} | Open Access 1 | 5595 | Interior Green Belt | 20223 | 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 | 21.314 | Interior Green Belt | None 560 | |||
6928 | 6928 | 6927 | {"type": "Polygon", "coordinates": [[[-122.44079, 37.76271], [-122.44033, 37.76274], [-122.44032, 37.76266], [-122.44079, 37.76263], [-122.44079, 37.76271]]]} | Open Access 1 | 5823 | Saturn St.steps | 25168 | 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.097 | Saturn St.steps | None 565 | |||
6936 | 6936 | 6935 | {"type": "Polygon", "coordinates": [[[-122.44577, 37.76325], [-122.44561, 37.76349], [-122.44531, 37.76336], [-122.44547, 37.76312], [-122.44577, 37.76325]]]} | Open Access 1 | 5832 | Mt Olympus (upper Terrace) | 22574 | 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.23 | Mt Olympus (upper Terrace) | None 566 | |||
6950 | 6950 | 6949 | {"type": "Polygon", "coordinates": [[[-122.46373, 37.75952], [-122.46335, 37.75953], [-122.4635, 37.75925], [-122.46352, 37.75901], [-122.46337, 37.75867], [-122.46367, 37.75865], [-122.46373, 37.75952]]]} | Open Access 1 | 5849 | Slug's Garden For The Environment | 25560 | 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.507 | Slug's Garden For The Environment | None 567 | |||
6953 | 6953 | 6952 | {"type": "Polygon", "coordinates": [[[-122.47276, 37.75963], [-122.47241, 37.75965], [-122.47242, 37.75992], [-122.47229, 37.75993], [-122.47227, 37.75965], [-122.47186, 37.75967], [-122.47184, 37.75949], [-122.47225, 37.75947], [-122.47223, 37.75917], [-122.47237, 37.75919], [-122.4724, 37.75955], [-122.47275, 37.75954], [-122.47276, 37.75963]]]} | Open Access 1 | 5859 | 15th Avenue Steps | 15174 | 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.516 | 15th Avenue Steps | None 568 | |||
6966 | 6966 | 6965 | {"type": "Polygon", "coordinates": [[[-122.44097, 37.73199], [-122.44063, 37.73199], [-122.44063, 37.73231], [-122.44054, 37.7323], [-122.44054, 37.73199], [-122.44057, 37.73198], [-122.44058, 37.73194], [-122.44071, 37.73193], [-122.44071, 37.73172], [-122.44097, 37.73171], [-122.44097, 37.73199]]]} | Open Access 1 | 5883 | Sunnyside Conservatory | 26009 | 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.258 | Sunnyside Conservatory | None 569 | |||
7055 | 7055 | 7054 | {"type": "Polygon", "coordinates": [[[-122.46301, 37.71828], [-122.46234, 37.71828], [-122.46234, 37.71816], [-122.46228, 37.71816], [-122.46228, 37.71788], [-122.46276, 37.71787], [-122.46275, 37.718], [-122.46283, 37.718], [-122.46284, 37.7182], [-122.46301, 37.71821], [-122.46301, 37.71828]]]} | Open Access 1 | 6041 | Lakeview Ashton Mini Par | 20981 | 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.524 | Lakeview Ashton Mini Par | None 576 | |||
7134 | 7134 | 7133 | {"type": "MultiPolygon", "coordinates": [[[[-122.47177, 37.77489], [-122.47149, 37.77491], [-122.47137, 37.77327], [-122.47165, 37.77326], [-122.47177, 37.77489]]], [[[-122.4719, 37.77676], [-122.47162, 37.77678], [-122.4715, 37.77513], [-122.47178, 37.77512], [-122.47178, 37.77513], [-122.4719, 37.77676]]], [[[-122.47204, 37.77862], [-122.47175, 37.77864], [-122.47163, 37.777], [-122.47192, 37.77698], [-122.47204, 37.77862]]], [[[-122.47217, 37.78049], [-122.47189, 37.7805], [-122.47177, 37.77886], [-122.47205, 37.77884], [-122.47217, 37.78049]]], [[[-122.47231, 37.78247], [-122.47203, 37.78249], [-122.47191, 37.78085], [-122.47219, 37.78083], [-122.47231, 37.78247]]], [[[-122.47231, 37.77487], [-122.47204, 37.77489], [-122.47203, 37.77488], [-122.47192, 37.77324], [-122.47219, 37.77323], [-122.47231, 37.77487]]], [[[-122.47244, 37.78435], [-122.47216, 37.78436], [-122.47204, 37.78271], [-122.47232, 37.78269], [-122.47233, 37.7827], [-122.47244, 37.78435]]], [[[-122.47245, 37.77674], [-122.47217, 37.77674], [-122.47205, 37.77511], [-122.47233, 37.77509], [-122.47245, 37.77674]]], [[[-122.47258, 37.7786], [-122.4723, 37.77861], [-122.47218, 37.77697], [-122.47246, 37.77696], [-122.47258, 37.7786]]], [[[-122.47251, 37.78621], [-122.4723, 37.78622], [-122.47218, 37.78458], [-122.47246, 37.78457], [-122.47254, 37.78571], [-122.47251, 37.78621]]], [[[-122.47272, 37.78047], [-122.47243, 37.78048], [-122.47231, 37.77883], [-122.4726, 37.77882], [-122.47272, 37.78047]]], [[[-122.47286, 37.78245], [-122.47258, 37.78246], [-122.47258, 37.78245], [-122.47246, 37.78082], [-122.47274, 37.78081], [-122.47286, 37.78245]]], [[[-122.47299, 37.78432], [-122.47271, 37.78433], [-122.4726, 37.78268], [-122.47287, 37.78267], [-122.47299, 37.78432]]], [[[-122.47313, 37.78618], [-122.47278, 37.7862], [-122.47281, 37.7857], [-122.47273, 37.78455], [-122.47301, 37.78454], [-122.47313, 37.78618]]]]} | Open Access 1 | 6219 | Park Presidio Boulevard | 23436 | 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 | 15.695 | Park Presidio Boulevard | None 583 | |||
7338 | 7338 | 7337 | {"type": "Polygon", "coordinates": [[[-122.4484, 37.80459], [-122.44837, 37.8045], [-122.44835, 37.80452], [-122.44837, 37.80454], [-122.44819, 37.80471], [-122.44813, 37.80424], [-122.44811, 37.80422], [-122.4478, 37.80422], [-122.44777, 37.80425], [-122.44764, 37.80421], [-122.4474, 37.80422], [-122.44721, 37.80427], [-122.44674, 37.80182], [-122.44771, 37.80171], [-122.44776, 37.80174], [-122.44793, 37.80171], [-122.44789, 37.80136], [-122.44827, 37.8014], [-122.44858, 37.80149], [-122.44889, 37.80161], [-122.4492, 37.80181], [-122.44944, 37.80202], [-122.44964, 37.80227], [-122.44977, 37.80253], [-122.44984, 37.80279], [-122.44986, 37.80308], [-122.44982, 37.80334], [-122.4497, 37.80364], [-122.44953, 37.8039], [-122.44931, 37.80413], [-122.44903, 37.80433], [-122.44874, 37.80448], [-122.4484, 37.80459]]]} | Open Access 1 | 6651 | Palace of Fine Arts | 23326 | 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 | 17.315 | Palace of Fine Arts | None 607 | |||
9504 | 9504 | 9503 | {"type": "Polygon", "coordinates": [[[-122.46369, 37.75845], [-122.46366, 37.75848], [-122.46324, 37.75849], [-122.46319, 37.75848], [-122.46317, 37.75845], [-122.46283, 37.75709], [-122.46288, 37.75693], [-122.46307, 37.75677], [-122.46352, 37.75675], [-122.46357, 37.75678], [-122.46369, 37.75845]]]} | Open Access 1 | 15911 | White Crane Spring | 27459 | 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.671 | White Crane Spring | None 787 | |||
9672 | 9672 | 9671 | {"type": "Polygon", "coordinates": [[[-122.39575, 37.71662], [-122.39566, 37.71671], [-122.39559, 37.71682], [-122.39554, 37.71692], [-122.3955, 37.7171], [-122.39546, 37.71717], [-122.39537, 37.71729], [-122.39521, 37.71739], [-122.39461, 37.71762], [-122.39453, 37.71768], [-122.39445, 37.71776], [-122.3944, 37.7179], [-122.39441, 37.71804], [-122.39449, 37.71817], [-122.39462, 37.71826], [-122.39442, 37.71849], [-122.39393, 37.71821], [-122.39396, 37.71817], [-122.39396, 37.71816], [-122.39334, 37.7178], [-122.39361, 37.71771], [-122.39361, 37.71769], [-122.39329, 37.71739], [-122.39333, 37.71736], [-122.39333, 37.71734], [-122.39278, 37.71682], [-122.39201, 37.71657], [-122.39125, 37.71612], [-122.39002, 37.7146], [-122.38946, 37.71408], [-122.38921, 37.71419], [-122.38904, 37.71395], [-122.3889, 37.7137], [-122.3888, 37.71349], [-122.38871, 37.71322], [-122.38904, 37.71326], [-122.38918, 37.7133], [-122.38933, 37.71337], [-122.38945, 37.71345], [-122.38955, 37.71355], [-122.38965, 37.71367], [-122.38973, 37.71384], [-122.38985, 37.71396], [-122.39002, 37.71405], [-122.39033, 37.71413], [-122.39049, 37.71423], [-122.39059, 37.71434], [-122.39082, 37.71473], [-122.3911, 37.71508], [-122.39132, 37.71543], [-122.39144, 37.71557], [-122.39157, 37.71566], [-122.39208, 37.71586], [-122.39215, 37.71579], [-122.39231, 37.71568], [-122.39242, 37.71557], [-122.3925, 37.71554], [-122.39303, 37.71564], [-122.39361, 37.71583], [-122.39418, 37.71592], [-122.39424, 37.71597], [-122.39419, 37.716], [-122.39419, 37.71608], [-122.39411, 37.71631], [-122.39411, 37.71648], [-122.39415, 37.71661], [-122.39423, 37.71671], [-122.39452, 37.71701], [-122.39463, 37.71708], [-122.39482, 37.71715], [-122.39494, 37.71717], [-122.39509, 37.71717], [-122.39522, 37.71714], [-122.39533, 37.71709], [-122.39543, 37.71702], [-122.39549, 37.71695], [-122.39559, 37.71679], [-122.39567, 37.71663], [-122.39571, 37.71661], [-122.39575, 37.71662]]]} | Open Access 1 | 16318 | Bay View Hill Park/open Space | 15883 | 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 | 15.902 | Bay View Hill Park/open Space | None 827 | |||
10205 | 10205 | 10204 | {"type": "Polygon", "coordinates": [[[-122.45617, 37.75151], [-122.45616, 37.75155], [-122.45605, 37.75164], [-122.45597, 37.75174], [-122.45587, 37.75195], [-122.45585, 37.75212], [-122.45587, 37.75259], [-122.45585, 37.75281], [-122.45584, 37.75287], [-122.45577, 37.75288], [-122.45572, 37.75292], [-122.45573, 37.75312], [-122.45576, 37.75315], [-122.45565, 37.75336], [-122.45275, 37.75273], [-122.45311, 37.75199], [-122.45316, 37.7518], [-122.45315, 37.75164], [-122.45323, 37.75165], [-122.45336, 37.75127], [-122.45372, 37.75128], [-122.45521, 37.75144], [-122.45577, 37.75145], [-122.45611, 37.75147], [-122.45615, 37.75149], [-122.45617, 37.75151]]]} | Open Access 1 | 17894 | Midtown Terrace | 22210 | 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.789 | Midtown Terrace | None 888 | |||
13804 | 13804 | 13803 | {"type": "Polygon", "coordinates": [[[-122.45304, 37.74201], [-122.45079, 37.74215], [-122.45075, 37.74211], [-122.45073, 37.74181], [-122.45102, 37.74129], [-122.45105, 37.74127], [-122.45148, 37.74137], [-122.45196, 37.74143], [-122.45225, 37.74143], [-122.45298, 37.74139], [-122.45304, 37.74201]]]} | Open Access 1 | 36375 | San Francisco, City and County of 1 | 24891 | 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.693 | San Francisco, City and County of 1 | None 1188 | |||
39 | 39 | 38 | {"type": "Polygon", "coordinates": [[[-122.41541, 37.74416], [-122.41424, 37.74386], [-122.4139, 37.74373], [-122.41307, 37.74338], [-122.41292, 37.74333], [-122.41277, 37.74333], [-122.41262, 37.74335], [-122.41236, 37.74347], [-122.41201, 37.74361], [-122.41188, 37.74363], [-122.41171, 37.74361], [-122.41023, 37.74309], [-122.41017, 37.74304], [-122.41012, 37.74297], [-122.4101, 37.74289], [-122.4101, 37.74281], [-122.41018, 37.74269], [-122.41031, 37.74257], [-122.41045, 37.74251], [-122.4106, 37.74249], [-122.41164, 37.74243], [-122.41251, 37.7423], [-122.41265, 37.7423], [-122.41416, 37.74251], [-122.41432, 37.74252], [-122.41446, 37.7425], [-122.41461, 37.74246], [-122.41479, 37.74238], [-122.41501, 37.74225], [-122.41512, 37.74222], [-122.4159, 37.74217], [-122.41629, 37.74208], [-122.41647, 37.74206], [-122.41669, 37.74209], [-122.41682, 37.74216], [-122.41689, 37.74222], [-122.41696, 37.74233], [-122.41699, 37.74242], [-122.41698, 37.74251], [-122.41693, 37.74261], [-122.4167, 37.74279], [-122.41662, 37.74291], [-122.41657, 37.74307], [-122.41659, 37.74328], [-122.41655, 37.74337], [-122.41647, 37.74345], [-122.4161, 37.74363], [-122.41597, 37.74372], [-122.41586, 37.74383], [-122.4158, 37.74393], [-122.41575, 37.74406], [-122.41568, 37.74413], [-122.41556, 37.74418], [-122.41541, 37.74416]], [[-122.41555, 37.74286], [-122.41477, 37.74286], [-122.41477, 37.74327], [-122.41556, 37.74326], [-122.41555, 37.74286]]]} | Open Access 1 | 122 | Bernal Heights Park | 16026 | 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 | 19.35 | Bernal Heights Park | 0 | Local Park 2 | 4 | |
134 | 134 | 133 | {"type": "Polygon", "coordinates": [[[-122.42226, 37.73435], [-122.42174, 37.73471], [-122.42177, 37.73475], [-122.42174, 37.73506], [-122.42008, 37.73497], [-122.42016, 37.73405], [-122.41919, 37.734], [-122.41925, 37.73328], [-122.41931, 37.73301], [-122.41929, 37.733], [-122.41929, 37.73252], [-122.41954, 37.73252], [-122.41956, 37.73231], [-122.42009, 37.7323], [-122.4201, 37.73232], [-122.42027, 37.73232], [-122.42079, 37.73229], [-122.42084, 37.73243], [-122.42096, 37.7324], [-122.42091, 37.73226], [-122.421, 37.73225], [-122.42145, 37.7331], [-122.4217, 37.73332], [-122.42178, 37.73343], [-122.4221, 37.73413], [-122.42226, 37.73435]]]} | Open Access 1 | 342 | Saint Mary's Playground | 24791 | 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 | 13.777 | Saint Mary's Playground | 0 | Local Recreation Area 3 | 4 | |
721 | 721 | 720 | {"type": "Polygon", "coordinates": [[[-122.4813, 37.73044], [-122.48094, 37.73047], [-122.48094, 37.73108], [-122.47952, 37.73106], [-122.47952, 37.73057], [-122.47963, 37.73056], [-122.47999, 37.73047], [-122.48041, 37.73011], [-122.48105, 37.72997], [-122.48129, 37.73025], [-122.4813, 37.73044]]]} | Open Access 1 | 5402 | Rolph-Nicole Park | 24585 | 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.048 | Rolph-Nicole Park | 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]);