superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,206
- County Agency 1,102
- Recreation/Parks District 1,088
- State Agency 866
- Non Profit - Land Trust 511
- Federal Agency 287
- Open Space District 240
- County Agency - Parks 218
- Community Services District 193
- Water District 186
- Home Owners Association 180
- Non Profit - Conservation 118
- Flood District 92
- Cemetery District 51
- Non Profit - Other 44
- School District 38
- County Agency - Other 32
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Commercial 13
- Sanitation District 9
- Joint Powers Authority 8
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- California Department of Fish and Wildlife 394
- California Department of Parks and Recreation 276
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Mountains Recreation and Conservation Authority 181
- Los Angeles, County of 171
- Ventura, City of 151
- Long Beach, City of 148
- East Bay Regional Park District 132
- Roseville, City of 124
- Oakland, City of 122
- San Diego, County of 120
- Irvine, City of 98
- Fresno, City of 94
- Consumnes Community Services District 92
- Santa Barbara, County of 89
- Hayward Area Recreation and Park District 84
- Modesto, City of 84
- Orange, County of 82
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- …
ACCESS_TYP 4
- Open Access 13,487
- Restricted Access 1,096
- No Public Access 752
- Unknown Access 251
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3830 | 3830 | 3829 | {"type": "Polygon", "coordinates": [[[-120.57104, 34.97032], [-120.57096, 34.97044], [-120.57051, 34.97024], [-120.57058, 34.97012], [-120.57104, 34.97032]]]} | Open Access 1 | Guadalupe holding 10 | 19546 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.174 | Guadalupe holding 10 | |||
3831 | 3831 | 3830 | {"type": "Polygon", "coordinates": [[[-120.58052, 34.96254], [-120.58034, 34.96267], [-120.57983, 34.9626], [-120.57981, 34.9625], [-120.58012, 34.96231], [-120.58041, 34.96249], [-120.58052, 34.96254]]]} | Open Access 1 | Guadalupe holding 2 | 19547 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.371 | Guadalupe holding 2 | |||
3832 | 3832 | 3831 | {"type": "Polygon", "coordinates": [[[-120.5712, 34.97007], [-120.57104, 34.97032], [-120.57058, 34.97012], [-120.5709, 34.96963], [-120.57109, 34.96971], [-120.57095, 34.96996], [-120.5712, 34.97007]]]} | Open Access 1 | Guadalupe holding 3 | 19548 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.517 | Guadalupe holding 3 | |||
3833 | 3833 | 3832 | {"type": "Polygon", "coordinates": [[[-120.57089, 34.97056], [-120.57073, 34.9708], [-120.57028, 34.97061], [-120.57051, 34.97024], [-120.57088, 34.9704], [-120.57082, 34.97051], [-120.57089, 34.97056]]]} | Open Access 1 | Guadalupe holding 4 | 19549 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.501 | Guadalupe holding 4 | |||
3834 | 3834 | 3833 | {"type": "Polygon", "coordinates": [[[-120.58072, 34.9624], [-120.58052, 34.96254], [-120.58041, 34.96249], [-120.58049, 34.96217], [-120.58062, 34.96216], [-120.58072, 34.9624]]]} | Open Access 1 | Guadalupe holding 5 | 19550 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.189 | Guadalupe holding 5 | |||
3895 | 3895 | 3894 | {"type": "Polygon", "coordinates": [[[-119.10764, 36.34977], [-119.10762, 36.35107], [-119.1054, 36.35107], [-119.10542, 36.34976], [-119.10764, 36.34977]]]} | Open Access 1 | Hamilton Cemetery | 19616 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 7.138 | Hamilton Cemetery | |||
3903 | 3903 | 3902 | {"type": "Polygon", "coordinates": [[[-118.06813, 34.08258], [-118.0669, 34.08216], [-118.06677, 34.0821], [-118.06668, 34.08205], [-118.06669, 34.0812], [-118.06809, 34.08115], [-118.06813, 34.08258]]]} | Open Access 1 | El Monte Cemetery | 18517 | 3017 | El Monte Cemetery Association 847 | Non Profit 6 | Non Profit - Cemetery District 27 | Non Governmental Organization 10 | 4.134 | El Monte Cemetery | |||
4027 | 4027 | 4026 | {"type": "Polygon", "coordinates": [[[-118.51445, 34.12995], [-118.51442, 34.13004], [-118.51434, 34.1301], [-118.51426, 34.13013], [-118.51414, 34.13012], [-118.51299, 34.12951], [-118.51312, 34.12943], [-118.5133, 34.12937], [-118.51381, 34.12933], [-118.51442, 34.12983], [-118.51445, 34.12991], [-118.51445, 34.12995]]]} | No Public Access 3 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Other Federal 13 | 1.48 | Encino Reservoir - Federal | |||
4112 | 4112 | 4111 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | Open Access 1 | Exeter Cemetery | 18773 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 18.077 | Exeter Cemetery | |||
4196 | 4196 | 4195 | {"type": "MultiPolygon", "coordinates": [[[[-121.59691, 39.01108], [-121.59311, 39.01119], [-121.59358, 39.01301], [-121.59391, 39.01464], [-121.59433, 39.01645], [-121.59443, 39.01699], [-121.59445, 39.01733], [-121.59441, 39.01791], [-121.59437, 39.01814], [-121.59416, 39.01868], [-121.59396, 39.01902], [-121.59373, 39.01946], [-121.59354, 39.01995], [-121.5933, 39.02107], [-121.59319, 39.02146], [-121.59293, 39.02225], [-121.59287, 39.02225], [-121.59264, 39.02153], [-121.59211, 39.02089], [-121.59185, 39.0203], [-121.59032, 39.01854], [-121.58931, 39.01705], [-121.58836, 39.01612], [-121.58836, 39.01457], [-121.5864, 39.01457], [-121.58379, 39.01281], [-121.5838, 39.01078], [-121.58378, 39.00959], [-121.58501, 39.00963], [-121.58568, 39.00955], [-121.588, 39.00982], [-121.58942, 39.00995], [-121.59046, 39.00999], [-121.59107, 39.01008], [-121.59337, 39.01028], [-121.59439, 39.01045], [-121.59592, 39.01079], [-121.59691, 39.01108]]], [[[-121.59954, 39.07212], [-121.59934, 39.07246], [-121.59882, 39.07361], [-121.59842, 39.07428], [-121.59809, 39.07473], [-121.59786, 39.07522], [-121.59766, 39.0756], [-121.59715, 39.07635], [-121.59689, 39.07662], [-121.5966, 39.07703], [-121.59637, 39.0774], [-121.59611, 39.07778], [-121.59552, 39.07846], [-121.59529, 39.07892], [-121.59495, 39.07928], [-121.59445, 39.07974], [-121.59428, 39.07997], [-121.59408, 39.08016], [-121.59349, 39.08092], [-121.5933, 39.08112], [-121.59314, 39.08132], [-121.59269, 39.08175], [-121.59219, 39.08216], [-121.59203, 39.08233], [-121.5916, 39.08271], [-121.59139, 39.08287], [-121.59116, 39.08301], [-121.59097, 39.08317], [-121.59055, 39.08341], [-121.59036, 39.08357], [-121.59016, 39.08371], [-121.58968, 39.08415], [-121.58929, 39.08466], [-121.58875, 39.08539], [-121.58839, 39.08605], [-121.58785, 39.08691], [-121.58771, 39.08707], [-121.58689, 39.08791], [-121.5864, 39.08858], [-121.58609, 39.08908], [-121.58595, 39.08925], [-121.58573, 39.08967], [-121.58569, 39.08985], [-121.58569, 39.09004], [-121.58575, 39.09061], [-121.58587, 39.09133], [-121.58594, 39.09157], [-121.58604, 39.0926], [-121.58601, 39.09322], [-121.58606, 39.09392], [-121.58606, 39.0943], [-121.58614, 39.0955], [-121.5863, 39.09631], [-121.58639, 39.09685], [-121.58643, 39.09723], [-121.58662, 39.09793], [-121.58678, 39.09846], [-121.58682, 39.09854], [-121.58597, 39.09854], [-121.58567, 39.09764], [-121.58468, 39.09428], [-121.58458, 39.09132], [-121.58467, 39.0909], [-121.58475, 39.09036], [-121.58497, 39.08994], [-121.58534, 39.08915], [-121.58577, 39.08839], [-121.58625, 39.08782], [-121.58672, 39.08714], [-121.58714, 39.08666], [-121.58848, 39.0847], [-121.5891, 39.08373], [-121.58956, 39.08287], [-121.5898, 39.08238], [-121.59006, 39.08189], [-121.5908, 39.08095], [-121.59121, 39.08047], [-121.59226, 39.07935], [-121.59276, 39.07875], [-121.59278, 39.07648], [-121.59362, 39.07648], [-121.59384, 39.07609], [-121.59416, 39.0758], [-121.59497, 39.07528], [-121.59533, 39.07501], [-121.59632, 39.07414], [-121.59669, 39.07385], [-121.59697, 39.07345], [-121.59736, 39.07281], [-121.59786, 39.07182], [-121.59954, 39.07212]]], [[[-121.60816, 39.04031], [-121.60835, 39.04131], [-121.60845, 39.04199], [-121.60859, 39.04275], [-121.60865, 39.04316], [-121.60866, 39.04405], [-121.60885, 39.04578], [-121.60901, 39.04677], [-121.60914, 39.04751], [-121.60925, 39.04829], [-121.60933, 39.04946], [-121.60963, 39.05223], [-121.60988, 39.05361], [-121.60993, 39.05437], [-121.60992, 39.05487], [-121.60995, 39.05554], [-121.61003, 39.05589], [-121.61012, 39.05638], [-121.61012, 39.05727], [-121.60998, 39.058], [-121.60972, 39.05842], [-121.60917, 39.05918], [-121.60876, 39.05993], [-121.60817, 39.06083], [-121.60767, 39.06145], [-121.60749, 39.0617], [-121.60473, 39.06131], [-121.60098, 39.05938], [-121.60167, 39.05491], [-121.60202, 39.05489], [-121.60225, 39.0404], [-121.60632, 39.04039], [-121.60712, 39.04034], [-121.60211, 39.04034], [-121.6018, 39.03873], [-121.60148, 39.03634], [-121.60101, 39.03367], [-121.6005, 39.03365], [-121.60049, 39.03311], [-121.60558, 39.03309], [-121.6062, 39.03424], [-121.60636, 39.03477], [-121.60696, 39.03595], [-121.6072, 39.03667], [-121.60733, 39.03687], [-121.60758, 39.03761], [-121.60774, 39.03819], [-121.60802, 39.03954], [-121.60805, 39.03986], [-121.60816, 39.04031]]]]} | Unknown Access 4 | Feather River | 18860 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Special District 4 | 734.001 | Feather River | |||
4271 | 4271 | 4270 | {"type": "Polygon", "coordinates": [[[-119.62216, 36.57616], [-119.61991, 36.57617], [-119.61986, 36.57615], [-119.61984, 36.57612], [-119.61982, 36.57405], [-119.62216, 36.57616]]]} | Open Access 1 | Floral Memorial Cemetery | 18958 | 2148 | Selma Cemetery District 247 | Special District 4 | Cemetery District 11 | Special District 4 | 6.038 | Floral Memorial Cemetery | |||
4278 | 4278 | 4277 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 9.886 | Foglesong Park/Eda Henderson Pool | |||
4348 | 4348 | 4347 | {"type": "Polygon", "coordinates": [[[-119.68461, 36.60967], [-119.68459, 36.61269], [-119.68239, 36.61268], [-119.68238, 36.60964], [-119.68461, 36.60967]]]} | Open Access 1 | Fowler Cemetery | 19028 | 2035 | Fowler Cemetery District 394 | Special District 4 | Cemetery District 11 | Special District 4 | 16.465 | Fowler Cemetery | |||
4367 | 4367 | 4366 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | Open Access 1 | Frazier Valley Cemetery | 19071 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Special District 4 | 2.538 | Frazier Valley Cemetery | |||
4420 | 4420 | 4419 | {"type": "Polygon", "coordinates": [[[-119.71275, 36.9916], [-119.71191, 36.99249], [-119.7112, 36.99207], [-119.71091, 36.99196], [-119.71085, 36.99186], [-119.71077, 36.99183], [-119.71053, 36.99176], [-119.71044, 36.99178], [-119.71062, 36.99139], [-119.71109, 36.99063], [-119.71154, 36.99058], [-119.71275, 36.9916]]]} | Open Access 1 | Friant Cove | 19113 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 5.884 | Friant Cove | |||
4422 | 4422 | 4421 | {"type": "Polygon", "coordinates": [[[-116.33702, 34.11024], [-116.33643, 34.11074], [-116.33563, 34.11215], [-116.33564, 34.11023], [-116.33702, 34.11024]]]} | Open Access 1 | Friendly Hills Park | 19115 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2.814 | Friendly Hills Park | |||
4465 | 4465 | 4464 | {"type": "Polygon", "coordinates": [[[-123.37488, 41.79526], [-123.37479, 41.79527], [-123.37464, 41.79551], [-123.37252, 41.79546], [-123.37205, 41.79325], [-123.3725, 41.79301], [-123.37448, 41.79406], [-123.37488, 41.79526]]]} | Open Access 1 | Gale Zinc Memorial Park | 19173 | 2226 | Happy Camp Community Services District 958 | Special District 4 | Community Services District 17 | Special District 4 | 10.657 | Gale Zinc Memorial Park | |||
4652 | 4652 | 4651 | {"type": "Polygon", "coordinates": [[[-121.05008, 37.47695], [-121.04981, 37.47744], [-121.04901, 37.47823], [-121.04893, 37.48562], [-121.04748, 37.48584], [-121.04661, 37.48352], [-121.04625, 37.48355], [-121.04608, 37.48354], [-121.04588, 37.48349], [-121.04562, 37.48339], [-121.04538, 37.48317], [-121.0453, 37.48304], [-121.04517, 37.48265], [-121.04504, 37.48171], [-121.04405, 37.48162], [-121.04261, 37.48197], [-121.04182, 37.4817], [-121.04167, 37.48135], [-121.0417, 37.48091], [-121.04211, 37.4806], [-121.04288, 37.48066], [-121.04371, 37.48094], [-121.04433, 37.48093], [-121.04464, 37.48038], [-121.04424, 37.4798], [-121.04404, 37.47886], [-121.0446, 37.47887], [-121.0447, 37.47961], [-121.04544, 37.48016], [-121.04697, 37.48112], [-121.04678, 37.48136], [-121.04678, 37.48138], [-121.04738, 37.4816], [-121.04842, 37.48148], [-121.04888, 37.48106], [-121.04884, 37.48074], [-121.04816, 37.4803], [-121.04815, 37.47982], [-121.04869, 37.47938], [-121.04871, 37.47807], [-121.04954, 37.47726], [-121.0498, 37.47675], [-121.04997, 37.47686], [-121.05008, 37.47695]], [[-121.04619, 37.48132], [-121.04606, 37.48124], [-121.04563, 37.48131], [-121.04513, 37.481], [-121.04492, 37.48099], [-121.04425, 37.48114], [-121.04401, 37.48116], [-121.04369, 37.4811], [-121.04297, 37.4808], [-121.04251, 37.48072], [-121.04228, 37.48073], [-121.04216, 37.48077], [-121.04206, 37.48082], [-121.04184, 37.48099], [-121.04186, 37.48134], [-121.04193, 37.48152], [-121.04206, 37.4816], [-121.04247, 37.48166], [-121.0427, 37.48174], [-121.0429, 37.48173], [-121.04382, 37.48147], [-121.0441, 37.48146], [-121.04487, 37.48158], [-121.04516, 37.48153], [-121.04569, 37.48173], [-121.0459, 37.48179], [-121.04622, 37.48158], [-121.04625, 37.48144], [-121.04619, 37.48132]]]} | Open Access 1 | Gomes Lake | 19387 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Special District 4 | 42.286 | Gomes Lake | |||
4785 | 4785 | 4784 | {"type": "Polygon", "coordinates": [[[-120.57648, 34.95764], [-120.57647, 34.95894], [-120.57408, 34.95892], [-120.57408, 34.95762], [-120.57648, 34.95764]]]} | Open Access 1 | Guadalupe Cemetery | 19541 | 2043 | Guadalupe Cemetery District 900 | Special District 4 | Cemetery District 11 | Special District 4 | 7.795 | Guadalupe Cemetery | |||
4788 | 4788 | 4787 | {"type": "Polygon", "coordinates": [[[-120.57749, 34.95931], [-120.57749, 34.95936], [-120.57745, 34.95938], [-120.57717, 34.95939], [-120.57718, 34.95846], [-120.57722, 34.95871], [-120.57726, 34.95884], [-120.57749, 34.95931]]]} | Open Access 1 | Guadalupe holding 1 | 19545 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.328 | Guadalupe holding 1 |
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]);