superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
120 rows where MNG_AGENCY = 101 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6179 | 6179 | 6178 | {"type": "Polygon", "coordinates": [[[-117.07154, 32.66675], [-117.0713, 32.66682], [-117.07133, 32.66693], [-117.07096, 32.66703], [-117.07084, 32.66671], [-117.07146, 32.66654], [-117.07154, 32.66675]]]} | Open Access 1 | Lincoln Acres Park | http://www.sdparks.org/content/sdparks/en/park-pages/LincolnAcres.html | 21245 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 0.485 | Lincoln Acres Park | |
12227 | 12227 | 12226 | {"type": "Polygon", "coordinates": [[[-117.01386, 32.72777], [-117.0139, 32.72806], [-117.0139, 32.72816], [-117.01388, 32.72821], [-117.01382, 32.7283], [-117.01375, 32.72838], [-117.01357, 32.72848], [-117.01357, 32.7277], [-117.01378, 32.72776], [-117.01386, 32.72777]]]} | Open Access 1 | Ildica Street Park | http://www.sdparks.org/content/sdparks/en/park-pages/IldicaStreetPark.html | 29205 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 0.504 | Ildica Street Park | |
12225 | 12225 | 12224 | {"type": "Polygon", "coordinates": [[[-116.93617, 32.74656], [-116.93581, 32.74674], [-116.93549, 32.74631], [-116.93585, 32.74615], [-116.93617, 32.74656]]]} | Open Access 1 | Hillsdale Park | http://www.sdparks.org/content/sdparks/en/park-pages/Hillsdale.html | 29204 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 0.53 | Hillsdale Park | |
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 |
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 | |
12216 | 12216 | 12215 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | Campo Stone Store | http://ohp.parks.ca.gov/ListedResources/Detail/411 | 29229 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 0.819 | Campo Stone Store | |
4650 | 4650 | 4649 | {"type": "Polygon", "coordinates": [[[-117.00957, 32.73712], [-117.00956, 32.73771], [-117.00891, 32.7377], [-117.00892, 32.73676], [-117.00933, 32.73677], [-117.00933, 32.73711], [-117.00957, 32.73712]]]} | Open Access 1 | Goodland Acres Park | http://www.sdparks.org/content/sdparks/en/park-pages/GoodlandAcres.html | 19403 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1.352 | Goodland Acres Park | |
12255 | 12255 | 12254 | {"type": "Polygon", "coordinates": [[[-116.60352, 33.07735], [-116.60296, 33.07789], [-116.60246, 33.07753], [-116.60287, 33.07712], [-116.60264, 33.07693], [-116.60277, 33.07681], [-116.60352, 33.07735]]]} | Open Access 1 | Julian Museum and Pioneer Park | http://www.sdparks.org/content/sdparks/en/park-pages/JulianMuseum.html | 29242 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1.355 | Julian Museum and Pioneer 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 | |
7297 | 7297 | 7296 | {"type": "Polygon", "coordinates": [[[-116.86518, 32.80929], [-116.86498, 32.80983], [-116.8637, 32.80982], [-116.86371, 32.80929], [-116.86518, 32.80929]]]} | Open Access 1 | Nancy Jane County Park | http://www.sdparks.org/content/sdparks/en/park-pages/NancyJane.html | 22624 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1.898 | Nancy Jane County Park | |
13832 | 13832 | 13831 | {"type": "Polygon", "coordinates": [[[-116.82786, 32.82212], [-116.82777, 32.82238], [-116.82768, 32.82304], [-116.82756, 32.82342], [-116.82751, 32.82344], [-116.82696, 32.82328], [-116.82688, 32.82324], [-116.82678, 32.8231], [-116.82662, 32.82264], [-116.8266, 32.82253], [-116.82663, 32.82209], [-116.82665, 32.82201], [-116.82737, 32.82222], [-116.82739, 32.8222], [-116.82738, 32.82197], [-116.82786, 32.82212]]]} | Open Access 1 | Old Ironsides County Park | 31372 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 3.365 | Old Ironsides County Park | ||
14085 | 14085 | 14084 | {"type": "Polygon", "coordinates": [[[-116.86005, 33.31388], [-116.86006, 33.31401], [-116.86005, 33.31413], [-116.85991, 33.31447], [-116.85907, 33.31471], [-116.85906, 33.31388], [-116.85861, 33.31387], [-116.85861, 33.31286], [-116.85864, 33.31284], [-116.85865, 33.31273], [-116.85907, 33.31274], [-116.85908, 33.31311], [-116.85934, 33.31313], [-116.85934, 33.31387], [-116.86005, 33.31388]]]} | Open Access 1 | Palomar County Park | http://www.sdparks.org/content/sdparks/en/park-pages/Palomar.html | 31534 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 3.56 | Palomar County Park | |
9447 | 9447 | 9446 | {"type": "MultiPolygon", "coordinates": [[[[-117.3003, 33.05251], [-117.30004, 33.05256], [-117.29996, 33.05233], [-117.29942, 33.05098], [-117.29921, 33.05081], [-117.29928, 33.05081], [-117.29929, 33.0508], [-117.2992, 33.05012], [-117.29918, 33.04985], [-117.29908, 33.04958], [-117.29912, 33.04946], [-117.29967, 33.0508], [-117.29972, 33.05081], [-117.30002, 33.05167], [-117.30005, 33.05183], [-117.3003, 33.05251]]], [[[-117.30173, 33.05629], [-117.30148, 33.05638], [-117.3014, 33.05627], [-117.30138, 33.05619], [-117.30166, 33.05612], [-117.30166, 33.0561], [-117.30158, 33.05598], [-117.30138, 33.05554], [-117.30104, 33.05462], [-117.30076, 33.05468], [-117.30008, 33.0527], [-117.30033, 33.05262], [-117.30167, 33.05611], [-117.30173, 33.05629]]]]} | Open Access 1 | Seaside Gardens County Park | 25250 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 4.086 | Seaside Gardens County 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 | |
1740 | 1740 | 1739 | {"type": "Polygon", "coordinates": [[[-117.00133, 32.74581], [-117.00084, 32.74581], [-117.00082, 32.74585], [-117.00087, 32.74595], [-117.00053, 32.74629], [-117.00034, 32.74616], [-117.00008, 32.74645], [-116.99996, 32.74633], [-116.99954, 32.74618], [-116.99953, 32.74531], [-117.00019, 32.74531], [-117.00021, 32.74539], [-117.00066, 32.74538], [-117.00066, 32.74515], [-117.00083, 32.74497], [-117.00083, 32.74462], [-117.00132, 32.74461], [-117.00133, 32.74581]]]} | Open Access 1 | Bancroft Park | http://www.sdparks.org/content/sdparks/en/park-pages/Bancroft.html | 15792 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 4.682 | Bancroft Park | |
10572 | 10572 | 10571 | {"type": "Polygon", "coordinates": [[[-117.11446, 33.0364], [-117.11431, 33.03678], [-117.1142, 33.03696], [-117.11407, 33.03715], [-117.11377, 33.0375], [-117.11362, 33.03763], [-117.11341, 33.03775], [-117.11311, 33.03738], [-117.1126, 33.03682], [-117.11262, 33.03678], [-117.11303, 33.03641], [-117.11347, 33.0359], [-117.11376, 33.03607], [-117.11436, 33.03631], [-117.11446, 33.0364]]]} | Open Access 1 | 4S Ranch Liberty Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | 29187 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 4.774 | 4S Ranch Liberty Park | |
12278 | 12278 | 12277 | {"type": "Polygon", "coordinates": [[[-116.93134, 32.608], [-116.93126, 32.60819], [-116.93076, 32.60814], [-116.92998, 32.60819], [-116.92945, 32.60825], [-116.92907, 32.60836], [-116.92898, 32.60832], [-116.92901, 32.60821], [-116.92941, 32.60736], [-116.92939, 32.60723], [-116.92946, 32.60712], [-116.93046, 32.60712], [-116.9308, 32.60725], [-116.93096, 32.60738], [-116.9311, 32.60753], [-116.93127, 32.60761], [-116.93121, 32.60792], [-116.93134, 32.608]]]} | Open Access 1 | Otay Lakes County Park | http://www.sdparks.org/content/sdparks/en/park-pages/OtayLakes.html | 29273 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.179 | Otay Lakes County Park | |
10626 | 10626 | 10625 | {"type": "Polygon", "coordinates": [[[-116.95847, 32.74943], [-116.95847, 32.75121], [-116.95732, 32.75118], [-116.95732, 32.74942], [-116.95847, 32.74943]]]} | Open Access 1 | Lonny Brewer Park | http://www.sdparks.org/content/sdparks/en/park-pages/LonnyBrewer.html | 29245 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.232 | Lonny Brewer 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 | |
12276 | 12276 | 12275 | {"type": "Polygon", "coordinates": [[[-116.91742, 32.75157], [-116.91715, 32.75181], [-116.91631, 32.75232], [-116.91649, 32.75258], [-116.91616, 32.75277], [-116.91612, 32.75277], [-116.91608, 32.75275], [-116.91571, 32.75227], [-116.9156, 32.75217], [-116.91491, 32.75174], [-116.9151, 32.75147], [-116.91522, 32.75105], [-116.91702, 32.75139], [-116.91725, 32.75147], [-116.91742, 32.75157]]]} | Open Access 1 | Cottonwood County Park | http://www.sdparks.org/content/sdparks/en/park-pages/Cottonwood.html | 29270 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.473 | Cottonwood County 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]);