units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP >30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
4899 | 4899 | 4898 | {"type": "MultiPolygon", "coordinates": [[[[-122.47227, 37.75682], [-122.47215, 37.75701], [-122.47202, 37.75727], [-122.47195, 37.75729], [-122.47141, 37.75706], [-122.47129, 37.75698], [-122.4712, 37.7569], [-122.47111, 37.75678], [-122.47106, 37.75665], [-122.47105, 37.75655], [-122.47106, 37.75638], [-122.47147, 37.75639], [-122.47146, 37.75656], [-122.47151, 37.75669], [-122.47162, 37.75678], [-122.47179, 37.75685], [-122.47194, 37.75665], [-122.47227, 37.75682]]], [[[-122.47149, 37.75605], [-122.47147, 37.75632], [-122.47108, 37.75631], [-122.47109, 37.75604], [-122.47149, 37.75605]]], [[[-122.47257, 37.75623], [-122.47259, 37.75633], [-122.47257, 37.75647], [-122.47252, 37.75655], [-122.47232, 37.75676], [-122.47199, 37.75659], [-122.47219, 37.75636], [-122.4722, 37.75634], [-122.47197, 37.75608], [-122.47171, 37.7559], [-122.47192, 37.75563], [-122.47207, 37.75572], [-122.47224, 37.75585], [-122.47238, 37.756], [-122.47257, 37.75623]]]]} | Open Access 1 | 5586 | 14th & 15th Avenue Open Space | 15172 | 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.665 | 14th & 15th Avenue OS | 0 | Local Recreation Area 3 | 4 | |
5426 | 5426 | 5425 | {"type": "MultiPolygon", "coordinates": [[[[-122.47242, 37.78647], [-122.4723, 37.78697], [-122.47214, 37.78743], [-122.471, 37.78765], [-122.471, 37.78725], [-122.47099, 37.78724], [-122.46639, 37.78816], [-122.4663, 37.78691], [-122.47232, 37.78664], [-122.47231, 37.78644], [-122.47239, 37.78644], [-122.47242, 37.78647]]], [[[-122.4732, 37.78722], [-122.47257, 37.78734], [-122.4727, 37.78693], [-122.47281, 37.78642], [-122.47314, 37.7864], [-122.4732, 37.78722]]]]} | Open Access 1 | 18073 | Mountain Lake Park | 22542 | 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.741 | Mtn. Lake Park | 0 | Local Park 2 | 4 | |
9670 | 9670 | 9669 | {"type": "MultiPolygon", "coordinates": [[[[-122.47637, 37.73917], [-122.47555, 37.73921], [-122.47543, 37.73756], [-122.47625, 37.73752], [-122.47637, 37.73917]]], [[[-122.4765, 37.74103], [-122.47568, 37.74107], [-122.47556, 37.73943], [-122.47639, 37.73939], [-122.4765, 37.74103]]]]} | Open Access 1 | 16316 | Carl Larsen Park | 16853 | 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.585 | Carl Larsen Park | 0 | Local Park 2 | 4 | |
15688 | 15688 | 15687 | {"type": "MultiPolygon", "coordinates": [[[[-122.48702, 37.6263], [-122.48655, 37.62658], [-122.48643, 37.62662], [-122.48629, 37.62664], [-122.48616, 37.62664], [-122.48603, 37.62661], [-122.48592, 37.62657], [-122.48575, 37.62645], [-122.48565, 37.62631], [-122.48562, 37.6262], [-122.48558, 37.62569], [-122.48554, 37.6255], [-122.48541, 37.62524], [-122.48523, 37.62504], [-122.48501, 37.6249], [-122.48476, 37.62481], [-122.48384, 37.62463], [-122.48351, 37.62461], [-122.48332, 37.62463], [-122.48314, 37.62466], [-122.48161, 37.62511], [-122.48145, 37.62518], [-122.4813, 37.62526], [-122.4811, 37.62542], [-122.48093, 37.62562], [-122.48076, 37.62597], [-122.48052, 37.62649], [-122.48042, 37.62664], [-122.4803, 37.62675], [-122.48014, 37.62685], [-122.47997, 37.62693], [-122.47977, 37.62698], [-122.47875, 37.62705], [-122.47843, 37.6271], [-122.4688, 37.62708], [-122.46426, 37.62116], [-122.48041, 37.62146], [-122.48416, 37.62155], [-122.4842, 37.62157], [-122.48433, 37.62181], [-122.48449, 37.62195], [-122.48455, 37.62202], [-122.48465, 37.62231], [-122.48478, 37.62296], [-122.48492, 37.62338], [-122.48502, 37.6247], [-122.48516, 37.62476], [-122.48526, 37.62484], [-122.48533, 37.62493], [-122.48539, 37.62505], [-122.48659, 37.62582], [-122.48702, 37.6263]]], [[[-122.48741, 37.62712], [-122.48228, 37.62711], [-122.48228, 37.62601], [-122.48126, 37.62601], [-122.48125, 37.62656], [-122.48099, 37.62656], [-122.48098, 37.6271], [-122.48003, 37.6271], [-122.48021, 37.62703], [-122.48036, 37.62694], [-122.4805, 37.62682], [-122.48061, 37.6267], [-122.48073, 37.62653], [-122.48111, 37.6257], [-122.48124, 37.62553], [-122.48141, 37.6254], [-122.48169, 37.62527], [-122.48319, 37.62482], [-122.48338, 37.62478], [-122.48358, 37.62477], [-122.48382, 37.62479], [-122.48471, 37.62497], [-122.48493, 37.62506], [-122.4851, 37.62517], [-122.48523, 37.62533], [-122.4853, 37.62544], [-122.48535, 37.62557], [-122.48537, 37.6257], [-122.48542, 37.62622], [-122.48545, 37.62635], [-122.48556, 37.62653], [-122.48573, 37.62667], [-122.4859, 37.62675], [-122.48606, 37.62679], [-122.48625, 37.62681], [-122.48642, 37.62679], [-122.48666, 37.62672], [-122.48715, 37.62643], [-122.48726, 37.62655], [-122.48727, 37.62691], [-122.48741, 37.62712]]], [[[-122.49707, 37.62106], [-122.49634, 37.62137], [-122.49632, 37.62144], [-122.49668, 37.62221], [-122.49506, 37.62934], [-122.49503, 37.62979], [-122.49502, 37.62963], [-122.49501, 37.62962], [-122.49458, 37.62988], [-122.49433, 37.63], [-122.49411, 37.63001], [-122.49409, 37.62982], [-122.49222, 37.62982], [-122.49189, 37.62978], [-122.49148, 37.62965], [-122.49127, 37.62955], [-122.49115, 37.62947], [-122.49101, 37.62934], [-122.49083, 37.62911], [-122.49076, 37.62898], [-122.49068, 37.62876], [-122.49065, 37.62864], [-122.49057, 37.6272], [-122.48958, 37.62723], [-122.48938, 37.62671], [-122.48924, 37.62643], [-122.48908, 37.6262], [-122.48887, 37.62595], [-122.4887, 37.62578], [-122.48815, 37.62535], [-122.48786, 37.62507], [-122.48618, 37.62321], [-122.48574, 37.62275], [-122.48556, 37.62251], [-122.48553, 37.62225], [-122.48562, 37.62203], [-122.48591, 37.62164], [-122.49152, 37.62174], [-122.49152, 37.62169], [-122.49159, 37.62173], [-122.49344, 37.62181], [-122.4931, 37.62054], [-122.49707, 37.62106]]]]} | Restricted Access 2 | 15359 | Sharp Park Golf Course | 33048 | 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 Mateo 15 | 407.344 | Sharp Park GC | 1972 | Local Recreation Area 3 | 4 | |
3950 | 3950 | 3949 | {"type": "Polygon", "coordinates": [[[-122.37598, 37.7332], [-122.37557, 37.73365], [-122.3748, 37.73321], [-122.3752, 37.73276], [-122.37598, 37.7332]]]} | Open Access 1 | 47543 | India Basin Waterfront Park | 31251 | 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.262 | India Basin Waterfront Park | 0 | Local Park 2 | 4 | |
16902 | 16902 | 16901 | {"type": "Polygon", "coordinates": [[[-122.37691, 37.72997], [-122.37659, 37.73005], [-122.37631, 37.73007], [-122.376, 37.73004], [-122.37574, 37.72998], [-122.37573, 37.72996], [-122.37596, 37.72969], [-122.37631, 37.72937], [-122.37639, 37.72939], [-122.37665, 37.72955], [-122.37687, 37.72986], [-122.37691, 37.72997]]]} | Open Access 1 | 24970 | Milton Myer Recreation Center | 22256 | 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.224 | Milton Myer Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
4647 | 4647 | 4646 | {"type": "Polygon", "coordinates": [[[-122.38148, 37.73182], [-122.38122, 37.73211], [-122.38122, 37.73223], [-122.38105, 37.73214], [-122.38098, 37.73216], [-122.3807, 37.73205], [-122.38067, 37.73203], [-122.38065, 37.73199], [-122.38066, 37.73194], [-122.38081, 37.73176], [-122.38103, 37.73152], [-122.38108, 37.7315], [-122.38114, 37.7315], [-122.38118, 37.73152], [-122.38134, 37.73167], [-122.38138, 37.73177], [-122.38148, 37.73182]]]} | Open Access 1 | 36528 | Unnamed site - San Francisco, City of | 28697 | 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.816 | 0 | Local Other or Unknown 14 | 4 | ||
4272 | 4272 | 4271 | {"type": "Polygon", "coordinates": [[[-122.38404, 37.75453], [-122.38349, 37.75473], [-122.38319, 37.75463], [-122.38303, 37.7544], [-122.38296, 37.75433], [-122.38291, 37.75389], [-122.38294, 37.75343], [-122.38306, 37.75332], [-122.38311, 37.75341], [-122.38316, 37.75418], [-122.38321, 37.75428], [-122.38326, 37.7543], [-122.38401, 37.75423], [-122.38404, 37.75453]]]} | Open Access 1 | 45362 | Warm Water Cove | 27262 | 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.343 | Warm Water Cove | None 373 | |||
935 | 935 | 934 | {"type": "Polygon", "coordinates": [[[-122.3848, 37.73307], [-122.38477, 37.73311], [-122.38459, 37.73327], [-122.3845, 37.73331], [-122.38444, 37.7333], [-122.38415, 37.73321], [-122.38387, 37.73315], [-122.38363, 37.73314], [-122.3834, 37.73315], [-122.38273, 37.7333], [-122.3826, 37.73335], [-122.38234, 37.73347], [-122.38224, 37.73345], [-122.38213, 37.73334], [-122.3825, 37.73305], [-122.3832, 37.73228], [-122.38385, 37.73254], [-122.38426, 37.73273], [-122.38476, 37.733], [-122.38479, 37.73303], [-122.3848, 37.73307]]]} | Open Access 1 | 5943 | Hilltop Park | 19990 | 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.456 | Hilltop Park | 0 | Local Park 2 | 4 | |
6487 | 6487 | 6486 | {"type": "Polygon", "coordinates": [[[-122.38603, 37.73925], [-122.38546, 37.73987], [-122.38325, 37.73861], [-122.3832, 37.73817], [-122.38362, 37.73814], [-122.38358, 37.73766], [-122.38403, 37.73764], [-122.38454, 37.73806], [-122.38435, 37.73829], [-122.38603, 37.73925]]]} | Open Access 1 | 2339 | Youngblood-Coleman Playground | 27790 | 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.153 | Youngblood-Coleman Playground | 0 | Local Recreation Area 3 | 4 | |
5452 | 5452 | 5451 | {"type": "Polygon", "coordinates": [[[-122.38674, 37.76527], [-122.38641, 37.76568], [-122.38597, 37.76658], [-122.38587, 37.76659], [-122.38593, 37.76636], [-122.38592, 37.76628], [-122.38629, 37.76569], [-122.38652, 37.76541], [-122.38654, 37.76529], [-122.38647, 37.76528], [-122.38646, 37.76523], [-122.38674, 37.76527]]]} | Open Access 1 | 24968 | Agua Vista Park | 15295 | 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.469 | Agua Vista Park | 0 | Local Park 2 | 4 | |
7026 | 7026 | 7025 | {"type": "Polygon", "coordinates": [[[-122.39017, 37.73464], [-122.38977, 37.73509], [-122.38872, 37.73449], [-122.38891, 37.73427], [-122.38877, 37.73418], [-122.38898, 37.73396], [-122.39017, 37.73464]]]} | Open Access 1 | 5967 | Joseph Lee Recreation Center | 30856 | 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 | http://sfrecpark.org/destination/joseph-lee-rec-center/ | San Francisco 13 | 1.855 | Joseph Lee Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
891 | 891 | 890 | {"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 | 5752 | Esprit Park | 18718 | 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.814 | Esprit Park | 0 | Local Park 2 | 4 | |
3592 | 3592 | 3591 | {"type": "Polygon", "coordinates": [[[-122.39224, 37.7649], [-122.39054, 37.76501], [-122.39054, 37.76501], [-122.39057, 37.76489], [-122.39068, 37.7646], [-122.3907, 37.76449], [-122.39068, 37.76432], [-122.39218, 37.76423], [-122.39224, 37.7649]]]} | Open Access 1 | 48778 | Mariposa Park | 33504 | 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://missionbayparks.com/mariposa-park/ | San Francisco 13 | 2.58 | Mariposa Park | 0 | Local Park 2 | 4 |
3595 | 3595 | 3594 | {"type": "Polygon", "coordinates": [[[-122.39332, 37.77186], [-122.39223, 37.77272], [-122.39223, 37.77272], [-122.39215, 37.77193], [-122.39332, 37.77186]]]} | Open Access 1 | 48779 | Kids' Park | 33505 | 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://missionbayparks.com/childrens-park/ | San Francisco 13 | 1.121 | Kids' Park | 0 | Local Park 2 | 4 |
6945 | 6945 | 6944 | {"type": "Polygon", "coordinates": [[[-122.39405, 37.7255], [-122.39347, 37.72679], [-122.39241, 37.72618], [-122.39337, 37.72511], [-122.39405, 37.7255]]]} | Open Access 1 | 5921 | Bay View Playground | 15884 | 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.402 | Bay View Playground | 0 | Local Recreation Area 3 | 4 | |
6104 | 6104 | 6103 | {"type": "Polygon", "coordinates": [[[-122.3946, 37.78122], [-122.39403, 37.78161], [-122.39339, 37.7821], [-122.39323, 37.78208], [-122.3932, 37.78198], [-122.39385, 37.78147], [-122.39436, 37.78105], [-122.39447, 37.781], [-122.3946, 37.78105], [-122.3946, 37.78122]]]} | Open Access 1 | 1023 | South Park | 25673 | 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.926 | South Park | 0 | Local Park 2 | 4 | |
7868 | 7868 | 7867 | {"type": "Polygon", "coordinates": [[[-122.39569, 37.73564], [-122.39563, 37.73571], [-122.39564, 37.73573], [-122.39537, 37.73603], [-122.39551, 37.73612], [-122.39528, 37.73635], [-122.39467, 37.736], [-122.39488, 37.73577], [-122.3947, 37.73565], [-122.39489, 37.73543], [-122.39476, 37.73535], [-122.39455, 37.73557], [-122.39336, 37.73489], [-122.39356, 37.73467], [-122.39454, 37.73523], [-122.39468, 37.73509], [-122.39569, 37.73564]]]} | Open Access 1 | 5979 | Paluo Phelps Mini Park | 23375 | 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.644 | Paluo Phelps MP | 0 | Local Park 2 | 4 | |
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 |
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]);