units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where MNG_AGENCY = 101 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 11
- Local Park 55
- Local Conservation Area 33
- Local Recreation Area 4
- Local Other or Unknown 4
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 103
MNG_AGENCY 1
- San Diego, County of · 103 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14809 | 14809 | 14808 | {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14028, 33.2546], [-117.14032, 33.2547], [-117.14037, 33.25475], [-117.14057, 33.25543], [-117.1406, 33.25571], [-117.14058, 33.2559], [-117.14028, 33.25665], [-117.14037, 33.25683], [-117.13807, 33.25672], [-117.13802, 33.25307], [-117.13827, 33.25307], [-117.13853, 33.25318], [-117.13868, 33.25322], [-117.13897, 33.25337], [-117.13918, 33.25314], [-117.13955, 33.25349], [-117.14011, 33.25382], [-117.14025, 33.25392], [-117.14035, 33.25403], [-117.14066, 33.25449]]]} | Restricted Access 2 | 45227 | Knollwood Preserve | 31493 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 20.712 | Knollwood Preserve | 0 | Local Conservation Area 4 | 2 | |
14716 | 14716 | 14715 | {"type": "Polygon", "coordinates": [[[-116.38556, 32.97589], [-116.38485, 32.97959], [-116.38064, 32.97968], [-116.37621, 32.97986], [-116.37679, 32.97617], [-116.3768, 32.9758], [-116.38134, 32.97552], [-116.38136, 32.97593], [-116.38556, 32.97589]]]} | Unknown Access 4 | 47814 | Unnamed site - San Diego, County of | 31715 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 87.174 | 0 | Local Other or Unknown 14 | 4 | ||
14638 | 14638 | 14637 | {"type": "Polygon", "coordinates": [[[-116.84781, 32.81671], [-116.84748, 32.81672], [-116.84777, 32.8198], [-116.84467, 32.81979], [-116.84438, 32.81976], [-116.84405, 32.81984], [-116.84368, 32.82], [-116.84367, 32.82002], [-116.84416, 32.82064], [-116.84341, 32.8209], [-116.84061, 32.82312], [-116.84059, 32.82714], [-116.83973, 32.82708], [-116.83905, 32.82696], [-116.83843, 32.82681], [-116.83748, 32.82646], [-116.83725, 32.82644], [-116.83711, 32.82646], [-116.83698, 32.82651], [-116.83686, 32.82658], [-116.83677, 32.82668], [-116.83669, 32.82685], [-116.83667, 32.82721], [-116.83661, 32.82732], [-116.83661, 32.82663], [-116.83504, 32.82663], [-116.83441, 32.82619], [-116.83421, 32.82601], [-116.83404, 32.82583], [-116.83249, 32.82342], [-116.83244, 32.82331], [-116.83263, 32.81992], [-116.83284, 32.81992], [-116.83334, 32.8206], [-116.83363, 32.82031], [-116.83325, 32.81993], [-116.83383, 32.81994], [-116.83503, 32.81942], [-116.83545, 32.81932], [-116.83687, 32.81933], [-116.83688, 32.81895], [-116.83764, 32.81876], [-116.83867, 32.81899], [-116.83951, 32.81796], [-116.83905, 32.81756], [-116.83911, 32.81748], [-116.83955, 32.81767], [-116.83971, 32.81649], [-116.83921, 32.81568], [-116.84772, 32.81572], [-116.84781, 32.81671]]]} | Open Access 1 | 44876 | Stoneridge Preserve | 25897 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/AboutUs/Plans/MSCP.html | San Diego 4 | 246.46 | Stoneridge Preserve | 0 | Local Conservation Area 4 | 2 |
14637 | 14637 | 14636 | {"type": "Polygon", "coordinates": [[[-116.90222, 32.84651], [-116.90218, 32.84649], [-116.90213, 32.84651], [-116.9021, 32.84659], [-116.90205, 32.84692], [-116.9019, 32.84712], [-116.89878, 32.84713], [-116.89877, 32.84549], [-116.89944, 32.84553], [-116.90108, 32.84593], [-116.90178, 32.84602], [-116.90196, 32.84615], [-116.9022, 32.84643], [-116.90222, 32.84651]]]} | Open Access 1 | 44871 | Lakeside Linkage Preserve | 20976 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LakesideLinkage.html | San Diego 4 | 11.424 | Lakeside Linkage Preserve | 0 | Local Conservation Area 4 | 2 |
14635 | 14635 | 14634 | {"type": "Polygon", "coordinates": [[[-117.10501, 33.01145], [-117.10485, 33.01158], [-117.10476, 33.01169], [-117.10473, 33.01183], [-117.10471, 33.01203], [-117.10476, 33.01243], [-117.10474, 33.01289], [-117.1046, 33.01309], [-117.1044, 33.01313], [-117.10431, 33.01325], [-117.1041, 33.01314], [-117.10388, 33.01304], [-117.10297, 33.01276], [-117.10268, 33.01265], [-117.10215, 33.01241], [-117.10125, 33.01195], [-117.09931, 33.01118], [-117.09888, 33.011], [-117.09844, 33.0108], [-117.09802, 33.01057], [-117.09748, 33.01024], [-117.09709, 33.00997], [-117.09672, 33.00969], [-117.0966, 33.00959], [-117.09698, 33.00811], [-117.1048, 33.00837], [-117.10477, 33.00869], [-117.10481, 33.00874], [-117.10454, 33.00943], [-117.10481, 33.00975], [-117.10482, 33.01], [-117.10492, 33.01018], [-117.10484, 33.01029], [-117.1048, 33.01076], [-117.1047, 33.01099], [-117.10468, 33.01115], [-117.10469, 33.01122], [-117.10471, 33.01127], [-117.10475, 33.01131], [-117.105, 33.01142], [-117.10501, 33.01145]], [[-117.10204, 33.01004], [-117.10213, 33.01005], [-117.10226, 33.01004], [-117.10237, 33.01001], [-117.10247, 33.00996], [-117.10255, 33.00989], [-117.10262, 33.0098], [-117.10265, 33.0097], [-117.10266, 33.0096], [-117.10261, 33.00944], [-117.10255, 33.00937], [-117.10247, 33.0093], [-117.10235, 33.00924], [-117.10222, 33.00922], [-117.10207, 33.00922], [-117.10198, 33.00925], [-117.10193, 33.00914], [-117.10174, 33.00924], [-117.10161, 33.00939], [-117.10154, 33.00955], [-117.10153, 33.0098], [-117.10156, 33.00992], [-117.10162, 33.01005], [-117.10168, 33.01013], [-117.10183, 33.01027], [-117.10191, 33.01037], [-117.10192, 33.01036], [-117.10204, 33.01004]]]} | Open Access 1 | 44867 | Christopher Hill Holding | 29230 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 69.353 | Christopher Hill Holding | None 1248 | |||
14610 | 14610 | 14609 | {"type": "MultiPolygon", "coordinates": [[[[-117.18723, 33.06546], [-117.18548, 33.06687], [-117.18548, 33.06687], [-117.1855, 33.06545], [-117.18723, 33.06546]]], [[[-117.19071, 33.0655], [-117.18965, 33.06846], [-117.18937, 33.06842], [-117.18924, 33.06843], [-117.18905, 33.06849], [-117.18895, 33.06856], [-117.18842, 33.06661], [-117.18836, 33.06649], [-117.18808, 33.06547], [-117.19071, 33.0655]]], [[[-117.18728, 33.0727], [-117.1848, 33.07266], [-117.18489, 33.07234], [-117.18501, 33.07155], [-117.18506, 33.0713], [-117.18494, 33.07096], [-117.18482, 33.07042], [-117.18453, 33.06973], [-117.18441, 33.06953], [-117.18417, 33.06924], [-117.18403, 33.06917], [-117.18387, 33.06916], [-117.18385, 33.0691], [-117.18541, 33.06911], [-117.18638, 33.06908], [-117.18726, 33.06908], [-117.18728, 33.0727]]], [[[-117.17423, 33.07671], [-117.17417, 33.0784], [-117.17415, 33.07845], [-117.17348, 33.07833], [-117.17312, 33.0783], [-117.17248, 33.07829], [-117.17227, 33.07826], [-117.17207, 33.0782], [-117.17154, 33.07797], [-117.17111, 33.07773], [-117.17073, 33.07743], [-117.16999, 33.07663], [-117.17001, 33.07636], [-117.17294, 33.07642], [-117.17294, 33.0767], [-117.17423, 33.07671]]], [[[-117.19572, 33.07672], [-117.1957, 33.0794], [-117.19324, 33.07923], [-117.19334, 33.07904], [-117.19314, 33.07854], [-117.19205, 33.07829], [-117.19191, 33.07822], [-117.19179, 33.07814], [-117.19161, 33.07794], [-117.19153, 33.07779], [-117.19149, 33.07761], [-117.19143, 33.0776], [-117.19146, 33.07717], [-117.19145, 33.07663], [-117.18855, 33.07658], [-117.18857, 33.07545], [-117.19146, 33.07551], [-117.19146, 33.07663], [-117.19572, 33.07672]]], [[[-117.17416, 33.07869], [-117.17408, 33.08036], [-117.16976, 33.08034], [-117.16984, 33.07885], [-117.16998, 33.07701], [-117.17052, 33.07759], [-117.17088, 33.07786], [-117.17113, 33.07803], [-117.1714, 33.07817], [-117.17195, 33.07841], [-117.17216, 33.07848], [-117.17237, 33.07851], [-117.17326, 33.07855], [-117.1736, 33.07859], [-117.17416, 33.07869]]], [[[-117.15319, 33.08571], [-117.15294, 33.08582], [-117.15251, 33.08596], [-117.15219, 33.08602], [-117.15183, 33.08606], [-117.15133, 33.08605], [-117.14956, 33.08587], [-117.14844, 33.0858], [-117.14823, 33.0858], [-117.14805, 33.08584], [-117.14803, 33.08027], [-117.15231, 33.08034], [-117.15223, 33.08571], [-117.15319, 33.08571]]], [[[-117.14475, 33.08745], [-117.1439, 33.08753], [-117.1439, 33.08753], [-117.1439, 33.08751], [-117.14394, 33.08751], [-117.14414, 33.08745], [-117.14475, 33.08745]]], [[[-117.15649, 33.08564], [-117.15649, 33.08741], [-117.15009, 33.08746], [-117.15012, 33.08937], [-117.14806, 33.0894], [-117.14808, 33.09109], [-117.1522, 33.09107], [-117.15221, 33.09471], [-117.1507, 33.09472], [-117.15069, 33.09473], [-117.1529, 33.09685], [-117.1533, 33.09789], [-117.15372, 33.09849], [-117.15353, 33.09873], [-117.15287, 33.09997], [-117.15245, 33.10051], [-117.15247, 33.10086], [-117.15329, 33.10166], [-117.15378, 33.10215], [-117.15386, 33.10237], [-117.15388, 33.10252], [-117.15386, 33.10266], [-117.15379, 33.10284], [-117.15365, 33.10304], [-117.15361, 33.10318], [-117.15363, 33.10332], [-117.15381, 33.10356], [-117.15382, 33.10365], [-117.15376, 33.10382], [-117.15357, 33.10398], [-117.15352, 33.10411], [-117.15351, 33.10421], [-117.15356, 33.10433], [-117.1537, 33.10449], [-117.15383, 33.10459], [-117.15398, 33.10468], [-117.15435, 33.10482], [-117.15455, 33.10504], [-117.15475, 33.10519], [-117.15482, 33.1053], [-117.15484, 33.10539], [-117.15488, 33.10548], [-117.15495, 33.10555], [-117.15522, 33.10568], [-117.15528, 33.10574], [-117.15536, 33.10597], [-117.15542, 33.10607], [-117.15567, 33.10631], [-117.15573, 33.10641], [-117.1558, 33.10661], [-117.15591, 33.10672], [-117.156, 33.10677], [-117.15617, 33.10681], [-117.15621, 33.10686], [-117.15622, 33.10691], [-117.1562, 33.10696], [-117.15615, 33.10699], [-117.15615, 33.10711], [-117.15609, 33.10712], [-117.15602, 33.10951], [-117.15534, 33.10922], [-117.15424, 33.10859], [-117.15415, 33.1086], [-117.15418, 33.10894], [-117.15418, 33.11015], [-117.15412, 33.11003], [-117.15402, 33.10997], [-117.15375, 33.1091], [-117.15355, 33.10862], [-117.1534, 33.10836], [-117.15337, 33.10821], [-117.1534, 33.10809], [-117.15344, 33.10805], [-117.15356, 33.10797], [-117.15383, 33.10784], [-117.15404, 33.10777], [-117.15451, 33.10766], [-117.15487, 33.10749], [-117.15514, 33.10743], [-117.15544, 33.10728], [-117.15566, 33.10722], [-117.15596, 33.10708], [-117.15596, 33.10706], [-117.15425, 33.10641], [-117.15282, 33.10651], [-117.15056, 33.10608], [-117.14915, 33.10526], [-117.14816, 33.10531], [-117.14802, 33.09843], [-117.13961, 33.09842], [-117.13962, 33.09474], [-117.14391, 33.09473], [-117.14393, 33.09378], [-117.1439, 33.09109], [-117.1396, 33.09109], [-117.13961, 33.09282], [-117.13652, 33.09281], [-117.13649, 33.0927], [-117.13649, 33.09251], [-117.13651, 33.0923], [-117.13645, 33.09202], [-117.13643, 33.09161], [-117.13651, 33.09136], [-117.13665, 33.0911], [-117.13685, 33.09077], [-117.13738, 33.09003], [-117.13755, 33.08972], [-117.13766, 33.08945], [-117.13778, 33.08925], [-117.13793, 33.08906], [-117.13802, 33.08897], [-117.13817, 33.08887], [-117.13835, 33.08879], [-117.13851, 33.08877], [-117.1387, 33.08878], [-117.13924, 33.08898], [-117.13943, 33.08902], [-117.13959, 33.08903], [-117.1396, 33.08909], [-117.14002, 33.08903], [-117.1404, 33.08901], [-117.14066, 33.08897], [-117.14123, 33.08882], [-117.14372, 33.08787], [-117.14407, 33.08772], [-117.14433, 33.08764], [-117.14518, 33.08757], [-117.14537, 33.08753], [-117.14561, 33.08744], [-117.148, 33.08744], [-117.14801, 33.08748], [-117.14803, 33.08747], [-117.14806, 33.08608], [-117.14818, 33.08605], [-117.1483, 33.08603], [-117.14876, 33.08605], [-117.14953, 33.08611], [-117.1514, 33.0863], [-117.15187, 33.08631], [-117.15239, 33.08624], [-117.15292, 33.0861], [-117.15339, 33.08588], [-117.15366, 33.0857], [-117.15649, 33.08564]]]]} | No Public Access 3 | 44822 | Escondido Creek Preserve | 29232 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 625.018 | Escondido Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
14608 | 14608 | 14607 | {"type": "MultiPolygon", "coordinates": [[[[-117.14468, 32.93894], [-117.14052, 32.93899], [-117.14057, 32.93988], [-117.13978, 32.93993], [-117.13697, 32.94021], [-117.13424, 32.94028], [-117.13399, 32.94024], [-117.13382, 32.94026], [-117.13366, 32.94039], [-117.13345, 32.94061], [-117.13322, 32.94079], [-117.13311, 32.94085], [-117.13284, 32.94094], [-117.13257, 32.94096], [-117.13182, 32.9409], [-117.131, 32.9409], [-117.13065, 32.94087], [-117.13032, 32.94074], [-117.13004, 32.94058], [-117.12976, 32.9405], [-117.12959, 32.94047], [-117.12929, 32.94047], [-117.12927, 32.94039], [-117.12922, 32.94039], [-117.12887, 32.93931], [-117.12873, 32.93902], [-117.12858, 32.93879], [-117.12808, 32.93813], [-117.12695, 32.93676], [-117.12904, 32.93619], [-117.12976, 32.93634], [-117.13003, 32.93637], [-117.13116, 32.93622], [-117.13225, 32.93618], [-117.13369, 32.93583], [-117.13409, 32.93549], [-117.13406, 32.93501], [-117.13567, 32.93494], [-117.13568, 32.93482], [-117.13675, 32.93478], [-117.13631, 32.93532], [-117.13604, 32.9357], [-117.13604, 32.93572], [-117.13916, 32.93565], [-117.13942, 32.93485], [-117.14136, 32.93576], [-117.14268, 32.93569], [-117.14408, 32.93456], [-117.14434, 32.93456], [-117.14467, 32.93605], [-117.14468, 32.93894]]], [[[-117.16982, 32.94862], [-117.16683, 32.94859], [-117.16682, 32.94854], [-117.16512, 32.94853], [-117.1651, 32.94814], [-117.1651, 32.94682], [-117.16714, 32.94686], [-117.16715, 32.94642], [-117.16771, 32.94614], [-117.16748, 32.94568], [-117.16713, 32.94559], [-117.16713, 32.94514], [-117.16961, 32.94511], [-117.16982, 32.94862]]], [[[-117.20536, 32.90698], [-117.20535, 32.90716], [-117.20503, 32.90727], [-117.20468, 32.90741], [-117.20434, 32.90758], [-117.20409, 32.90773], [-117.20365, 32.90805], [-117.20281, 32.9088], [-117.20259, 32.90878], [-117.20241, 32.90878], [-117.20204, 32.90881], [-117.20188, 32.90885], [-117.2017, 32.90891], [-117.20152, 32.90899], [-117.20141, 32.90907], [-117.20137, 32.90907], [-117.20022, 32.9076], [-117.20351, 32.90659], [-117.20536, 32.90698]]], [[[-117.21151, 32.90728], [-117.21058, 32.90768], [-117.20851, 32.90765], [-117.20853, 32.90715], [-117.20941, 32.90736], [-117.2101, 32.90743], [-117.21034, 32.90744], [-117.21078, 32.90741], [-117.21102, 32.90738], [-117.21151, 32.90728]]], [[[-117.21354, 32.90559], [-117.21337, 32.90582], [-117.21319, 32.90601], [-117.21282, 32.90632], [-117.21267, 32.90643], [-117.21224, 32.9067], [-117.21204, 32.90679], [-117.21184, 32.90688], [-117.21139, 32.90702], [-117.2109, 32.90712], [-117.21041, 32.90716], [-117.21014, 32.90717], [-117.20989, 32.90715], [-117.20934, 32.90707], [-117.20855, 32.90687], [-117.2086, 32.90558], [-117.21354, 32.90559]]], [[[-117.21547, 32.9056], [-117.2135, 32.90694], [-117.21235, 32.90695], [-117.21262, 32.90681], [-117.21289, 32.90664], [-117.21336, 32.90626], [-117.21351, 32.90611], [-117.21364, 32.90594], [-117.21378, 32.90576], [-117.21389, 32.90559], [-117.21547, 32.9056]]]]} | Open Access 1 | 44831 | Los Penasquitos Canyon Preserve | 21528 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LosPenasquitos.html | San Diego 4 | 255.079 | Los Penasquitos Canyon Preserve | 0 | Local Conservation Area 4 | 2 |
14553 | 14553 | 14552 | {"type": "Polygon", "coordinates": [[[-117.142, 33.36266], [-117.14183, 33.36576], [-117.13969, 33.36579], [-117.13986, 33.36259], [-117.142, 33.36266]]]} | No Public Access 3 | 45226 | Pala Mesa Mitigation Property | 29252 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 17.191 | Pala Mesa Mitigation Property | 0 | Local Other or Unknown 14 | 4 | |
13225 | 13225 | 13224 | {"type": "Polygon", "coordinates": [[[-117.12022, 33.25594], [-117.11798, 33.25608], [-117.11133, 33.25648], [-117.11148, 33.25634], [-117.11161, 33.25629], [-117.11177, 33.25622], [-117.11191, 33.25612], [-117.11201, 33.25602], [-117.11211, 33.256], [-117.11224, 33.25577], [-117.11221, 33.25567], [-117.11279, 33.25455], [-117.11293, 33.25435], [-117.11314, 33.25414], [-117.11321, 33.25417], [-117.11343, 33.25402], [-117.11339, 33.25397], [-117.11357, 33.25388], [-117.11582, 33.25311], [-117.1161, 33.25299], [-117.11637, 33.25284], [-117.12005, 33.2528], [-117.12022, 33.25594]]]} | No Public Access 3 | 45242 | Old Castle Mitigation Area | 23082 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 58.565 | Old Castle Mitigation Area | 0 | Local Other or Unknown 14 | 4 | |
13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
13205 | 13205 | 13204 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | 45236 | Otay Ranch Preserve | 10734 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/pds/mscp/or.html | San Diego 4 | 368.875 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
12345 | 12345 | 12344 | {"type": "MultiPolygon", "coordinates": [[[[-116.36349, 32.9753], [-116.36347, 32.97586], [-116.34903, 32.97614], [-116.34864, 32.97612], [-116.34825, 32.97607], [-116.34782, 32.976], [-116.34743, 32.97589], [-116.34678, 32.97561], [-116.34632, 32.97535], [-116.34609, 32.97521], [-116.34606, 32.97518], [-116.3474, 32.97517], [-116.35338, 32.97521], [-116.36349, 32.9753]]], [[[-116.36369, 32.97613], [-116.36368, 32.97685], [-116.3475, 32.97688], [-116.34745, 32.97619], [-116.34765, 32.97624], [-116.34809, 32.97633], [-116.34847, 32.97638], [-116.34903, 32.97642], [-116.34934, 32.97642], [-116.36369, 32.97613]]]]} | Open Access 1 | 26037 | Vallecito County Park | 29260 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Vallecito.html | San Diego 4 | 57.618 | Vallecito County Park | 0 | Local Park 2 | 4 |
12242 | 12242 | 12241 | {"type": "MultiPolygon", "coordinates": [[[[-117.18634, 33.08768], [-117.18422, 33.08768], [-117.18424, 33.08862], [-117.1842, 33.09134], [-117.18211, 33.09133], [-117.18197, 33.09493], [-117.17742, 33.09493], [-117.17755, 33.08762], [-117.17527, 33.08759], [-117.17541, 33.08587], [-117.17429, 33.08585], [-117.17445, 33.08402], [-117.17778, 33.08404], [-117.17803, 33.08039], [-117.17905, 33.08039], [-117.18143, 33.08206], [-117.18122, 33.08316], [-117.17997, 33.08494], [-117.1802, 33.08476], [-117.18126, 33.08458], [-117.18138, 33.08479], [-117.18209, 33.08429], [-117.1826, 33.08426], [-117.1827, 33.08451], [-117.18264, 33.08506], [-117.18284, 33.08558], [-117.18309, 33.08538], [-117.18327, 33.08488], [-117.18313, 33.08447], [-117.18316, 33.08417], [-117.18324, 33.08408], [-117.18445, 33.08407], [-117.18504, 33.08445], [-117.18538, 33.08469], [-117.18565, 33.08491], [-117.18581, 33.08507], [-117.18633, 33.08568], [-117.18634, 33.08768]]], [[[-117.18635, 33.08529], [-117.186, 33.08489], [-117.18581, 33.08472], [-117.18524, 33.08429], [-117.18491, 33.08407], [-117.18633, 33.08407], [-117.18635, 33.08529]]]]} | No Public Access 3 | 25447 | Sage Hill Preserve | 29254 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 231.523 | Sage Hill Preserve | 0 | Local Conservation Area 4 | 2 | |
12137 | 12137 | 12136 | {"type": "Polygon", "coordinates": [[[-116.86437, 32.84792], [-116.86395, 32.84801], [-116.86323, 32.84819], [-116.86121, 32.84874], [-116.86081, 32.84886], [-116.86032, 32.84905], [-116.85989, 32.84924], [-116.85946, 32.84947], [-116.85905, 32.84973], [-116.85909, 32.84962], [-116.85783, 32.84867], [-116.85712, 32.84965], [-116.85469, 32.84965], [-116.85468, 32.8487], [-116.85753, 32.84505], [-116.86185, 32.84502], [-116.86186, 32.84501], [-116.86171, 32.84478], [-116.8618, 32.84476], [-116.86312, 32.84505], [-116.86228, 32.84564], [-116.86362, 32.84766], [-116.86437, 32.84792]]]} | Open Access 1 | 25128 | Flinn Springs County Park | 18950 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/FlinnSprings.html | San Diego 4 | 75.51 | Flinn Springs County Park | 0 | Local Park 2 | 4 |
10581 | 10581 | 10580 | {"type": "Polygon", "coordinates": [[[-116.94463, 32.99593], [-116.94441, 32.9987], [-116.94439, 32.99875], [-116.94439, 32.99899], [-116.94433, 32.9996], [-116.94028, 32.99968], [-116.93617, 32.99969], [-116.93612, 32.99608], [-116.94463, 32.99593]]]} | Open Access 1 | 18841 | Dos Picos Park | 18228 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DosPicos.html | San Diego 4 | 78.103 | Dos Picos Park | 0 | Local Park 2 | 4 |
10580 | 10580 | 10579 | {"type": "Polygon", "coordinates": [[[-116.89819, 33.00447], [-116.89812, 33.00591], [-116.89808, 33.00592], [-116.89806, 33.00839], [-116.89415, 33.00837], [-116.89413, 33.00834], [-116.89413, 33.00753], [-116.89415, 33.00738], [-116.89421, 33.00721], [-116.89429, 33.00705], [-116.89438, 33.00694], [-116.89496, 33.00628], [-116.89507, 33.00608], [-116.89514, 33.00587], [-116.89517, 33.00567], [-116.89515, 33.00543], [-116.89485, 33.00439], [-116.89483, 33.00409], [-116.89486, 33.00391], [-116.89492, 33.00374], [-116.89506, 33.00354], [-116.89514, 33.00344], [-116.89537, 33.00323], [-116.89696, 33.00352], [-116.89715, 33.00378], [-116.89768, 33.00373], [-116.89776, 33.00446], [-116.89819, 33.00447]]]} | Open Access 1 | 18839 | Holly Oaks Park | 20043 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/HollyOaks.html | San Diego 4 | 41.639 | Holly Oaks Park | 0 | Local Park 2 | 4 |
10540 | 10540 | 10539 | {"type": "MultiPolygon", "coordinates": [[[[-117.28114, 33.24587], [-117.27999, 33.24648], [-117.27883, 33.24704], [-117.27844, 33.24717], [-117.27838, 33.24725], [-117.27771, 33.24745], [-117.27761, 33.24739], [-117.27442, 33.24794], [-117.27425, 33.24786], [-117.27408, 33.24798], [-117.26954, 33.24542], [-117.26942, 33.24486], [-117.26917, 33.24468], [-117.26871, 33.24458], [-117.26838, 33.24438], [-117.26735, 33.2444], [-117.26689, 33.24414], [-117.26694, 33.24409], [-117.26694, 33.24408], [-117.26645, 33.24381], [-117.26633, 33.24367], [-117.26618, 33.24356], [-117.26492, 33.24287], [-117.26477, 33.24282], [-117.26461, 33.2428], [-117.2604, 33.24049], [-117.26279, 33.23744], [-117.26095, 33.23645], [-117.26139, 33.23589], [-117.2617, 33.23593], [-117.26219, 33.23606], [-117.26365, 33.23667], [-117.26381, 33.23676], [-117.26399, 33.2369], [-117.26483, 33.23772], [-117.26451, 33.23866], [-117.26492, 33.24094], [-117.2679, 33.24199], [-117.27121, 33.24204], [-117.27195, 33.24009], [-117.27198, 33.2401], [-117.27215, 33.24016], [-117.27244, 33.24033], [-117.27245, 33.24027], [-117.27461, 33.24129], [-117.27559, 33.24173], [-117.27764, 33.2426], [-117.27809, 33.24285], [-117.27835, 33.24303], [-117.27858, 33.24322], [-117.28102, 33.24561], [-117.28111, 33.24573], [-117.28114, 33.24587]]], [[[-117.26948, 33.24546], [-117.26942, 33.24554], [-117.26756, 33.24451], [-117.26834, 33.24449], [-117.26866, 33.24467], [-117.2691, 33.24478], [-117.26929, 33.24492], [-117.26941, 33.24544], [-117.26948, 33.24546]]], [[[-117.27395, 33.24807], [-117.27379, 33.24819], [-117.27228, 33.24873], [-117.27202, 33.24821], [-117.27134, 33.24784], [-117.27202, 33.24698], [-117.27395, 33.24807]]], [[[-117.29046, 33.25156], [-117.28943, 33.25295], [-117.28119, 33.24865], [-117.27759, 33.25321], [-117.27759, 33.25323], [-117.27813, 33.25354], [-117.27522, 33.25726], [-117.2719, 33.25544], [-117.27381, 33.25404], [-117.27556, 33.25218], [-117.27848, 33.25062], [-117.27889, 33.25023], [-117.27889, 33.24929], [-117.27884, 33.24886], [-117.27846, 33.24877], [-117.2784, 33.24775], [-117.27907, 33.24748], [-117.27963, 33.24723], [-117.28142, 33.24634], [-117.28154, 33.24631], [-117.28164, 33.24633], [-117.28174, 33.24652], [-117.28199, 33.24684], [-117.28207, 33.24682], [-117.28274, 33.24639], [-117.28388, 33.24579], [-117.28413, 33.24577], [-117.2844, 33.24588], [-117.28537, 33.24634], [-117.28704, 33.24588], [-117.28887, 33.24809], [-117.29046, 33.25156]]]]} | Open Access 1 | 18746 | Guajome Regional Park | 10695 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Guajome.html | San Diego 4 | 385.428 | Guajome RP | 0 | Local Park 2 | 4 |
7963 | 7963 | 7962 | {"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]} | Restricted Access 2 | 47729 | Otay Ranch Preserve | 31529 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 179.037 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
7864 | 7864 | 7863 | {"type": "MultiPolygon", "coordinates": [[[[-116.92777, 32.58949], [-116.92777, 32.59228], [-116.92719, 32.59236], [-116.92709, 32.59253], [-116.92678, 32.59284], [-116.92635, 32.59308], [-116.92611, 32.59314], [-116.92622, 32.59232], [-116.92562, 32.59183], [-116.92563, 32.5918], [-116.92293, 32.5893], [-116.92211, 32.58875], [-116.92204, 32.58879], [-116.92131, 32.58828], [-116.91987, 32.58695], [-116.91737, 32.58824], [-116.91724, 32.58868], [-116.91579, 32.58965], [-116.91571, 32.59019], [-116.91743, 32.59146], [-116.92026, 32.59141], [-116.92062, 32.59165], [-116.92179, 32.59313], [-116.92285, 32.59318], [-116.92318, 32.59348], [-116.92371, 32.5935], [-116.92369, 32.59353], [-116.92526, 32.595], [-116.92514, 32.59515], [-116.92556, 32.59554], [-116.92582, 32.59535], [-116.92587, 32.59561], [-116.92593, 32.59573], [-116.92601, 32.59583], [-116.92635, 32.59609], [-116.9266, 32.5963], [-116.92681, 32.59658], [-116.92695, 32.59689], [-116.91079, 32.59702], [-116.9107, 32.59326], [-116.9129, 32.59324], [-116.91243, 32.59374], [-116.91342, 32.59443], [-116.91457, 32.59326], [-116.91516, 32.59328], [-116.91548, 32.5923], [-116.91619, 32.5921], [-116.91584, 32.59121], [-116.91508, 32.59097], [-116.91467, 32.59137], [-116.9128, 32.59139], [-116.91275, 32.58957], [-116.91061, 32.58958], [-116.91052, 32.58587], [-116.91906, 32.5858], [-116.92128, 32.5858], [-116.92129, 32.58715], [-116.92666, 32.58812], [-116.92777, 32.58949]]], [[[-116.92994, 32.59688], [-116.92778, 32.59688], [-116.92778, 32.59585], [-116.92807, 32.5955], [-116.92806, 32.59492], [-116.92993, 32.59491], [-116.92994, 32.59688]]], [[[-116.98385, 32.58252], [-116.97937, 32.58383], [-116.97937, 32.58383], [-116.97936, 32.5825], [-116.98385, 32.58252]]]]} | No Public Access 3 | 47717 | Otay Valley Regional Park | 31497 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.ovrp.org/ | San Diego 4 | 324.329 | Otay Valley RP | 0 | Local Park 2 | 4 |
7639 | 7639 | 7638 | {"type": "Polygon", "coordinates": [[[-117.00829, 32.70669], [-117.0079, 32.70718], [-117.00761, 32.70736], [-117.00724, 32.70753], [-117.00689, 32.70763], [-117.00659, 32.70769], [-117.00625, 32.70771], [-117.00624, 32.70751], [-117.00631, 32.7075], [-117.00635, 32.70656], [-117.00628, 32.70655], [-117.00628, 32.70648], [-117.00686, 32.70579], [-117.00829, 32.70669]]]} | Open Access 1 | 7387 | Spring Valley County Park | 29257 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SpringValley.html | San Diego 4 | 6.121 | Spring Valley County 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]);