superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,102 rows where MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 155
- San Diego, County of 116
- Santa Barbara, County of 77
- Orange, County of 72
- Lake, County of 54
- Santa Cruz, County of 45
- Butte, County of 45
- Kern, County of 42
- Sacramento, County of 41
- San Luis Obispo, County of 30
- Monterey, County of 27
- Placer, County of 26
- Riverside, County of 22
- Stanislaus, County of 22
- San Joaquin, County of 21
- Merced, County of 16
- Ventura, County of 15
- Fresno, County of 15
- San Bernardino, County of 15
- Tulare, County of 14
- Yolo, County of 14
- Humboldt, County of 9
- El Dorado, County of 8
- Tehama, County of 7
- Mariposa, County of 6
- Mono, County of 6
- Mendocino, County of 6
- Imperial, County of 5
- Napa, County of 5
- Modoc, County of 5
- …
ACCESS_TYP 4
- Open Access 870
- Restricted Access 54
- Unknown Access 33
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 983 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1640 | 1640 | 1639 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43248], [-119.78388, 34.43252], [-119.78345, 34.43278], [-119.78231, 34.43354], [-119.78143, 34.43378], [-119.78052, 34.4337], [-119.78052, 34.43358], [-119.78135, 34.43364], [-119.78158, 34.43361], [-119.78213, 34.43346], [-119.78241, 34.43332], [-119.78376, 34.43242], [-119.78381, 34.43241], [-119.78385, 34.43243], [-119.78388, 34.43248]]], [[[-119.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78624, 34.43108], [-119.78589, 34.43127], [-119.78408, 34.43239], [-119.78411, 34.4321], [-119.78448, 34.43201], [-119.78536, 34.43149], [-119.78544, 34.43143], [-119.7857, 34.43115], [-119.7862, 34.43068], [-119.78689, 34.43049], [-119.78695, 34.43058], [-119.79145, 34.42935], [-119.79202, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | Atascadero Creek | 15661 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 9.641 | Atascadero Creek | ||
1642 | 1642 | 1641 | {"type": "Polygon", "coordinates": [[[-118.28068, 33.91874], [-118.2806, 33.91876], [-118.2806, 33.91994], [-118.27843, 33.91994], [-118.27849, 33.9166], [-118.27855, 33.91656], [-118.2806, 33.91655], [-118.28067, 33.91661], [-118.28068, 33.91874]]]} | Open Access 1 | Athens Park | 15666 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 18.721 | Athens Park | ||
1649 | 1649 | 1648 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15502, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | Atlantic Avenue Park | 15674 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1.951 | Atlantic Avenue Park | ||
1651 | 1651 | 1650 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71542], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 3.539 | Atreule Et Al Community Plan | ||
1656 | 1656 | 1655 | {"type": "Polygon", "coordinates": [[[-121.57928, 39.81699], [-121.57902, 39.81678], [-121.57879, 39.8165], [-121.5787, 39.81607], [-121.57872, 39.81466], [-121.57854, 39.81417], [-121.57834, 39.81346], [-121.57847, 39.81298], [-121.5786, 39.81301], [-121.57885, 39.81322], [-121.57904, 39.81347], [-121.57916, 39.81374], [-121.57928, 39.81699]]]} | Open Access 1 | Butte holding 20 | 16564 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 4.825 | Butte holding 20 | ||
1692 | 1692 | 1691 | {"type": "Polygon", "coordinates": [[[-122.64942, 38.96071], [-122.6494, 38.96072], [-122.64938, 38.96077], [-122.64933, 38.9608], [-122.6478, 38.96099], [-122.64748, 38.96099], [-122.64546, 38.96091], [-122.64543, 38.96088], [-122.64543, 38.9608], [-122.6454, 38.96078], [-122.64541, 38.95935], [-122.64913, 38.95936], [-122.64916, 38.95938], [-122.64919, 38.95955], [-122.64921, 38.95956], [-122.64942, 38.96071]]]} | Open Access 1 | Austin Park | 15713 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 14.576 | Austin Park | ||
1698 | 1698 | 1697 | {"type": "Polygon", "coordinates": [[[-120.73725, 35.17986], [-120.73672, 35.18012], [-120.73669, 35.1801], [-120.73618, 35.18036], [-120.73606, 35.1802], [-120.73594, 35.18024], [-120.73585, 35.1803], [-120.73577, 35.18031], [-120.73612, 35.17952], [-120.73725, 35.17986]]]} | Open Access 1 | Avila Park | 15732 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.515 | Avila Park | ||
1706 | 1706 | 1705 | {"type": "Polygon", "coordinates": [[[-121.34664, 39.51201], [-121.34628, 39.51201], [-121.34628, 39.51175], [-121.34509, 39.51164], [-121.3449, 39.51155], [-121.34449, 39.51144], [-121.34658, 39.51124], [-121.34664, 39.51201]]]} | Open Access 1 | Butte holding 37 | 16581 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 1.798 | Butte holding 37 | ||
1707 | 1707 | 1706 | {"type": "Polygon", "coordinates": [[[-121.79652, 39.68185], [-121.79642, 39.68188], [-121.79607, 39.67968], [-121.79558, 39.67785], [-121.79577, 39.67784], [-121.79652, 39.68185]]]} | Open Access 1 | Butte holding 38 | 16582 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.857 | Butte holding 38 | ||
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 | |
1757 | 1757 | 1756 | {"type": "Polygon", "coordinates": [[[-121.58711, 39.81342], [-121.58621, 39.81385], [-121.58619, 39.81385], [-121.58633, 39.81373], [-121.58677, 39.81349], [-121.58711, 39.81342]]]} | Open Access 1 | Butte holding 21 | 16565 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.131 | Butte holding 21 | ||
1772 | 1772 | 1771 | {"type": "Polygon", "coordinates": [[[-121.60388, 39.85695], [-121.60385, 39.85697], [-121.60383, 39.857], [-121.60382, 39.85735], [-121.60364, 39.85735], [-121.60365, 39.857], [-121.60362, 39.85695], [-121.60388, 39.85695]]]} | Open Access 1 | Butte holding 22 | 16566 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.177 | Butte holding 22 | ||
1781 | 1781 | 1780 | {"type": "Polygon", "coordinates": [[[-121.74737, 39.49534], [-121.74694, 39.49534], [-121.74694, 39.49496], [-121.74736, 39.49496], [-121.74737, 39.49534]]]} | Open Access 1 | Butte holding 23 | 16567 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.385 | Butte holding 23 | ||
1784 | 1784 | 1783 | {"type": "Polygon", "coordinates": [[[-118.93335, 36.05327], [-118.92985, 36.0558], [-118.92813, 36.05675], [-118.9281, 36.05857], [-118.91372, 36.05857], [-118.91457, 36.05771], [-118.9149, 36.05674], [-118.91523, 36.05625], [-118.91535, 36.05652], [-118.91497, 36.05735], [-118.91511, 36.05767], [-118.91585, 36.058], [-118.91877, 36.058], [-118.91947, 36.05711], [-118.92079, 36.05711], [-118.92118, 36.05661], [-118.92137, 36.05655], [-118.92194, 36.0559], [-118.92294, 36.05525], [-118.92319, 36.05498], [-118.92353, 36.05439], [-118.92349, 36.05416], [-118.92339, 36.05408], [-118.92463, 36.05137], [-118.92516, 36.05104], [-118.9256, 36.05079], [-118.92683, 36.05031], [-118.92822, 36.04991], [-118.92816, 36.05452], [-118.93008, 36.05345], [-118.93103, 36.05314], [-118.93183, 36.05315], [-118.9328, 36.05262], [-118.93335, 36.05327]]]} | Open Access 1 | Bartlett Park | 15842 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 142.016 | Bartlett Park | ||
1795 | 1795 | 1794 | {"type": "Polygon", "coordinates": [[[-121.02867, 38.67828], [-121.02866, 38.67981], [-121.02866, 38.68191], [-121.0275, 38.68193], [-121.02633, 38.68374], [-121.02633, 38.6846], [-121.02169, 38.68456], [-121.01836, 38.67788], [-121.01832, 38.67709], [-121.01842, 38.67699], [-121.01883, 38.67516], [-121.0189, 38.67499], [-121.01899, 38.67485], [-121.01914, 38.67478], [-121.0193, 38.67476], [-121.0195, 38.67479], [-121.01975, 38.67492], [-121.02137, 38.67628], [-121.02188, 38.67638], [-121.02234, 38.67651], [-121.02373, 38.67706], [-121.02408, 38.67719], [-121.02444, 38.67728], [-121.02488, 38.67735], [-121.02524, 38.67737], [-121.02568, 38.67737], [-121.02617, 38.67701], [-121.02624, 38.67689], [-121.02625, 38.67681], [-121.02636, 38.67682], [-121.02635, 38.67829], [-121.02867, 38.67828]]]} | Open Access 1 | Bass Lake | 15855 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 152.117 | Bass Lake | ||
1796 | 1796 | 1795 | {"type": "Polygon", "coordinates": [[[-117.98854, 34.05187], [-117.98765, 34.05279], [-117.98644, 34.05198], [-117.98629, 34.05211], [-117.98513, 34.05133], [-117.98614, 34.05027], [-117.98854, 34.05187]]]} | Open Access 1 | Bassett Park | 15856 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 9.79 | Bassett Park | ||
1806 | 1806 | 1805 | {"type": "Polygon", "coordinates": [[[-121.50716, 39.77435], [-121.50641, 39.77428], [-121.50606, 39.77367], [-121.50686, 39.77374], [-121.50716, 39.77435]]]} | Open Access 1 | Butte holding 24 | 16568 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 1.05 | Butte holding 24 | ||
1814 | 1814 | 1813 | {"type": "Polygon", "coordinates": [[[-121.01029, 38.67025], [-121.00859, 38.67106], [-121.00596, 38.67107], [-121.00591, 38.67096], [-121.00832, 38.67042], [-121.0086, 38.67009], [-121.00799, 38.66978], [-121.00808, 38.66966], [-121.00871, 38.66997], [-121.00918, 38.6694], [-121.01029, 38.67025]]]} | Open Access 1 | Cameron Park-Shingle Springs 1 | 16762 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 6.404 | Cameron Park-Shingle Springs 1 | ||
1839 | 1839 | 1838 | {"type": "Polygon", "coordinates": [[[-117.88348, 33.60245], [-117.88321, 33.60315], [-117.88242, 33.60231], [-117.88295, 33.60212], [-117.88348, 33.60245]]]} | Open Access 1 | Bayside Drive Beach | 15893 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.344 | Bayside Drive Beach | ||
1847 | 1847 | 1846 | {"type": "Polygon", "coordinates": [[[-121.27835, 39.52723], [-121.27753, 39.52727], [-121.27742, 39.52663], [-121.27778, 39.52662], [-121.27814, 39.52652], [-121.27835, 39.52723]]]} | Open Access 1 | Butte holding 25 | 16569 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 1.222 | Butte holding 25 |
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]);