units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,925 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 2 sorted by AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 503
- Los Angeles, City of 432
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 216
- Ventura, City of 149
- Long Beach, City of 135
- Roseville, City of 123
- Oakland, City of 122
- Irvine, City of 100
- Fresno, City of 92
- Modesto, City of 78
- Stockton, City of 77
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Rosa, City of 72
- Chula Vista, City of 68
- Brentwood, City of 68
- Napa, City of 67
- Santa Cruz, City of 65
- Newport Beach, City of 65
- Poway, City of 64
- San Luis Obispo, City of 63
- Davis, City of 62
- Clovis, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- Glendale, City of 59
- Riverside, City of 59
- Bakersfield, City of 59
- …
DES_TP >30
- Local Park 7,297
- Local Recreation Area 1,226
- Local Other or Unknown 581
- Local Conservation Area 126
- Local Historic or Cultural Area 35
- National Monument or Landmark 4
- Local Resource Management Area 4
- 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
- National Recreation Area 1
- …
MNG_AG_TYP 1
- City Agency · 9,925 ✖
ACCESS_TYP 1
- Open Access · 9,925 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
2399 | 2399 | 2398 | {"type": "Polygon", "coordinates": [[[-119.18097, 34.19734], [-119.18096, 34.19804], [-119.17997, 34.19803], [-119.17997, 34.19733], [-119.18097, 34.19734]]]} | Open Access 1 | 18651 | Plaza Park | 23787 | 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 | 1.751 | Plaza Park | 0 | Local Park 2 | 4 | |
2767 | 2767 | 2766 | {"type": "Polygon", "coordinates": [[[-119.22722, 34.17014], [-119.2272, 34.17019], [-119.22717, 34.17024], [-119.22711, 34.17028], [-119.22703, 34.1703], [-119.22543, 34.17028], [-119.22543, 34.16974], [-119.22697, 34.16921], [-119.22722, 34.16972], [-119.22722, 34.17014]]]} | Open Access 1 | 18479 | Peninsula Park | 23580 | 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 | 3.673 | Peninsula Park | 0 | Local Park 2 | 4 | |
2908 | 2908 | 2907 | {"type": "Polygon", "coordinates": [[[-119.20626, 34.19563], [-119.20624, 34.19731], [-119.19926, 34.19726], [-119.19928, 34.19606], [-119.19965, 34.19607], [-119.19969, 34.19613], [-119.19976, 34.19617], [-119.1999, 34.19621], [-119.20002, 34.1962], [-119.20163, 34.19621], [-119.20176, 34.19623], [-119.20186, 34.19621], [-119.20194, 34.19616], [-119.20239, 34.19616], [-119.20277, 34.19597], [-119.20285, 34.19601], [-119.20295, 34.19603], [-119.20308, 34.19602], [-119.20349, 34.19603], [-119.20357, 34.19602], [-119.20365, 34.19598], [-119.20369, 34.19601], [-119.20446, 34.19602], [-119.2045, 34.19598], [-119.20458, 34.19602], [-119.20466, 34.19604], [-119.20507, 34.19603], [-119.20521, 34.19604], [-119.20535, 34.196], [-119.20545, 34.19591], [-119.20548, 34.19581], [-119.20547, 34.19562], [-119.20626, 34.19563]]]} | Open Access 1 | 1013 | Southwest Community Park | 25701 | 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 | 21.874 | Southwest Community Park | 0 | Local Park 2 | 4 | |
2919 | 2919 | 2918 | {"type": "Polygon", "coordinates": [[[-119.18881, 34.18649], [-119.18852, 34.18658], [-119.18817, 34.18662], [-119.18634, 34.1866], [-119.18629, 34.18469], [-119.18755, 34.1847], [-119.18781, 34.18466], [-119.188, 34.18462], [-119.18812, 34.18463], [-119.18819, 34.18461], [-119.18871, 34.18471], [-119.18869, 34.18626], [-119.18881, 34.18649]]]} | Open Access 1 | 19028 | Durley Park | 18316 | 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 | 11.676 | Durley 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]);