superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
120 rows where MNG_AGENCY = 101 and MNG_AG_TYP = 3 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13829 | 13829 | 13828 | {"type": "Polygon", "coordinates": [[[-117.28327, 33.05261], [-117.28325, 33.0544], [-117.28105, 33.05439], [-117.27903, 33.05436], [-117.27912, 33.0521], [-117.27921, 33.0508], [-117.28122, 33.05083], [-117.28115, 33.05261], [-117.28327, 33.05261]]]} | Open Access 1 | San Diego Botanic Garden | http://www.sdbgarden.org/ | 31367 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 28.401 | San Diego Botanic Garden | |
6527 | 6527 | 6526 | {"type": "Polygon", "coordinates": [[[-117.2805, 33.06873], [-117.28049, 33.07082], [-117.2805, 33.07144], [-117.27943, 33.07144], [-117.27942, 33.07234], [-117.27801, 33.07234], [-117.27791, 33.07143], [-117.27683, 33.07143], [-117.27656, 33.06872], [-117.2805, 33.06873]]]} | Open Access 1 | Magdalena Ecke Park | 21667 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 29.798 | Magdalena Ecke Park | ||
12271 | 12271 | 12270 | {"type": "Polygon", "coordinates": [[[-117.26172, 33.23522], [-117.26167, 33.23532], [-117.26162, 33.23567], [-117.26158, 33.23571], [-117.26152, 33.23572], [-117.25839, 33.23528], [-117.25808, 33.23522], [-117.2578, 33.23515], [-117.25759, 33.23507], [-117.25758, 33.23505], [-117.25634, 33.23461], [-117.25603, 33.23452], [-117.25573, 33.23445], [-117.25539, 33.23441], [-117.25511, 33.23439], [-117.25261, 33.23448], [-117.25203, 33.23441], [-117.25168, 33.23433], [-117.25138, 33.23423], [-117.25104, 33.23407], [-117.25088, 33.23397], [-117.25053, 33.23371], [-117.25031, 33.23348], [-117.25004, 33.2331], [-117.24996, 33.23293], [-117.24984, 33.23254], [-117.24915, 33.23077], [-117.25154, 33.23012], [-117.25191, 33.227], [-117.25547, 33.22704], [-117.25598, 33.22639], [-117.25833, 33.22825], [-117.25858, 33.22889], [-117.25793, 33.23418], [-117.25992, 33.23456], [-117.26001, 33.23465], [-117.26012, 33.23471], [-117.26172, 33.23522]]]} | Open Access 1 | Rancho Guajome Adobe County Park | http://www.sdparks.org/content/sdparks/en/park-pages/RanchoGuajomeAdobe.html | 29264 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 150.974 | Rancho Guajome Adobe County Park | |
3652 | 3652 | 3651 | {"type": "Polygon", "coordinates": [[[-117.25791, 33.37491], [-117.25791, 33.37556], [-117.25754, 33.37556], [-117.25754, 33.3752], [-117.25724, 33.37489], [-117.25791, 33.37491]]]} | Open Access 1 | Don Dussault Park | http://www.sdparks.org/content/sdparks/en/park-pages/DonDussault.html | 18203 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 0.746 | Don Dussault Park | |
9323 | 9323 | 9322 | {"type": "Polygon", "coordinates": [[[-117.25752, 33.40873], [-117.25323, 33.40878], [-117.25324, 33.41265], [-117.24915, 33.41271], [-117.24922, 33.40887], [-117.24931, 33.40872], [-117.24939, 33.40856], [-117.24945, 33.40837], [-117.24947, 33.40824], [-117.24939, 33.40734], [-117.24924, 33.40619], [-117.24924, 33.4061], [-117.24935, 33.40529], [-117.24926, 33.40393], [-117.24924, 33.40289], [-117.24928, 33.40267], [-117.24932, 33.40252], [-117.24946, 33.40219], [-117.24965, 33.40189], [-117.25008, 33.4014], [-117.25014, 33.40129], [-117.2503, 33.40084], [-117.2503, 33.40072], [-117.25027, 33.40062], [-117.25028, 33.4006], [-117.25016, 33.40033], [-117.25013, 33.4002], [-117.25023, 33.39961], [-117.25023, 33.39948], [-117.25019, 33.39938], [-117.25013, 33.39929], [-117.24996, 33.39916], [-117.25255, 33.39932], [-117.25255, 33.39925], [-117.25239, 33.39903], [-117.25238, 33.39893], [-117.25242, 33.39881], [-117.25252, 33.3987], [-117.25256, 33.39862], [-117.25258, 33.39847], [-117.25682, 33.39851], [-117.25613, 33.40205], [-117.25582, 33.40207], [-117.25572, 33.40275], [-117.25524, 33.40649], [-117.2575, 33.40647], [-117.25752, 33.40873]]]} | Open Access 1 | Santa Margarita Preserve | http://www.sdparks.org/content/sdparks/en/park-pages/SantaMargarita.html | 25099 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 211.289 | Santa Margarita Preserve | |
11733 | 11733 | 11732 | {"type": "Polygon", "coordinates": [[[-117.25461, 33.36874], [-117.2546, 33.3693], [-117.25423, 33.3693], [-117.25423, 33.36873], [-117.25461, 33.36874]]]} | Open Access 1 | Clemmens Lane County Park | http://www.sdparks.org/content/sdparks/en/park-pages/Clemmens.html | 28337 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 0.543 | Clemmens Lane County Park | 2009 |
12187 | 12187 | 12186 | {"type": "Polygon", "coordinates": [[[-117.22985, 33.12069], [-117.22559, 33.1207], [-117.22559, 33.12034], [-117.22632, 33.12033], [-117.2275, 33.11994], [-117.22846, 33.11977], [-117.22826, 33.11882], [-117.22822, 33.1187], [-117.22769, 33.11842], [-117.22665, 33.11804], [-117.22645, 33.11788], [-117.2261, 33.1179], [-117.22608, 33.1176], [-117.22604, 33.11748], [-117.22594, 33.11732], [-117.22574, 33.11714], [-117.22573, 33.11712], [-117.22574, 33.11708], [-117.22579, 33.11704], [-117.22666, 33.11703], [-117.22669, 33.11773], [-117.22982, 33.11772], [-117.22985, 33.12069]]]} | No Public Access 3 | Diamond Trail | http://www.sandiegocounty.gov/content/dam/sdc/dpw/WATERSHED_PROTECTION_PROGRAM/Pacific%20Watersheds.pdf | 29166 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 19.766 | Diamond Trail | |
10600 | 10600 | 10599 | {"type": "Polygon", "coordinates": [[[-117.22664, 33.05068], [-117.22596, 33.05276], [-117.2242, 33.05232], [-117.22397, 33.05269], [-117.22342, 33.05309], [-117.22333, 33.0532], [-117.22327, 33.05335], [-117.22319, 33.05334], [-117.22285, 33.05437], [-117.2217, 33.05409], [-117.22056, 33.05378], [-117.21929, 33.05347], [-117.21921, 33.05335], [-117.2161, 33.05151], [-117.2152, 33.05153], [-117.21517, 33.05106], [-117.21518, 33.05083], [-117.21545, 33.0506], [-117.21594, 33.05075], [-117.21635, 33.05105], [-117.21679, 33.05145], [-117.21732, 33.05162], [-117.21818, 33.05212], [-117.21855, 33.05236], [-117.2191, 33.05245], [-117.21953, 33.05245], [-117.22, 33.05237], [-117.22063, 33.05218], [-117.22118, 33.05198], [-117.22176, 33.05197], [-117.22196, 33.05142], [-117.22206, 33.05144], [-117.22209, 33.05145], [-117.2219, 33.05199], [-117.2221, 33.05204], [-117.22236, 33.0522], [-117.22247, 33.05237], [-117.22239, 33.05293], [-117.22239, 33.05312], [-117.22257, 33.05319], [-117.22287, 33.05307], [-117.22318, 33.05293], [-117.22333, 33.05278], [-117.22331, 33.05265], [-117.22347, 33.05211], [-117.22328, 33.0517], [-117.2231, 33.0515], [-117.22291, 33.05106], [-117.22291, 33.05094], [-117.22294, 33.05091], [-117.22296, 33.0508], [-117.22288, 33.05078], [-117.22291, 33.05061], [-117.22294, 33.05059], [-117.22293, 33.05044], [-117.22297, 33.0501], [-117.22301, 33.0501], [-117.22306, 33.05001], [-117.22299, 33.04997], [-117.22302, 33.04982], [-117.22309, 33.04983], [-117.22316, 33.04971], [-117.22322, 33.04966], [-117.2235, 33.04936], [-117.22355, 33.04924], [-117.22352, 33.04914], [-117.22362, 33.049], [-117.22362, 33.04898], [-117.22385, 33.04877], [-117.22389, 33.04867], [-117.22389, 33.04866], [-117.22404, 33.04837], [-117.22402, 33.04835], [-117.22407, 33.04826], [-117.22407, 33.04819], [-117.22411, 33.04819], [-117.22416, 33.04807], [-117.2241, 33.04804], [-117.22416, 33.0479], [-117.2241, 33.04783], [-117.22609, 33.04832], [-117.22545, 33.05038], [-117.22664, 33.05068]]]} | Open Access 1 | Val Sereno Preserve | 26755 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 54.576 | Val Sereno Preserve | ||
4670 | 4670 | 4669 | {"type": "Polygon", "coordinates": [[[-117.18378, 33.25255], [-117.18377, 33.25259], [-117.18374, 33.25261], [-117.18272, 33.25297], [-117.18189, 33.25323], [-117.18125, 33.25339], [-117.18097, 33.25343], [-117.18104, 33.24925], [-117.18302, 33.24925], [-117.18316, 33.24949], [-117.18322, 33.24967], [-117.1836, 33.25208], [-117.18366, 33.2523], [-117.18378, 33.25255]]]} | Open Access 1 | Gopher Canyon Reserve | 19407 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 23.855 | Gopher Canyon Reserve | ||
12248 | 12248 | 12247 | {"type": "Polygon", "coordinates": [[[-117.17513, 33.01315], [-117.17085, 33.01592], [-117.16887, 33.01455], [-117.16549, 33.01457], [-117.16225, 33.01456], [-117.16124, 33.01454], [-117.16134, 33.01094], [-117.15898, 33.01092], [-117.15897, 33.0073], [-117.16989, 33.00728], [-117.1699, 33.01126], [-117.17283, 33.01129], [-117.1732, 33.01127], [-117.17394, 33.01128], [-117.174, 33.01125], [-117.17441, 33.01238], [-117.17513, 33.01315]]]} | Open Access 1 | Lusardi Creek Preserve | http://www.sdparks.org/content/sdparks/en/park-pages/LusardiCreek.html | 29247 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 225.696 | Lusardi Creek Preserve | |
10668 | 10668 | 10667 | {"type": "Polygon", "coordinates": [[[-117.17283, 32.71998], [-117.17281, 32.72264], [-117.17279, 32.72266], [-117.1728, 32.72408], [-117.17172, 32.72444], [-117.17123, 32.72212], [-117.17121, 32.72193], [-117.1712, 32.71998], [-117.17283, 32.71998]]]} | Open Access 1 | Waterfront Park | http://www.sdparks.org/content/sdparks/en/park-pages/Waterfront.html | 29274 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 16.255 | Waterfront Park | |
8470 | 8470 | 8469 | {"type": "Polygon", "coordinates": [[[-117.15085, 33.41386], [-117.14988, 33.41386], [-117.14987, 33.41211], [-117.15083, 33.4121], [-117.15085, 33.41386]]]} | Open Access 1 | Rainbow Park | http://www.sdparks.org/content/sdparks/en/park-pages/Rainbow.html | 24087 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 4.327 | Rainbow Park | |
12259 | 12259 | 12258 | {"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 | Pala Mesa Mitigation Property | 29252 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 17.19 | Pala Mesa Mitigation Property | ||
14060 | 14060 | 14059 | {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14029, 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.13896, 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 | Knollwood Preserve | 31493 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 20.717 | Knollwood Preserve | ||
4739 | 4739 | 4738 | {"type": "Polygon", "coordinates": [[[-117.13525, 33.02933], [-117.1352, 33.03273], [-117.1346, 33.03273], [-117.13458, 33.03241], [-117.13336, 33.03194], [-117.13294, 33.0302], [-117.13281, 33.0301], [-117.13258, 33.03004], [-117.1325, 33.02998], [-117.13233, 33.02954], [-117.1323, 33.02934], [-117.13525, 33.02933]]]} | Open Access 1 | Greenfield Preserve | 19479 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 17.376 | Greenfield Preserve | ||
12275 | 12275 | 12274 | {"type": "Polygon", "coordinates": [[[-117.12105, 33.004], [-117.12098, 33.00409], [-117.12083, 33.00424], [-117.12067, 33.0045], [-117.12062, 33.00467], [-117.12064, 33.00492], [-117.12061, 33.00507], [-117.12023, 33.00568], [-117.11995, 33.00557], [-117.1199, 33.00545], [-117.11983, 33.00535], [-117.11975, 33.00525], [-117.11963, 33.00516], [-117.11942, 33.00505], [-117.1192, 33.00497], [-117.11907, 33.00495], [-117.11894, 33.00495], [-117.11843, 33.00502], [-117.11826, 33.00516], [-117.11817, 33.00485], [-117.11819, 33.00445], [-117.1182, 33.00431], [-117.11831, 33.00418], [-117.11838, 33.00401], [-117.11835, 33.00386], [-117.11829, 33.00382], [-117.11836, 33.00338], [-117.11849, 33.00338], [-117.11855, 33.00336], [-117.11859, 33.00332], [-117.11865, 33.00322], [-117.11868, 33.00319], [-117.11929, 33.00323], [-117.11993, 33.00317], [-117.1201, 33.0032], [-117.12038, 33.00331], [-117.12105, 33.00331], [-117.12111, 33.00375], [-117.1211, 33.00387], [-117.12105, 33.004]]]} | Open Access 1 | 4S Ranch Sports Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | 29269 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 12.833 | 4S Ranch Sports Park | |
7643 | 7643 | 7642 | {"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.11322, 33.25416], [-117.11342, 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 | Old Castle Mitigation Area | 23082 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 58.565 | Old Castle Mitigation Area | ||
12239 | 12239 | 12238 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11706, 33.00364], [-117.11616, 33.00356], [-117.11606, 33.00392], [-117.11567, 33.00389], [-117.11564, 33.00395], [-117.11496, 33.0039], [-117.11475, 33.00393], [-117.11456, 33.00399], [-117.11441, 33.00379], [-117.11455, 33.00346], [-117.11463, 33.00323], [-117.1147, 33.00315], [-117.11495, 33.00295], [-117.11527, 33.00298], [-117.11538, 33.00296], [-117.11553, 33.00327], [-117.11583, 33.00319], [-117.11718, 33.00331], [-117.11741, 33.00327], [-117.11754, 33.0033], [-117.11808, 33.00337], [-117.11836, 33.00338]]]} | Open Access 1 | 4S Ranch Community Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | 29225 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.824 | 4S Ranch Community Park | |
10604 | 10604 | 10603 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 4S Ranch Heritage Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | 29226 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.39 | 4S Ranch Heritage Park | |
12273 | 12273 | 12272 | {"type": "Polygon", "coordinates": [[[-117.11751, 33.01214], [-117.11748, 33.01217], [-117.11743, 33.01217], [-117.11666, 33.01201], [-117.11662, 33.01199], [-117.11658, 33.01192], [-117.11651, 33.01189], [-117.11645, 33.01189], [-117.11638, 33.01191], [-117.11618, 33.01171], [-117.11606, 33.01182], [-117.11597, 33.01213], [-117.11604, 33.01169], [-117.11601, 33.0116], [-117.11591, 33.01148], [-117.11611, 33.0115], [-117.11631, 33.01148], [-117.11653, 33.01149], [-117.1168, 33.01156], [-117.11707, 33.01159], [-117.11743, 33.01151], [-117.11752, 33.01172], [-117.11755, 33.01187], [-117.11753, 33.01206], [-117.11751, 33.01214]]]} | Open Access 1 | 4S Ranch Homestead Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchLiberty.html | 29267 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1.803 | 4S Ranch Homestead 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]);