units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 101
- Fresno, City of 95
- Modesto, City of 85
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- San Luis Obispo, City of 66
- Newport Beach, City of 65
- Davis, City of 65
- Santa Barbara, City of 64
- Clovis, City of 62
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
DES_TP >30
- Local Park 7,486
- Local Recreation Area 1,440
- Local Other or Unknown 663
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10863 | 10863 | 10862 | {"type": "Polygon", "coordinates": [[[-118.82414, 34.0228], [-118.82415, 34.02343], [-118.8242, 34.02514], [-118.82383, 34.02594], [-118.82355, 34.02636], [-118.82309, 34.02697], [-118.8214, 34.02658], [-118.82087, 34.0264], [-118.82069, 34.02541], [-118.82061, 34.02514], [-118.82048, 34.02484], [-118.82045, 34.02472], [-118.82044, 34.02459], [-118.82046, 34.02446], [-118.82054, 34.02429], [-118.82093, 34.02387], [-118.82105, 34.02371], [-118.82121, 34.02343], [-118.82192, 34.02391], [-118.82243, 34.02344], [-118.8217, 34.02273], [-118.82181, 34.0226], [-118.82192, 34.0225], [-118.82258, 34.02203], [-118.82271, 34.02189], [-118.82412, 34.02284], [-118.82414, 34.02283], [-118.82414, 34.0228]]]} | Restricted Access 2 | 20661 | Malibu Equestrian Park | 32834 | 2423 | Santa Monica-Malibu Unified School District 960 | Special District 4 | School District 14 | www.smmusd.org | Special District 4 | 1193 | Malibu, City of 928 | City 2 | City Agency 2 | Los Angeles 6 | 32.463 | Malibu Equestrian Park | 0 | Local Recreation Area 3 | 4 | |
4166 | 4166 | 4165 | {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22148], [-121.07549, 39.22233], [-121.07527, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07552, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} | Restricted Access 2 | 48291 | Margaret G Scotten School Ballfields | 32866 | 2429 | Grass Valley School District 728 | Special District 4 | School District 14 | www.gvsd.us | Special District 4 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 8.566 | Margaret G Scotten School Ballfields | 2018 | None 361 | ||
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
11506 | 11506 | 11505 | {"type": "MultiPolygon", "coordinates": [[[[-122.26439, 40.46354], [-122.26186, 40.46573], [-122.26173, 40.46555], [-122.26152, 40.46533], [-122.26093, 40.46456], [-122.26067, 40.46429], [-122.26042, 40.46408], [-122.25979, 40.46373], [-122.25937, 40.46342], [-122.25849, 40.46291], [-122.2574, 40.4625], [-122.25689, 40.46224], [-122.25581, 40.46194], [-122.25528, 40.46176], [-122.25826, 40.45926], [-122.25894, 40.45972], [-122.25774, 40.46074], [-122.25774, 40.46075], [-122.25834, 40.46116], [-122.25955, 40.46015], [-122.26439, 40.46354]]], [[[-122.27724, 40.46773], [-122.27711, 40.46784], [-122.27722, 40.46806], [-122.27378, 40.4691], [-122.27158, 40.47075], [-122.27044, 40.47169], [-122.26905, 40.47272], [-122.26848, 40.47302], [-122.26697, 40.47311], [-122.26542, 40.47269], [-122.2634, 40.47184], [-122.26244, 40.47132], [-122.26088, 40.47093], [-122.25945, 40.47025], [-122.25885, 40.46904], [-122.25868, 40.46843], [-122.26163, 40.46594], [-122.26734, 40.46985], [-122.27317, 40.46493], [-122.27724, 40.46773]]], [[[-122.28086, 40.46807], [-122.27979, 40.46787], [-122.27888, 40.46784], [-122.27965, 40.46719], [-122.27968, 40.4672], [-122.27964, 40.46726], [-122.28086, 40.46807]]]]} | Open Access 1 | 48204 | Anderson River Park | 32743 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1421 | Anderson, City of 602 | City 2 | City Agency 2 | http://cms3.revize.com/revize/andersoncanew/departments/parks.php | Shasta 27 | 212.125 | Anderson River Park | 0 | Local Park 2 | 4 |
3525 | 3525 | 3524 | {"type": "Polygon", "coordinates": [[[-118.1436, 33.87107], [-118.14301, 33.87107], [-118.14301, 33.87037], [-118.14299, 33.87036], [-118.14299, 33.86965], [-118.1436, 33.86965], [-118.1436, 33.87107]]]} | Open Access 1 | 20595 | Constitution Park | 17598 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 2.156 | Constitution Park | 0 | Local Park 2 | 4 | |
3526 | 3526 | 3525 | {"type": "Polygon", "coordinates": [[[-118.11099, 33.9097], [-118.1104, 33.90972], [-118.10973, 33.90773], [-118.11031, 33.90763], [-118.11099, 33.9097]]]} | Open Access 1 | 20596 | H. Byrum Zinn Community Park and Trail | 29571 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 3.096 | H. Byrum Zinn Community Park and Trail | 0 | Local Recreation Area 3 | 4 | |
3943 | 3943 | 3942 | {"type": "Polygon", "coordinates": [[[-118.10976, 33.89657], [-118.10921, 33.89657], [-118.10912, 33.88798], [-118.10968, 33.88802], [-118.10976, 33.89657]]]} | Open Access 1 | 46282 | Riverview Park | 24462 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 12.094 | Riverview Park | 0 | Local Park 2 | 4 | |
4172 | 4172 | 4171 | {"type": "Polygon", "coordinates": [[[-118.16946, 33.93806], [-118.16891, 33.93872], [-118.16808, 33.93971], [-118.16762, 33.9386], [-118.1679, 33.93827], [-118.1681, 33.93828], [-118.16864, 33.93763], [-118.16946, 33.93806]]]} | Open Access 1 | 46508 | Circle Park | 29791 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1339 | South Gate, City of 645 | City 2 | City Agency 2 | Los Angeles 6 | 4.401 | Circle Park | 0 | Local Park 2 | 4 | |
4426 | 4426 | 4425 | {"type": "Polygon", "coordinates": [[[-118.10901, 33.88199], [-118.109, 33.88235], [-118.10866, 33.88235], [-118.10866, 33.88199], [-118.10901, 33.88199]]]} | Open Access 1 | 46311 | Caruthers Park North | 29601 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.313 | Caruthers Park North | 0 | Local Park 2 | 4 |
4756 | 4756 | 4755 | {"type": "Polygon", "coordinates": [[[-118.1743, 33.90349], [-118.17321, 33.9035], [-118.17318, 33.89977], [-118.17427, 33.89978], [-118.1743, 33.90349]]]} | No Public Access 3 | 46526 | Unnamed site - Paramount, City of | 29815 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 10.254 | 0 | Local Other or Unknown 14 | 4 | ||
6938 | 6938 | 6937 | {"type": "Polygon", "coordinates": [[[-118.10543, 33.93264], [-118.10487, 33.93319], [-118.10081, 33.93783], [-118.10047, 33.93824], [-118.10017, 33.93865], [-118.09971, 33.93843], [-118.10032, 33.93761], [-118.10032, 33.93724], [-118.10116, 33.93525], [-118.10125, 33.93525], [-118.10344, 33.93344], [-118.10398, 33.93344], [-118.10463, 33.93269], [-118.105, 33.93223], [-118.10543, 33.93264]]]} | Open Access 1 | 5834 | Wilderness Park | 27512 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1088 | Downey, City of 80 | City 2 | City Agency 2 | Los Angeles 6 | 18.456 | Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
10847 | 10847 | 10846 | {"type": "Polygon", "coordinates": [[[-118.12837, 34.0455], [-118.12829, 34.04553], [-118.12817, 34.04553], [-118.12743, 34.04535], [-118.1272, 34.04532], [-118.11801, 34.04309], [-118.11799, 34.04277], [-118.11801, 34.04266], [-118.12629, 34.04467], [-118.12828, 34.0447], [-118.12838, 34.04547], [-118.12837, 34.0455]]]} | Open Access 1 | 20633 | Edison Trails Park | 18447 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 12.372 | Edison Trails Park | 0 | Local Park 2 | 4 | |
13127 | 13127 | 13126 | {"type": "Polygon", "coordinates": [[[-118.17428, 33.89646], [-118.17425, 33.89715], [-118.17427, 33.89978], [-118.17318, 33.89977], [-118.17316, 33.89651], [-118.17318, 33.89648], [-118.17322, 33.89647], [-118.17428, 33.89646]]]} | Open Access 1 | 45069 | Salud Park | 29814 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | http://www.paramountcity.com/parks.cfm?task=detail&ID=10 | Los Angeles 6 | 9.17 | Salud Park | 0 | Local Park 2 | 4 |
14346 | 14346 | 14345 | {"type": "Polygon", "coordinates": [[[-118.08266, 34.08809], [-118.08266, 34.08809], [-118.08238, 34.08853], [-118.08229, 34.08817], [-118.08227, 34.08805], [-118.08228, 34.08802], [-118.08232, 34.08799], [-118.08238, 34.08799], [-118.08266, 34.08809]]]} | Open Access 1 | 45594 | Guess Park | 29851 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.28 | Guess Park | 0 | Local Park 2 | 4 | |
15399 | 15399 | 15398 | {"type": "Polygon", "coordinates": [[[-118.18285, 33.87975], [-118.18285, 33.88002], [-118.18185, 33.88002], [-118.18185, 33.87975], [-118.18285, 33.87975]]]} | Open Access 1 | 46616 | North Community Gardens | 29930 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.68 | North Community Gardens | 0 | Local Park 2 | 4 | |
11408 | 11408 | 11407 | {"type": "Polygon", "coordinates": [[[-115.54531, 32.76157], [-115.5453, 32.76193], [-115.54472, 32.76194], [-115.54451, 32.76195], [-115.54426, 32.76202], [-115.54411, 32.76204], [-115.54368, 32.76207], [-115.54357, 32.76207], [-115.54356, 32.76168], [-115.54359, 32.76168], [-115.5436, 32.76165], [-115.54404, 32.76165], [-115.54459, 32.76156], [-115.54531, 32.76157]]]} | Open Access 1 | 48092 | Countryside Park | 32595 | 6122 | Pulte Home Corporation 976 | Private 7 | Commercial 20 | https://www.pulte.com/ | Private 14 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 1.727 | Countryside Park | 2007 | Local Park 2 | 4 | |
233 | 233 | 232 | {"type": "Polygon", "coordinates": [[[-119.21449, 34.19396], [-119.21253, 34.19394], [-119.21254, 34.19326], [-119.2126, 34.19305], [-119.21268, 34.19293], [-119.21278, 34.19282], [-119.21347, 34.19226], [-119.21353, 34.19225], [-119.21427, 34.19287], [-119.21435, 34.19296], [-119.21442, 34.19307], [-119.21447, 34.19318], [-119.2145, 34.1933], [-119.21449, 34.19396]]]} | Open Access 1 | 751 | Seaview Park | 25272 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 6.433 | Seaview Park | 0 | Local Park 2 | 4 | |
432 | 432 | 431 | {"type": "Polygon", "coordinates": [[[-119.21445, 34.18501], [-119.21443, 34.18655], [-119.21133, 34.18652], [-119.21134, 34.18535], [-119.21139, 34.18509], [-119.21145, 34.18492], [-119.21147, 34.1849], [-119.21184, 34.18496], [-119.21441, 34.18498], [-119.21445, 34.18501]]]} | Open Access 1 | 1737 | Via Marina Park | 27066 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 12.286 | Via Marina Park | 0 | Local Park 2 | 4 | |
1365 | 1365 | 1364 | {"type": "Polygon", "coordinates": [[[-119.15937, 34.16808], [-119.15942, 34.16812], [-119.15975, 34.16896], [-119.15986, 34.16936], [-119.15991, 34.16971], [-119.15992, 34.17005], [-119.15989, 34.17315], [-119.15987, 34.17319], [-119.15982, 34.17321], [-119.15901, 34.17321], [-119.15889, 34.17311], [-119.15891, 34.17266], [-119.15866, 34.17237], [-119.1583, 34.17222], [-119.15652, 34.17235], [-119.1517, 34.1696], [-119.15172, 34.16795], [-119.15919, 34.168], [-119.1592, 34.16808], [-119.15937, 34.16808]]]} | Open Access 1 | 8157 | College Park | 17511 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 74.897 | College Park | 0 | Local Park 2 | 4 | |
1767 | 1767 | 1766 | {"type": "Polygon", "coordinates": [[[-119.1639, 34.20442], [-119.16389, 34.2052], [-119.16262, 34.20519], [-119.16261, 34.20628], [-119.15976, 34.20626], [-119.15978, 34.20439], [-119.1639, 34.20442]]]} | Open Access 1 | 13232 | Del Sol Park | 18055 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 15.982 | Del Sol 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]);