superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
433 rows where MNG_AGENCY = 4
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5100 | 5100 | 5099 | {"type": "MultiPolygon", "coordinates": [[[[-117.1681, 32.83591], [-117.16809, 32.83651], [-117.16806, 32.83678], [-117.16796, 32.83715], [-117.16778, 32.8376], [-117.1677, 32.83797], [-117.16768, 32.83814], [-117.16768, 32.83894], [-117.16511, 32.83896], [-117.16509, 32.8392], [-117.1635, 32.83922], [-117.16349, 32.83823], [-117.16255, 32.83823], [-117.16249, 32.83577], [-117.16617, 32.83574], [-117.16619, 32.83593], [-117.1681, 32.83591]]], [[[-117.16833, 32.83893], [-117.16791, 32.83894], [-117.16791, 32.83815], [-117.16794, 32.83788], [-117.16803, 32.83757], [-117.16822, 32.83706], [-117.16831, 32.83659], [-117.16833, 32.83893]]]]} | Open Access 1 | Hickman Field Athletic Complex | 19895 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 44.182 | Hickman Field Athletic Complex | ||
5635 | 5635 | 5634 | {"type": "MultiPolygon", "coordinates": [[[[-117.11576, 32.72532], [-117.11524, 32.72532], [-117.11511, 32.72495], [-117.11511, 32.72467], [-117.11521, 32.7245], [-117.11576, 32.7245], [-117.11576, 32.72532]]], [[[-117.11576, 32.72642], [-117.11564, 32.72642], [-117.11563, 32.72641], [-117.11532, 32.72554], [-117.11576, 32.72554], [-117.11576, 32.72642]]], [[[-117.11576, 32.72371], [-117.11576, 32.72428], [-117.11537, 32.72428], [-117.11537, 32.72428], [-117.11576, 32.72371]]], [[[-117.11774, 32.72291], [-117.11658, 32.7244], [-117.11656, 32.72428], [-117.11601, 32.72428], [-117.11602, 32.72345], [-117.11657, 32.72343], [-117.11655, 32.72323], [-117.11608, 32.72323], [-117.11666, 32.72242], [-117.11668, 32.72242], [-117.11669, 32.7229], [-117.11694, 32.7229], [-117.11695, 32.72242], [-117.11753, 32.72244], [-117.11756, 32.72247], [-117.11756, 32.72286], [-117.1176, 32.72287], [-117.11761, 32.72291], [-117.11774, 32.72291]]], [[[-117.11669, 32.72195], [-117.11669, 32.7222], [-117.11652, 32.72219], [-117.11652, 32.72219], [-117.11669, 32.72195]]], [[[-117.11764, 32.72136], [-117.11762, 32.72221], [-117.11695, 32.7222], [-117.11695, 32.72207], [-117.11729, 32.72157], [-117.11729, 32.72136], [-117.11764, 32.72136]]], [[[-117.11765, 32.72032], [-117.11764, 32.72114], [-117.11729, 32.72115], [-117.11728, 32.72032], [-117.11765, 32.72032]]], [[[-117.11944, 32.7216], [-117.11944, 32.72224], [-117.11913, 32.72226], [-117.11913, 32.72245], [-117.11944, 32.72246], [-117.11944, 32.72296], [-117.11875, 32.72295], [-117.11874, 32.7229], [-117.11868, 32.72289], [-117.11868, 32.72277], [-117.11875, 32.72275], [-117.11875, 32.72248], [-117.11868, 32.72247], [-117.11868, 32.72239], [-117.11878, 32.72239], [-117.1188, 32.72232], [-117.11878, 32.7223], [-117.11834, 32.72229], [-117.11816, 32.72231], [-117.11784, 32.72281], [-117.11774, 32.72281], [-117.11775, 32.72233], [-117.11785, 32.7222], [-117.11789, 32.72208], [-117.11788, 32.72199], [-117.11791, 32.72034], [-117.11793, 32.72032], [-117.11821, 32.72031], [-117.11823, 32.72025], [-117.11826, 32.72025], [-117.11853, 32.72032], [-117.11871, 32.72042], [-117.11878, 32.7205], [-117.11887, 32.72063], [-117.11889, 32.72071], [-117.11893, 32.72125], [-117.11896, 32.72131], [-117.11904, 32.7214], [-117.11911, 32.72142], [-117.11944, 32.72144], [-117.11944, 32.7216]]], [[[-117.11958, 32.72025], [-117.11958, 32.72052], [-117.11944, 32.72053], [-117.11943, 32.7212], [-117.11911, 32.72119], [-117.11907, 32.72069], [-117.11903, 32.72055], [-117.11893, 32.7204], [-117.11882, 32.72031], [-117.11872, 32.72025], [-117.11958, 32.72025]]], [[[-117.12036, 32.72145], [-117.12036, 32.72224], [-117.11969, 32.72224], [-117.11971, 32.72144], [-117.12036, 32.72145]]], [[[-117.12049, 32.72093], [-117.12048, 32.72117], [-117.12002, 32.7212], [-117.1197, 32.7212], [-117.1197, 32.72079], [-117.12003, 32.72079], [-117.12005, 32.72093], [-117.12049, 32.72093]]], [[[-117.12035, 32.72247], [-117.12035, 32.72293], [-117.1197, 32.72291], [-117.1197, 32.72246], [-117.12035, 32.72247]]], [[[-117.12165, 32.72222], [-117.12093, 32.72223], [-117.12091, 32.72226], [-117.12062, 32.72225], [-117.12062, 32.72145], [-117.12085, 32.72144], [-117.12086, 32.72138], [-117.12111, 32.72138], [-117.12112, 32.72178], [-117.12132, 32.72179], [-117.12135, 32.72193], [-117.12165, 32.72193], [-117.12165, 32.72222]]], [[[-117.12078, 32.72249], [-117.12077, 32.72294], [-117.12062, 32.72293], [-117.12062, 32.72248], [-117.12078, 32.72249]]], [[[-117.12155, 32.72972], [-117.12152, 32.73053], [-117.12093, 32.73053], [-117.12094, 32.72972], [-117.12155, 32.72972]]], [[[-117.12271, 32.72407], [-117.12135, 32.72408], [-117.12134, 32.72394], [-117.12096, 32.72394], [-117.12094, 32.72349], [-117.1227, 32.7235], [-117.12271, 32.72407]]], [[[-117.1216, 32.72868], [-117.12156, 32.7295], [-117.12095, 32.72949], [-117.12096, 32.72868], [-117.1216, 32.72868]]], [[[-117.12165, 32.72764], [-117.12161, 32.72846], [-117.12096, 32.72846], [-117.121, 32.72764], [-117.12165, 32.72764]]], [[[-117.12137, 32.72539], [-117.12101, 32.72539], [-117.121, 32.72498], [-117.12137, 32.72497], [-117.12137, 32.72539]]], [[[-117.1217, 32.72665], [-117.12166, 32.72742], [-117.121, 32.72742], [-117.12105, 32.72666], [-117.1217, 32.72665]]], [[[-117.12129, 32.7201], [-117.1211, 32.7201], [-117.12111, 32.71931], [-117.12129, 32.7193], [-117.12129, 32.7201]]], [[[-117.12166, 32.7227], [-117.12134, 32.7227], [-117.12134, 32.72284], [-117.12113, 32.72284], [-117.12113, 32.72242], [-117.12165, 32.72242], [-117.12166, 32.7227]]], [[[-117.12162, 32.72045], [-117.12129, 32.72045], [-117.12129, 32.72032], [-117.12162, 32.72031], [-117.12162, 32.72045]]], [[[-117.1217, 32.72628], [-117.12138, 32.72628], [-117.12137, 32.72561], [-117.12169, 32.72562], [-117.1217, 32.72628]]], [[[-117.12236, 32.73181], [-117.12232, 32.73262], [-117.12167, 32.73263], [-117.1217, 32.73181], [-117.12236, 32.73181]]], [[[-117.12209, 32.73076], [-117.12205, 32.73159], [-117.12172, 32.73159], [-117.12176, 32.73075], [-117.12209, 32.73076]]], [[[-117.12247, 32.72973], [-117.12243, 32.73025], [-117.12213, 32.73026], [-117.1221, 32.73053], [-117.12177, 32.73053], [-117.12182, 32.72972], [-117.12247, 32.72973]]], [[[-117.12251, 32.72868], [-117.1225, 32.72895], [-117.12218, 32.72894], [-117.12217, 32.72881], [-117.12186, 32.72881], [-117.12186, 32.72868], [-117.12251, 32.72868]]], [[[-117.12252, 32.72831], [-117.12251, 32.72847], [-117.12187, 32.72847], [-117.1219, 32.7279], [-117.12223, 32.7279], [-117.12221, 32.7283], [-117.12252, 32.72831]]], [[[-117.12221, 32.72059], [-117.12221, 32.72073], [-117.12189, 32.72073], [-117.12188, 32.72031], [-117.12204, 32.72032], [-117.12205, 32.72058], [-117.12221, 32.72059]]], [[[-117.1226, 32.72206], [-117.1226, 32.72224], [-117.12223, 32.72224], [-117.12221, 32.72222], [-117.12191, 32.72222], [-117.12192, 32.72194], [-117.12259, 32.72193], [-117.1226, 32.72206]]], [[[-117.12235, 32.73288], [-117.12232, 32.73354], [-117.12193, 32.73354], [-117.12196, 32.73326], [-117.12195, 32.73312], [-117.12197, 32.73284], [-117.12231, 32.73285], [-117.12235, 32.73288]]], [[[-117.12262, 32.72643], [-117.12197, 32.72644], [-117.12195, 32.7255], [-117.12229, 32.7255], [-117.1223, 32.72587], [-117.12262, 32.72588], [-117.12262, 32.72643]]], [[[-117.12262, 32.72665], [-117.1226, 32.7269], [-117.12228, 32.7269], [-117.1223, 32.72665], [-117.12262, 32.72665]]], [[[-117.12334, 32.73041], [-117.12334, 32.73055], [-117.12268, 32.73054], [-117.1227, 32.73013], [-117.12303, 32.73013], [-117.12303, 32.73039], [-117.12334, 32.73041]]], [[[-117.1235, 32.72433], [-117.12285, 32.72435], [-117.12284, 32.72401], [-117.12316, 32.724], [-117.12318, 32.72413], [-117.1235, 32.72413], [-117.1235, 32.72433]]], [[[-117.12351, 32.72665], [-117.12349, 32.72702], [-117.12318, 32.72703], [-117.12317, 32.7269], [-117.12286, 32.7269], [-117.12288, 32.72665], [-117.12351, 32.72665]]], [[[-117.12352, 32.72481], [-117.12352, 32.72496], [-117.12319, 32.72497], [-117.12317, 32.72482], [-117.12344, 32.72481], [-117.12345, 32.72468], [-117.12351, 32.72468], [-117.12352, 32.72481]]], [[[-117.12468, 32.72741], [-117.12372, 32.72742], [-117.12375, 32.72684], [-117.12396, 32.72705], [-117.12406, 32.72713], [-117.1242, 32.72718], [-117.1245, 32.72724], [-117.12458, 32.72729], [-117.12468, 32.72741]]], [[[-117.12411, 32.72529], [-117.12378, 32.72529], [-117.12377, 32.72455], [-117.1241, 32.72454], [-117.12411, 32.72529]]], [[[-117.12527, 32.7279], [-117.12525, 32.72818], [-117.12493, 32.72818], [-117.12492, 32.72805], [-117.12462, 32.72805], [-117.12463, 32.72763], [-117.12495, 32.72763], [-117.12495, 32.72789], [-117.12527, 32.7279]]], [[[-117.12589, 32.72848], [-117.12541, 32.72847], [-117.12541, 32.72809], [-117.12588, 32.72808], [-117.12589, 32.72848]]]]} | Open Access 1 | Juniper Canyon | 20525 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 42.798 | Juniper Canyon | ||
5660 | 5660 | 5659 | {"type": "Polygon", "coordinates": [[[-117.2417, 32.81614], [-117.23833, 32.81687], [-117.23832, 32.81689], [-117.23842, 32.81713], [-117.23826, 32.81717], [-117.23816, 32.81691], [-117.23723, 32.81712], [-117.23538, 32.81115], [-117.23508, 32.81011], [-117.23786, 32.8095], [-117.23794, 32.80959], [-117.2382, 32.80978], [-117.23911, 32.81015], [-117.23932, 32.81029], [-117.23947, 32.8104], [-117.23969, 32.81068], [-117.23979, 32.81092], [-117.23996, 32.81144], [-117.24073, 32.81394], [-117.24093, 32.81443], [-117.24138, 32.81533], [-117.2414, 32.81542], [-117.24156, 32.81573], [-117.2417, 32.81614]]]} | Open Access 1 | Kate O. Sessions Memorial Park | 20557 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 78.984 | Kate O. Sessions Memorial Park | ||
5669 | 5669 | 5668 | {"type": "Polygon", "coordinates": [[[-117.17362, 32.8019], [-117.1733, 32.80202], [-117.16971, 32.80301], [-117.1697, 32.80297], [-117.16955, 32.80286], [-117.1694, 32.80266], [-117.16929, 32.80277], [-117.16922, 32.80286], [-117.16907, 32.80297], [-117.16892, 32.80311], [-117.16895, 32.80323], [-117.16727, 32.8037], [-117.16726, 32.80307], [-117.16677, 32.8032], [-117.16643, 32.80326], [-117.1659, 32.80331], [-117.16557, 32.80331], [-117.16507, 32.80327], [-117.16505, 32.80329], [-117.16483, 32.80328], [-117.16438, 32.80321], [-117.16413, 32.80315], [-117.16386, 32.80306], [-117.1637, 32.803], [-117.16366, 32.80294], [-117.16368, 32.8029], [-117.16561, 32.80036], [-117.16729, 32.80036], [-117.16731, 32.79849], [-117.17164, 32.79847], [-117.17178, 32.79886], [-117.17199, 32.79924], [-117.17312, 32.80079], [-117.17326, 32.80101], [-117.17344, 32.80136], [-117.17362, 32.8019]]]} | Open Access 1 | Kearny Mesa Community Park | 20566 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 81.602 | Kearny Mesa Community Park | ||
5675 | 5675 | 5674 | {"type": "Polygon", "coordinates": [[[-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76218, 32.58046], [-116.76212, 32.58426], [-116.75375, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74512, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58731], [-116.7329, 32.5834], [-116.73714, 32.58342], [-116.74113, 32.58361], [-116.74116, 32.57637], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.56911], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352]]]} | No Public Access 3 | Marron Valley Mitigation Bank | 21885 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 2644.376 | Marron Valley Mitigation Bank | ||
5692 | 5692 | 5691 | {"type": "Polygon", "coordinates": [[[-117.25801, 32.85566], [-117.25562, 32.85961], [-117.25539, 32.8596], [-117.25547, 32.85848], [-117.25734, 32.85536], [-117.25801, 32.85566]]]} | Open Access 1 | Kellogg Park | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/kelloggpark | 20584 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7.978 | Kellogg Park | |
5711 | 5711 | 5710 | {"type": "Polygon", "coordinates": [[[-117.10725, 32.76293], [-117.10724, 32.7631], [-117.10719, 32.76314], [-117.10648, 32.76313], [-117.10643, 32.76311], [-117.10641, 32.76307], [-117.10642, 32.7629], [-117.10648, 32.76287], [-117.10719, 32.76288], [-117.10723, 32.7629], [-117.10725, 32.76293]]]} | Open Access 1 | Kensington Park | 20613 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.548 | Kensington Park | ||
5796 | 5796 | 5795 | {"type": "Polygon", "coordinates": [[[-117.13376, 32.70693], [-117.13375, 32.70731], [-117.13361, 32.70731], [-117.1336, 32.70693], [-117.13376, 32.70693]]]} | Open Access 1 | L Street Mini Park | 20736 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.151 | L Street MP | ||
5816 | 5816 | 5815 | {"type": "MultiPolygon", "coordinates": [[[[-117.27679, 32.84226], [-117.27638, 32.84236], [-117.27637, 32.84232], [-117.27634, 32.84231], [-117.27618, 32.84182], [-117.2764, 32.84185], [-117.27665, 32.84183], [-117.27679, 32.84226]]], [[[-117.27836, 32.84308], [-117.27824, 32.84329], [-117.27784, 32.84366], [-117.27774, 32.84378], [-117.27766, 32.84398], [-117.27705, 32.84221], [-117.27754, 32.84211], [-117.27764, 32.84237], [-117.27812, 32.84227], [-117.27836, 32.84308]]]]} | Open Access 1 | La Jolla Community Park | 20763 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.917 | La Jolla Community Park | ||
5817 | 5817 | 5816 | {"type": "MultiPolygon", "coordinates": [[[[-117.26548, 32.84333], [-117.26547, 32.84364], [-117.2652, 32.8437], [-117.26511, 32.84366], [-117.26499, 32.84366], [-117.2649, 32.84372], [-117.26487, 32.84377], [-117.26422, 32.84393], [-117.2641, 32.84393], [-117.26406, 32.84397], [-117.26369, 32.84406], [-117.26355, 32.84406], [-117.26353, 32.84403], [-117.26343, 32.84399], [-117.26317, 32.84393], [-117.26309, 32.84393], [-117.26294, 32.84381], [-117.26285, 32.84379], [-117.26275, 32.84388], [-117.26274, 32.84395], [-117.26275, 32.84399], [-117.2628, 32.84402], [-117.26294, 32.84404], [-117.26305, 32.84407], [-117.26322, 32.84416], [-117.26071, 32.84475], [-117.26029, 32.84487], [-117.26016, 32.84487], [-117.25892, 32.84516], [-117.25842, 32.84358], [-117.25809, 32.84261], [-117.25941, 32.84228], [-117.26273, 32.8415], [-117.26283, 32.84162], [-117.26297, 32.84201], [-117.26303, 32.84209], [-117.26319, 32.8422], [-117.26407, 32.84242], [-117.26441, 32.84253], [-117.26444, 32.84256], [-117.2646, 32.84263], [-117.26461, 32.84265], [-117.26475, 32.84275], [-117.2653, 32.84321], [-117.26548, 32.84333]]], [[[-117.26349, 32.84409], [-117.26328, 32.84414], [-117.26311, 32.84404], [-117.26296, 32.84399], [-117.26281, 32.84397], [-117.26279, 32.84394], [-117.2628, 32.8439], [-117.26287, 32.84384], [-117.26292, 32.84386], [-117.26303, 32.84396], [-117.26308, 32.84398], [-117.26349, 32.84409]]], [[[-117.264, 32.8423], [-117.26331, 32.84213], [-117.2632, 32.84207], [-117.26312, 32.842], [-117.26308, 32.84195], [-117.26297, 32.84161], [-117.26288, 32.84147], [-117.2632, 32.84139], [-117.264, 32.8423]]]]} | Open Access 1 | La Jolla Heights Natural Park | 20764 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 41.001 | La Jolla Heights Natural Park | ||
5818 | 5818 | 5817 | {"type": "Polygon", "coordinates": [[[-117.273, 32.81695], [-117.27253, 32.81748], [-117.27252, 32.81747], [-117.27251, 32.81744], [-117.27266, 32.817], [-117.27267, 32.81695], [-117.27265, 32.81686], [-117.27284, 32.81681], [-117.27286, 32.81666], [-117.27291, 32.81663], [-117.273, 32.81695]]]} | Open Access 1 | La Jolla Hermosa Park | 20765 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.384 | La Jolla Hermosa Park | ||
5819 | 5819 | 5818 | {"type": "MultiPolygon", "coordinates": [[[[-117.25536, 32.86173], [-117.25533, 32.86181], [-117.2549, 32.86361], [-117.25479, 32.86414], [-117.25475, 32.86414], [-117.25526, 32.86175], [-117.25527, 32.86172], [-117.25536, 32.86173]]], [[[-117.25937, 32.8546], [-117.25846, 32.85577], [-117.25608, 32.85993], [-117.25544, 32.86158], [-117.25528, 32.86156], [-117.25594, 32.85989], [-117.25567, 32.85979], [-117.25817, 32.85565], [-117.25908, 32.85454], [-117.25937, 32.8546]]]]} | Open Access 1 | La Jolla Shores Park | 20768 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 6.754 | La Jolla Shores Park | ||
5820 | 5820 | 5819 | {"type": "Polygon", "coordinates": [[[-117.26413, 32.82818], [-117.26378, 32.82828], [-117.26336, 32.82803], [-117.26327, 32.82825], [-117.2632, 32.82823], [-117.26309, 32.82823], [-117.26284, 32.82834], [-117.26253, 32.82854], [-117.26228, 32.82857], [-117.26208, 32.82853], [-117.26208, 32.82838], [-117.26183, 32.82841], [-117.26175, 32.82826], [-117.26166, 32.82822], [-117.26165, 32.82805], [-117.26172, 32.82796], [-117.26163, 32.82784], [-117.26181, 32.82772], [-117.26193, 32.82775], [-117.26207, 32.82758], [-117.26227, 32.82744], [-117.26252, 32.82746], [-117.26312, 32.82771], [-117.26413, 32.82818]]]} | Open Access 1 | La Jolla Bluebird Canyon Open Space | 20762 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.715 | La Jolla Bluebird Canyon OS | ||
5821 | 5821 | 5820 | {"type": "MultiPolygon", "coordinates": [[[[-117.23727, 32.8639], [-117.23644, 32.86425], [-117.23638, 32.8638], [-117.23635, 32.86319], [-117.23639, 32.86239], [-117.23655, 32.86237], [-117.23654, 32.86199], [-117.23666, 32.86171], [-117.23669, 32.86284], [-117.23727, 32.8639]]], [[[-117.23873, 32.83257], [-117.23825, 32.83268], [-117.2382, 32.83254], [-117.23868, 32.83244], [-117.23873, 32.83257]]], [[[-117.24528, 32.86108], [-117.24497, 32.8612], [-117.24448, 32.86133], [-117.24432, 32.8614], [-117.24396, 32.86163], [-117.24375, 32.86184], [-117.24361, 32.86209], [-117.24352, 32.86238], [-117.24351, 32.86265], [-117.24338, 32.86178], [-117.24345, 32.86156], [-117.24359, 32.86139], [-117.24371, 32.86131], [-117.24394, 32.86122], [-117.24476, 32.86117], [-117.24528, 32.86108]]], [[[-117.24407, 32.87689], [-117.24399, 32.87689], [-117.24384, 32.87595], [-117.24384, 32.87559], [-117.24407, 32.87542], [-117.24407, 32.87689]]], [[[-117.2441, 32.87161], [-117.24408, 32.87504], [-117.24394, 32.87515], [-117.24395, 32.87196], [-117.24389, 32.8716], [-117.2441, 32.87161]]], [[[-117.24598, 32.85902], [-117.24599, 32.85969], [-117.24598, 32.85977], [-117.24591, 32.85992], [-117.24578, 32.86005], [-117.24495, 32.86044], [-117.24472, 32.86048], [-117.24414, 32.86051], [-117.24598, 32.85902]]], [[[-117.25853, 32.81943], [-117.25847, 32.81962], [-117.25844, 32.81989], [-117.25701, 32.82021], [-117.25684, 32.8197], [-117.25762, 32.81909], [-117.25817, 32.8182], [-117.25853, 32.81943]]]]} | Open Access 1 | La Jolla Open Space | 20766 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 13.053 | La Jolla OS | ||
5947 | 5947 | 5946 | {"type": "Polygon", "coordinates": [[[-117.05038, 32.79171], [-117.05017, 32.79182], [-117.0488, 32.79178], [-117.04777, 32.79195], [-117.04708, 32.79222], [-117.04699, 32.79228], [-117.04651, 32.7924], [-117.0466, 32.79269], [-117.04637, 32.79272], [-117.04611, 32.79273], [-117.04536, 32.7927], [-117.04502, 32.79271], [-117.04466, 32.79274], [-117.04438, 32.7928], [-117.0443, 32.79249], [-117.04419, 32.78962], [-117.04434, 32.78864], [-117.04461, 32.78837], [-117.0449, 32.78852], [-117.0451, 32.78876], [-117.04518, 32.78916], [-117.04523, 32.78957], [-117.04521, 32.79026], [-117.04524, 32.7907], [-117.04557, 32.79198], [-117.04559, 32.79197], [-117.04598, 32.79081], [-117.04639, 32.78874], [-117.04647, 32.78865], [-117.04656, 32.78859], [-117.04674, 32.7886], [-117.04693, 32.7887], [-117.04737, 32.78925], [-117.04752, 32.78949], [-117.04786, 32.79013], [-117.0481, 32.79037], [-117.04885, 32.79092], [-117.04916, 32.79092], [-117.04839, 32.79032], [-117.04833, 32.78997], [-117.04835, 32.78961], [-117.0486, 32.7894], [-117.04902, 32.78928], [-117.04976, 32.78931], [-117.05038, 32.79171]]]} | Open Access 1 | Lake Murray Community Park | 20956 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 40.328 | Lake Murray Community Park | ||
6213 | 6213 | 6212 | {"type": "MultiPolygon", "coordinates": [[[[-117.17164, 32.79104], [-117.17165, 32.7911], [-117.17163, 32.79282], [-117.17083, 32.79297], [-117.17083, 32.79299], [-117.17093, 32.79299], [-117.17066, 32.79324], [-117.17042, 32.79353], [-117.17035, 32.79357], [-117.16922, 32.79302], [-117.16932, 32.79301], [-117.1693, 32.79278], [-117.16938, 32.79288], [-117.16944, 32.79292], [-117.16949, 32.79293], [-117.1695, 32.79292], [-117.1695, 32.79287], [-117.16944, 32.79285], [-117.16941, 32.7928], [-117.16939, 32.79272], [-117.16943, 32.79264], [-117.1695, 32.79257], [-117.16951, 32.79248], [-117.16942, 32.79247], [-117.16935, 32.79243], [-117.16906, 32.79211], [-117.16907, 32.79205], [-117.1692, 32.79189], [-117.16925, 32.7918], [-117.16929, 32.79171], [-117.16932, 32.79156], [-117.16932, 32.79113], [-117.17015, 32.79112], [-117.17123, 32.79093], [-117.17141, 32.79092], [-117.17151, 32.79093], [-117.17157, 32.79097], [-117.17164, 32.79104]]], [[[-117.17162, 32.79299], [-117.1716, 32.79491], [-117.17139, 32.79491], [-117.17127, 32.79463], [-117.17107, 32.7943], [-117.17079, 32.79393], [-117.17057, 32.79373], [-117.17056, 32.79368], [-117.17074, 32.7934], [-117.17097, 32.7932], [-117.17109, 32.79311], [-117.17138, 32.79299], [-117.17162, 32.79299]]], [[[-117.18401, 32.78929], [-117.184, 32.7931], [-117.18354, 32.79266], [-117.18245, 32.79293], [-117.18217, 32.79321], [-117.18055, 32.79388], [-117.18006, 32.79373], [-117.17921, 32.79329], [-117.17872, 32.79299], [-117.17857, 32.7927], [-117.17857, 32.79249], [-117.18003, 32.79249], [-117.18059, 32.79243], [-117.1809, 32.79236], [-117.18111, 32.79227], [-117.18146, 32.79209], [-117.18178, 32.79184], [-117.18247, 32.79112], [-117.18271, 32.79068], [-117.1829, 32.79041], [-117.18293, 32.79019], [-117.18287, 32.78998], [-117.18265, 32.78971], [-117.18244, 32.78956], [-117.18221, 32.78948], [-117.18221, 32.78931], [-117.18401, 32.78929]]]]} | Open Access 1 | Linda Vista Community Park | 21282 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 41.259 | Linda Vista Community Park | ||
6243 | 6243 | 6242 | {"type": "Polygon", "coordinates": [[[-117.13531, 32.80963], [-117.13296, 32.80967], [-117.13295, 32.80886], [-117.13279, 32.80885], [-117.13274, 32.80882], [-117.13263, 32.8087], [-117.13257, 32.80854], [-117.13257, 32.80843], [-117.13265, 32.80792], [-117.13264, 32.80786], [-117.1326, 32.8078], [-117.13254, 32.80778], [-117.13225, 32.80775], [-117.13215, 32.80763], [-117.13295, 32.80762], [-117.13297, 32.80837], [-117.13529, 32.80833], [-117.13531, 32.80963]]]} | No Public Access 3 | City of San Diego Open Space | 32304 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 9.043 | City of San Diego OS | ||
6603 | 6603 | 6602 | {"type": "MultiPolygon", "coordinates": [[[[-116.99614, 32.55382], [-116.99272, 32.55373], [-116.9927, 32.55115], [-116.99317, 32.55135], [-116.99337, 32.55162], [-116.99346, 32.55187], [-116.99337, 32.55212], [-116.99284, 32.55268], [-116.99288, 32.55314], [-116.993, 32.55322], [-116.99356, 32.55323], [-116.99449, 32.55257], [-116.99481, 32.55243], [-116.99513, 32.55248], [-116.99536, 32.55264], [-116.99588, 32.55353], [-116.99614, 32.55382]]], [[[-116.99975, 32.55984], [-116.99974, 32.56101], [-116.9991, 32.561], [-116.99909, 32.56041], [-116.99846, 32.56039], [-116.99846, 32.55982], [-116.9991, 32.55982], [-116.99911, 32.55925], [-116.99975, 32.55927], [-116.99975, 32.55984]]], [[[-117.0072, 32.58335], [-117.00152, 32.58305], [-117.00113, 32.58209], [-117.00111, 32.58168], [-117.00104, 32.58123], [-117.00082, 32.58039], [-117.00078, 32.58018], [-117.00063, 32.57963], [-117.00064, 32.5796], [-117.00069, 32.57957], [-117.00099, 32.57955], [-117.00123, 32.57957], [-117.00146, 32.57962], [-117.00175, 32.57971], [-117.00249, 32.58005], [-117.00282, 32.58016], [-117.0028, 32.58045], [-117.00282, 32.58056], [-117.00279, 32.58072], [-117.00256, 32.58103], [-117.00259, 32.58116], [-117.00277, 32.58158], [-117.003, 32.58199], [-117.00306, 32.58232], [-117.00312, 32.58247], [-117.00322, 32.5829], [-117.00351, 32.58313], [-117.00379, 32.58303], [-117.00401, 32.58283], [-117.00406, 32.58272], [-117.00457, 32.58226], [-117.0046, 32.58233], [-117.00507, 32.5824], [-117.0055, 32.58251], [-117.00631, 32.58265], [-117.00641, 32.58272], [-117.00678, 32.5828], [-117.00708, 32.58309], [-117.00713, 32.58329], [-117.0072, 32.58335]]], [[[-117.01488, 32.5586], [-117.01422, 32.55859], [-117.01422, 32.55805], [-117.01487, 32.55806], [-117.01488, 32.5586]]], [[[-117.01697, 32.55863], [-117.01632, 32.55862], [-117.01631, 32.55809], [-117.01566, 32.55807], [-117.01566, 32.55753], [-117.01631, 32.55753], [-117.01632, 32.55647], [-117.01697, 32.55648], [-117.01697, 32.55863]]], [[[-117.01697, 32.55486], [-117.01631, 32.55485], [-117.01631, 32.55431], [-117.01697, 32.55433], [-117.01697, 32.55486]]], [[[-117.01842, 32.55758], [-117.0171, 32.55756], [-117.0171, 32.55648], [-117.01841, 32.5565], [-117.01842, 32.55758]]], [[[-117.01841, 32.55812], [-117.01841, 32.55865], [-117.0171, 32.55863], [-117.0171, 32.55809], [-117.01841, 32.55812]]], [[[-117.01841, 32.55542], [-117.01776, 32.55541], [-117.01776, 32.55488], [-117.01841, 32.55489], [-117.01841, 32.55542]]]]} | Open Access 1 | Otay Mesa Open Space | 23241 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 47.324 | Otay Mesa OS | ||
6604 | 6604 | 6603 | {"type": "Polygon", "coordinates": [[[-116.99908, 32.56479], [-116.99905, 32.56803], [-116.99907, 32.56804], [-116.99876, 32.56801], [-116.99722, 32.568], [-116.99712, 32.56796], [-116.99708, 32.56789], [-116.99699, 32.56788], [-116.99702, 32.56465], [-116.99704, 32.5646], [-116.99907, 32.56465], [-116.99908, 32.56479]]]} | Open Access 1 | Otay Mitigation Site | 23242 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 17.892 | Otay Mitigation Site | ||
6718 | 6718 | 6717 | {"type": "Polygon", "coordinates": [[[-117.1194, 32.69936], [-117.11924, 32.69936], [-117.11924, 32.699], [-117.1194, 32.699], [-117.1194, 32.69936]]]} | Open Access 1 | Martin Ave Mini-Park | 21902 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.148 | Martin Ave Mini-Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);