units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
503 rows where ACCESS_TYP = 1 and MNG_AGENCY = 4 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
DES_TP 18
- Local Park 274
- Local Recreation Area 202
- Local Other or Unknown 7
- Local Conservation Area 6
- Local Historic or Cultural Area 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 1
- San Diego, City of · 503 ✖
ACCESS_TYP 1
- Open Access · 503 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5775 | 5775 | 5774 | {"type": "Polygon", "coordinates": [[[-117.05795, 32.7466], [-117.05795, 32.74669], [-117.05759, 32.74659], [-117.05761, 32.74652], [-117.05777, 32.74658], [-117.05795, 32.7466]]]} | Open Access 1 | 5 | Zena Mini-Park | 27862 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.067 | Zena Mini-Park | 0 | Local Park 2 | 4 | |
5776 | 5776 | 5775 | {"type": "Polygon", "coordinates": [[[-117.12088, 32.74978], [-117.12063, 32.74969], [-117.12063, 32.74952], [-117.12075, 32.74941], [-117.12088, 32.74978]]]} | Open Access 1 | 6 | Wabash Neighborhood Park | 30119 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.131 | Wabash Neighborhood Park | 0 | Local Park 2 | 4 | |
5772 | 5772 | 5771 | {"type": "MultiPolygon", "coordinates": [[[[-117.09595, 32.73243], [-117.09595, 32.73295], [-117.09545, 32.73295], [-117.09545, 32.73292], [-117.09595, 32.73243]]], [[[-117.09843, 32.73523], [-117.09843, 32.73653], [-117.09794, 32.73653], [-117.09794, 32.73626], [-117.09742, 32.73627], [-117.09716, 32.73619], [-117.0962, 32.73618], [-117.0962, 32.73598], [-117.0967, 32.73597], [-117.09673, 32.7318], [-117.09719, 32.7318], [-117.09717, 32.73381], [-117.0979, 32.73382], [-117.09789, 32.73522], [-117.09843, 32.73523]]], [[[-117.09844, 32.73154], [-117.09844, 32.73179], [-117.09803, 32.7318], [-117.09802, 32.73173], [-117.09745, 32.73172], [-117.09745, 32.73153], [-117.09844, 32.73154]]], [[[-117.09875, 32.73833], [-117.09835, 32.73833], [-117.09836, 32.73695], [-117.09875, 32.73695], [-117.09875, 32.73833]]], [[[-117.09913, 32.73237], [-117.09913, 32.73258], [-117.09869, 32.73258], [-117.09869, 32.73237], [-117.09913, 32.73237]]], [[[-117.09913, 32.73195], [-117.09913, 32.73209], [-117.09869, 32.73209], [-117.09869, 32.73195], [-117.09913, 32.73195]]], [[[-117.09935, 32.73841], [-117.09934, 32.73864], [-117.09894, 32.73864], [-117.09894, 32.73841], [-117.09935, 32.73841]]]]} | Open Access 1 | 20 | Swan's Canyon | 26095 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 14.734 | Swan's Canyon | 0 | Local Recreation Area 3 | 4 | |
5787 | 5787 | 5786 | {"type": "Polygon", "coordinates": [[[-117.16383, 32.73565], [-117.16352, 32.73566], [-117.16351, 32.7358], [-117.16293, 32.7358], [-117.16292, 32.73594], [-117.16203, 32.73595], [-117.16202, 32.73649], [-117.16202, 32.73727], [-117.1617, 32.73727], [-117.1617, 32.73766], [-117.16137, 32.73766], [-117.16136, 32.73741], [-117.16137, 32.73596], [-117.16184, 32.73595], [-117.16185, 32.73568], [-117.16227, 32.73567], [-117.16226, 32.73477], [-117.16292, 32.73477], [-117.16293, 32.73452], [-117.16319, 32.73452], [-117.1632, 32.73438], [-117.16382, 32.73438], [-117.16383, 32.73565]]]} | Open Access 1 | 21 | Maple Canyon Open Space | 21772 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.943 | Maple Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6 | 6 | 5 | {"type": "MultiPolygon", "coordinates": [[[[-117.11089, 32.73295], [-117.11088, 32.73298], [-117.11086, 32.73286], [-117.1107, 32.73261], [-117.11037, 32.73248], [-117.10993, 32.73245], [-117.10979, 32.73242], [-117.10919, 32.73273], [-117.10874, 32.73272], [-117.10872, 32.73247], [-117.10818, 32.73272], [-117.10811, 32.73272], [-117.10788, 32.73308], [-117.10775, 32.73295], [-117.10773, 32.73295], [-117.1074, 32.73315], [-117.10734, 32.73317], [-117.10705, 32.7334], [-117.10683, 32.73321], [-117.10705, 32.73283], [-117.10727, 32.73261], [-117.10691, 32.73234], [-117.10697, 32.73229], [-117.10703, 32.73226], [-117.10776, 32.73211], [-117.10766, 32.73176], [-117.10765, 32.73157], [-117.10769, 32.73139], [-117.10774, 32.73124], [-117.10782, 32.73111], [-117.10802, 32.73089], [-117.10797, 32.73062], [-117.10803, 32.73067], [-117.10847, 32.7309], [-117.10876, 32.73109], [-117.10866, 32.73109], [-117.10858, 32.73107], [-117.10849, 32.73117], [-117.10866, 32.73138], [-117.10875, 32.73158], [-117.10881, 32.73182], [-117.10883, 32.73208], [-117.10939, 32.73195], [-117.10985, 32.73194], [-117.10996, 32.73191], [-117.11035, 32.73217], [-117.11072, 32.73258], [-117.11089, 32.73286], [-117.11089, 32.73295]]], [[[-117.10995, 32.73399], [-117.10989, 32.73404], [-117.10985, 32.734], [-117.10991, 32.73395], [-117.10995, 32.73399]]]]} | Open Access 1 | 26 | Azalea Neighborhood Park | 30115 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.138 | Azalea Neighborhood Park | 0 | Local Park 2 | 4 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 4 | |
5790 | 5790 | 5789 | {"type": "MultiPolygon", "coordinates": [[[[-117.05865, 32.73857], [-117.05803, 32.73858], [-117.05803, 32.73858], [-117.05803, 32.73856], [-117.05825, 32.73832], [-117.05837, 32.73835], [-117.05865, 32.73857]]], [[[-117.07608, 32.7349], [-117.07553, 32.73603], [-117.07537, 32.7361], [-117.07502, 32.7362], [-117.07475, 32.73625], [-117.07425, 32.73628], [-117.07389, 32.73626], [-117.07368, 32.73623], [-117.07342, 32.73618], [-117.07295, 32.73604], [-117.07392, 32.73416], [-117.07397, 32.73212], [-117.07206, 32.7321], [-117.07202, 32.73303], [-117.06932, 32.733], [-117.06852, 32.73484], [-117.06333, 32.73515], [-117.06296, 32.73519], [-117.06243, 32.73529], [-117.06193, 32.73541], [-117.06145, 32.73556], [-117.06106, 32.73572], [-117.06065, 32.73591], [-117.0602, 32.73616], [-117.05974, 32.73646], [-117.05946, 32.73668], [-117.05898, 32.73711], [-117.05826, 32.73785], [-117.05827, 32.73787], [-117.05822, 32.7379], [-117.05815, 32.73791], [-117.05808, 32.7379], [-117.05804, 32.73788], [-117.05806, 32.73498], [-117.05829, 32.73483], [-117.05962, 32.7333], [-117.06222, 32.73142], [-117.06439, 32.73013], [-117.06626, 32.72932], [-117.06794, 32.72884], [-117.06794, 32.72935], [-117.07536, 32.72946], [-117.07535, 32.73054], [-117.07436, 32.73039], [-117.07431, 32.7322], [-117.07528, 32.73223], [-117.07525, 32.73371], [-117.0751, 32.7337], [-117.0749, 32.73396], [-117.07524, 32.73479], [-117.07525, 32.73489], [-117.07608, 32.7349]]], [[[-117.07739, 32.73587], [-117.07737, 32.73674], [-117.07678, 32.73675], [-117.07676, 32.73801], [-117.07523, 32.73805], [-117.07525, 32.7402], [-117.07485, 32.7404], [-117.07138, 32.74035], [-117.07141, 32.73924], [-117.07138, 32.73918], [-117.07133, 32.73912], [-117.07133, 32.73895], [-117.06827, 32.7393], [-117.06726, 32.73928], [-117.06724, 32.74028], [-117.06672, 32.74028], [-117.06671, 32.73846], [-117.05891, 32.73857], [-117.05887, 32.73852], [-117.05867, 32.73833], [-117.05842, 32.73814], [-117.05854, 32.73799], [-117.05857, 32.738], [-117.05908, 32.73745], [-117.05943, 32.7371], [-117.05966, 32.7369], [-117.05991, 32.73671], [-117.06041, 32.73638], [-117.0608, 32.73616], [-117.06136, 32.73591], [-117.06196, 32.7357], [-117.0625, 32.73556], [-117.06343, 32.73542], [-117.06534, 32.73529], [-117.06849, 32.73512], [-117.06912, 32.73512], [-117.06941, 32.73515], [-117.06966, 32.73521], [-117.07013, 32.73534], [-117.07282, 32.73631], [-117.07351, 32.73649], [-117.07402, 32.73655], [-117.07434, 32.73656], [-117.07465, 32.73654], [-117.07493, 32.7365], [-117.07521, 32.73644], [-117.07551, 32.73635], [-117.0763, 32.73602], [-117.07656, 32.73594], [-117.07693, 32.73587], [-117.07739, 32.73587]]]]} | Open Access 1 | 39 | Chollas Lake Community Park | 30046 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 341.762 | Chollas Lake Community Park | 0 | Local Park 2 | 4 | |
5179 | 5179 | 5178 | {"type": "Polygon", "coordinates": [[[-117.15713, 32.7541], [-117.15639, 32.7541], [-117.15639, 32.75376], [-117.15712, 32.75376], [-117.15713, 32.7541]]]} | Open Access 1 | 40 | Mission Valley Hillsides Open Space | 22316 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.644 | Mission Valley Hillsides OS | 0 | Local Recreation Area 3 | 4 | |
5795 | 5795 | 5794 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75399], [-117.13391, 32.75399], [-117.13392, 32.75231], [-117.13395, 32.75221], [-117.13397, 32.7522], [-117.13398, 32.75045], [-117.13451, 32.75045], [-117.13451, 32.75112], [-117.13498, 32.75112], [-117.13499, 32.75399]]]} | Open Access 1 | 51 | North Park Community Park | 22844 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.653 | North Park Community Park | 0 | Local Park 2 | 4 | |
15958 | 15958 | 15957 | {"type": "MultiPolygon", "coordinates": [[[[-117.16852, 32.75178], [-117.16819, 32.75178], [-117.16819, 32.75095], [-117.16851, 32.75094], [-117.16852, 32.75178]]], [[[-117.17277, 32.75259], [-117.17219, 32.7526], [-117.17221, 32.75382], [-117.17234, 32.75383], [-117.17233, 32.75447], [-117.17188, 32.75448], [-117.17188, 32.75493], [-117.17128, 32.75494], [-117.17129, 32.75521], [-117.17188, 32.75521], [-117.17188, 32.75535], [-117.1704, 32.75535], [-117.1704, 32.75679], [-117.16881, 32.75676], [-117.16879, 32.75595], [-117.16827, 32.75595], [-117.16825, 32.7539], [-117.16825, 32.75383], [-117.16882, 32.75382], [-117.1688, 32.75369], [-117.1688, 32.75301], [-117.16946, 32.75301], [-117.16949, 32.75482], [-117.17153, 32.7548], [-117.17154, 32.75383], [-117.17152, 32.75273], [-117.17153, 32.75233], [-117.17127, 32.75232], [-117.17061, 32.75232], [-117.17062, 32.75197], [-117.17065, 32.75193], [-117.1707, 32.75191], [-117.17127, 32.75191], [-117.17128, 32.75218], [-117.17185, 32.75218], [-117.17186, 32.75225], [-117.17244, 32.75225], [-117.17245, 32.75219], [-117.17277, 32.75219], [-117.17277, 32.75259]]], [[[-117.1731, 32.75421], [-117.17278, 32.75421], [-117.17277, 32.75382], [-117.17309, 32.75381], [-117.1731, 32.75421]]]]} | Open Access 1 | 63 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 22.556 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
2839 | 2839 | 2838 | {"type": "Polygon", "coordinates": [[[-117.15582, 32.75554], [-117.15554, 32.75574], [-117.15531, 32.75552], [-117.15538, 32.75542], [-117.15582, 32.75543], [-117.15582, 32.75554]]]} | Open Access 1 | 68 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.27 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
5805 | 5805 | 5804 | {"type": "Polygon", "coordinates": [[[-117.15503, 32.75526], [-117.15494, 32.7552], [-117.15494, 32.75483], [-117.15502, 32.75483], [-117.15503, 32.75526]]]} | Open Access 1 | 73 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.082 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
15959 | 15959 | 15958 | {"type": "Polygon", "coordinates": [[[-117.15844, 32.75574], [-117.15803, 32.75574], [-117.15769, 32.75634], [-117.15747, 32.75625], [-117.15712, 32.75602], [-117.15701, 32.75585], [-117.15677, 32.7558], [-117.15656, 32.75572], [-117.15644, 32.75554], [-117.15643, 32.75545], [-117.15766, 32.75548], [-117.15765, 32.7543], [-117.15782, 32.75454], [-117.158, 32.75474], [-117.15844, 32.75574]]]} | Open Access 1 | 74 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.512 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
34 | 34 | 33 | {"type": "MultiPolygon", "coordinates": [[[[-117.17794, 32.74783], [-117.17775, 32.74806], [-117.17722, 32.74774], [-117.1774, 32.74752], [-117.17794, 32.74783]]], [[[-117.17828, 32.74722], [-117.17791, 32.74765], [-117.1775, 32.74741], [-117.17767, 32.74719], [-117.17788, 32.74732], [-117.17807, 32.74709], [-117.17828, 32.74722]]], [[[-117.18416, 32.74689], [-117.18397, 32.7471], [-117.18305, 32.74655], [-117.18229, 32.74742], [-117.18242, 32.74751], [-117.18213, 32.74784], [-117.1823, 32.74795], [-117.18122, 32.74795], [-117.18235, 32.74663], [-117.18211, 32.74647], [-117.18239, 32.74614], [-117.18259, 32.74591], [-117.18283, 32.74606], [-117.18329, 32.74552], [-117.18411, 32.74602], [-117.1836, 32.74661], [-117.18398, 32.74685], [-117.18403, 32.74681], [-117.18416, 32.74689]]]]} | Open Access 1 | 83 | Mission Hills Park and Open Space | 22301 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.109 | Mission Hills Park and OS | 0 | Local Recreation Area 3 | 4 | |
26 | 26 | 25 | {"type": "Polygon", "coordinates": [[[-117.08357, 32.75155], [-117.08352, 32.75156], [-117.08352, 32.75251], [-117.08356, 32.75252], [-117.08356, 32.75298], [-117.08332, 32.75306], [-117.08317, 32.75308], [-117.08165, 32.75308], [-117.08164, 32.75303], [-117.08042, 32.75302], [-117.0804, 32.75307], [-117.07989, 32.75305], [-117.07986, 32.753], [-117.07987, 32.75272], [-117.0797, 32.7518], [-117.07969, 32.75051], [-117.07966, 32.7505], [-117.07967, 32.74994], [-117.08202, 32.74993], [-117.08203, 32.75], [-117.08346, 32.75002], [-117.08348, 32.75006], [-117.08343, 32.75131], [-117.08356, 32.75132], [-117.08357, 32.75155]]]} | Open Access 1 | 89 | Colina Del Sol Community Park | 17497 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 29.899 | Colina Del Sol Community Park | 0 | Local Park 2 | 4 | |
5809 | 5809 | 5808 | {"type": "Polygon", "coordinates": [[[-117.18992, 32.75185], [-117.18955, 32.7523], [-117.18866, 32.75176], [-117.18881, 32.75169], [-117.18925, 32.75194], [-117.18954, 32.75161], [-117.18992, 32.75185]]]} | Open Access 1 | 90 | Presidio Open Space | 23994 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.879 | Presidio OS | 0 | Local Recreation Area 3 | 4 | |
4469 | 4469 | 4468 | {"type": "Polygon", "coordinates": [[[-117.06249, 32.75242], [-117.06211, 32.75251], [-117.06106, 32.75279], [-117.06087, 32.75234], [-117.0624, 32.75219], [-117.06249, 32.75242]]]} | Open Access 1 | 94 | Unnamed site - San Diego, City of | 28704 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.367 | 0 | Local Other or Unknown 14 | 4 | ||
41 | 41 | 40 | {"type": "Polygon", "coordinates": [[[-117.19344, 32.75165], [-117.19315, 32.75181], [-117.19311, 32.75179], [-117.19296, 32.75158], [-117.1933, 32.75139], [-117.19344, 32.75165]]]} | Open Access 1 | 95 | El Campo Santo Neighborhood Park | 30058 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.276 | El Campo Santo Neighborhood Park | 0 | Local Park 2 | 4 | |
5817 | 5817 | 5816 | {"type": "Polygon", "coordinates": [[[-117.07929, 32.75187], [-117.07928, 32.75306], [-117.07847, 32.75306], [-117.07843, 32.75304], [-117.0784, 32.75299], [-117.07841, 32.75278], [-117.07845, 32.75266], [-117.0786, 32.75249], [-117.07929, 32.75187]]]} | Open Access 1 | 100 | Colina Del Sol Community Park | 17497 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.783 | Colina Del Sol Community Park | 0 | Local Park 2 | 4 | |
5818 | 5818 | 5817 | {"type": "Polygon", "coordinates": [[[-117.08127, 32.81201], [-117.08111, 32.81199], [-117.08082, 32.81197], [-117.0803, 32.81201], [-117.08005, 32.81207], [-117.07981, 32.81215], [-117.07902, 32.81256], [-117.07878, 32.81271], [-117.0779, 32.81364], [-117.07744, 32.81414], [-117.07736, 32.81426], [-117.07726, 32.81451], [-117.07722, 32.81469], [-117.07681, 32.81432], [-117.08089, 32.8107], [-117.08127, 32.81201]]]} | Open Access 1 | 102 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.337 | Tierrasanta OS | 0 | Local Recreation Area 3 | 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]);