units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
663 rows where DES_TP = 14 and MNG_AG_TYP = 2 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, PARK_URL, YR_EST
MNG_AGENCY >30
- Ventura, City of 106
- Roseville, City of 46
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Napa, City of 21
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Santa Cruz, City of 12
- Oroville, City of 12
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Salinas, City of 5
- Anaheim, City of 5
- Stockton, City of 5
- San Marcos, City of 4
- Marina, City of 4
- …
ACCESS_TYP 4
- Open Access 581
- No Public Access 60
- Unknown Access 16
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 663 ✖
DES_TP 1
- Local Other or Unknown · 663 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13771 | 13771 | 13770 | {"type": "Polygon", "coordinates": [[[-124.26652, 40.57397], [-124.26609, 40.57438], [-124.26519, 40.5738], [-124.2651, 40.57372], [-124.26489, 40.57389], [-124.26428, 40.57333], [-124.26398, 40.5731], [-124.2646, 40.57245], [-124.26652, 40.57397]]]} | Open Access 1 | 36312 | Fortuna holding 1 | 19012 | 1434 | Fortuna, City of 1012 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | Humboldt 45 | 4.43 | Fortuna holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13968 | 13968 | 13967 | {"type": "Polygon", "coordinates": [[[-124.15321, 41.05423], [-124.15271, 41.05488], [-124.15229, 41.05661], [-124.15206, 41.05669], [-124.15203, 41.05709], [-124.14985, 41.05669], [-124.14873, 41.05627], [-124.14866, 41.05582], [-124.14772, 41.05465], [-124.14731, 41.05383], [-124.14725, 41.05301], [-124.14791, 41.0522], [-124.14977, 41.0522], [-124.15099, 41.05294], [-124.15272, 41.05295], [-124.15297, 41.05333], [-124.1532, 41.05337], [-124.15321, 41.05423]], [[-124.15021, 41.05434], [-124.15022, 41.05435], [-124.15082, 41.05449], [-124.15108, 41.05383], [-124.15048, 41.05369], [-124.15021, 41.05434]]]} | Open Access 1 | 36634 | Trinidad holding 1 | 26538 | 1664 | Trinidad, City of 718 | City 2 | City Agency 2 | http://www.trinidad.ca.gov/ | City 2 | 1664 | Trinidad, City of 701 | City 2 | City Agency 2 | Humboldt 45 | 45.982 | Trinidad holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13795 | 13795 | 13794 | {"type": "Polygon", "coordinates": [[[-124.14761, 40.57317], [-124.14645, 40.57224], [-124.14644, 40.5716], [-124.14561, 40.57078], [-124.14527, 40.57023], [-124.14525, 40.57021], [-124.1473, 40.57025], [-124.14761, 40.57317]]]} | Open Access 1 | 36363 | Fortuna holding 2 | 19013 | 1434 | Fortuna, City of 1012 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | Humboldt 45 | 7.731 | Fortuna holding 2 | 0 | Local Other or Unknown 14 | 4 | |
4774 | 4774 | 4773 | {"type": "Polygon", "coordinates": [[[-124.10655, 40.50715], [-124.10654, 40.50718], [-124.10649, 40.5072], [-124.10591, 40.5071], [-124.10587, 40.50708], [-124.10587, 40.50705], [-124.10588, 40.50702], [-124.10605, 40.50694], [-124.10617, 40.50686], [-124.1063, 40.50671], [-124.10635, 40.50669], [-124.1064, 40.50673], [-124.10649, 40.50701], [-124.10655, 40.50715]]]} | Open Access 1 | 46937 | Unnamed site - Rio Dell, City of | 30560 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 0.418 | 0 | Local Other or Unknown 14 | 4 | ||
4769 | 4769 | 4768 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49314], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | 46929 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 0.236 | 0 | Local Other or Unknown 14 | 4 | ||
13623 | 13623 | 13622 | {"type": "Polygon", "coordinates": [[[-123.9952, 40.88232], [-123.99346, 40.88304], [-123.99352, 40.88318], [-123.99339, 40.88307], [-123.99237, 40.8823], [-123.99232, 40.88233], [-123.99196, 40.88206], [-123.99202, 40.88201], [-123.99228, 40.88221], [-123.99325, 40.88144], [-123.9952, 40.88232]]]} | Open Access 1 | 36330 | Blue Lake holding 1 | 16178 | 1443 | Blue Lake, City of 716 | City 2 | City Agency 2 | http://bluelake.ca.gov/ | City 2 | 1443 | Blue Lake, City of 699 | City 2 | City Agency 2 | Humboldt 45 | 5.606 | Blue Lake holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4788 | 4788 | 4787 | {"type": "Polygon", "coordinates": [[[-123.69419, 38.90966], [-123.69413, 38.91095], [-123.69408, 38.91142], [-123.69342, 38.91138], [-123.69342, 38.91022], [-123.69387, 38.91002], [-123.69374, 38.90991], [-123.69342, 38.90992], [-123.69342, 38.9096], [-123.69319, 38.9096], [-123.69319, 38.90939], [-123.69351, 38.90939], [-123.69352, 38.90931], [-123.69407, 38.90932], [-123.69406, 38.90939], [-123.69388, 38.90964], [-123.69419, 38.90966]]]} | Open Access 1 | 48100 | Unnamed site - Point Arena, City of | 32605 | 1697 | Point Arena, City of 781 | City 2 | City Agency 2 | http://www.cityofpointarena.com/ | City 2 | 1697 | Point Arena, City of 761 | City 2 | City Agency 2 | Mendocino 24 | 3.377 | 0 | Local Other or Unknown 14 | 4 | ||
4639 | 4639 | 4638 | {"type": "Polygon", "coordinates": [[[-122.59352, 38.58594], [-122.59328, 38.58619], [-122.59306, 38.58597], [-122.59325, 38.58577], [-122.59352, 38.58594]]]} | Open Access 1 | 36378 | Unnamed site - Calistoga, City of | 28631 | 1042 | Calistoga, City of 774 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | Napa 11 | 0.23 | 0 | Local Other or Unknown 14 | 4 | ||
4664 | 4664 | 4663 | {"type": "Polygon", "coordinates": [[[-122.59131, 38.58052], [-122.59118, 38.58071], [-122.59058, 38.58066], [-122.59033, 38.5805], [-122.59051, 38.58045], [-122.59131, 38.58052]]]} | Open Access 1 | 36607 | Unnamed site - Calistoga, City of | 28631 | 1042 | Calistoga, City of 774 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | Napa 11 | 0.389 | 0 | Local Other or Unknown 14 | 4 | ||
1216 | 1216 | 1215 | {"type": "Polygon", "coordinates": [[[-122.58991, 38.30992], [-122.57891, 38.32201], [-122.57277, 38.31852], [-122.58368, 38.30636], [-122.58991, 38.30992]]]} | No Public Access 3 | 7007 | Lafferty Ranch | 20837 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 272.49 | Lafferty Ranch | 0 | Local Other or Unknown 14 | 4 | |
4635 | 4635 | 4634 | {"type": "Polygon", "coordinates": [[[-122.58206, 38.57942], [-122.58194, 38.57963], [-122.58178, 38.57951], [-122.58195, 38.57934], [-122.58206, 38.57942]]]} | Open Access 1 | 36333 | Unknown park - Calistoga, City of | 28689 | 1042 | Calistoga, City of 774 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | Napa 11 | 0.098 | 0 | Local Other or Unknown 14 | 4 | ||
4624 | 4624 | 4623 | {"type": "Polygon", "coordinates": [[[-122.57219, 38.57658], [-122.57184, 38.57719], [-122.57089, 38.57682], [-122.57116, 38.57631], [-122.57219, 38.57658]]]} | Open Access 1 | 36224 | Unnamed site - Calistoga, City of | 28631 | 1042 | Calistoga, City of 774 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | Napa 11 | 1.577 | 0 | Local Other or Unknown 14 | 4 | ||
13802 | 13802 | 13801 | {"type": "Polygon", "coordinates": [[[-122.54015, 37.90017], [-122.54008, 37.90023], [-122.53884, 37.89914], [-122.53877, 37.89918], [-122.53812, 37.89862], [-122.53818, 37.89859], [-122.53817, 37.89857], [-122.53707, 37.89755], [-122.53715, 37.8975], [-122.54015, 37.90017]]]} | Open Access 1 | 36371 | Mill Valley holding 1 | 22232 | 1204 | Mill Valley, City of 227 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | Marin 23 | 1.149 | Mill Valley holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13801 | 13801 | 13800 | {"type": "Polygon", "coordinates": [[[-122.52642, 37.92563], [-122.52626, 37.9274], [-122.52607, 37.92774], [-122.52598, 37.92826], [-122.52591, 37.92838], [-122.5258, 37.92848], [-122.52543, 37.92875], [-122.52519, 37.92887], [-122.52467, 37.92904], [-122.52463, 37.92737], [-122.52236, 37.92737], [-122.52236, 37.92612], [-122.52358, 37.92617], [-122.52364, 37.92551], [-122.52642, 37.92563]]]} | Open Access 1 | 36370 | Corte Madera holding 1 | 17659 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 20.201 | Corte Madera holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4790 | 4790 | 4789 | {"type": "Polygon", "coordinates": [[[-122.49889, 37.96947], [-122.49879, 37.96966], [-122.49802, 37.97002], [-122.49766, 37.97016], [-122.49731, 37.97028], [-122.49713, 37.97033], [-122.49695, 37.97036], [-122.49659, 37.97038], [-122.49622, 37.97037], [-122.49578, 37.9703], [-122.49568, 37.97019], [-122.49615, 37.96878], [-122.4984, 37.96946], [-122.49886, 37.96944], [-122.49889, 37.96947]]]} | Open Access 1 | 48141 | Unnamed site - San Rafael, City of | 32671 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 7.23 | 0 | Local Other or Unknown 14 | 4 | ||
13805 | 13805 | 13804 | {"type": "Polygon", "coordinates": [[[-122.44718, 38.28907], [-122.447, 38.29026], [-122.44655, 38.29023], [-122.44662, 38.28979], [-122.44643, 38.28956], [-122.44649, 38.28952], [-122.44655, 38.28942], [-122.4466, 38.2891], [-122.44671, 38.28903], [-122.44718, 38.28907]]]} | Open Access 1 | 36376 | Sonoma holding 1 | 25612 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 1.524 | Sonoma holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13762 | 13762 | 13761 | {"type": "Polygon", "coordinates": [[[-122.44326, 38.2855], [-122.44321, 38.28582], [-122.4422, 38.28573], [-122.44253, 38.28549], [-122.44264, 38.28551], [-122.44274, 38.2855], [-122.44281, 38.28545], [-122.44326, 38.2855]]]} | Open Access 1 | 36282 | Sonoma holding 2 | 25613 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.635 | Sonoma holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13706 | 13706 | 13705 | {"type": "Polygon", "coordinates": [[[-122.40221, 37.68489], [-122.40183, 37.68563], [-122.40176, 37.68569], [-122.40168, 37.68572], [-122.40158, 37.6857], [-122.4007, 37.68516], [-122.4005, 37.68506], [-122.40004, 37.685], [-122.40002, 37.68486], [-122.40221, 37.68489]]]} | Open Access 1 | 36302 | Brisbane holding 1 | 16400 | 1035 | Brisbane, City of 686 | City 2 | City Agency 2 | http://www.ci.brisbane.ca.us/about-parks-and-recreation | City 2 | 1035 | Brisbane, City of 677 | City 2 | City Agency 2 | San Mateo 15 | 2.326 | Brisbane holding 1 | 0 | Local Other or Unknown 14 | 4 | |
5194 | 5194 | 5193 | {"type": "Polygon", "coordinates": [[[-122.40018, 37.66434], [-122.40011, 37.66463], [-122.39923, 37.66446], [-122.39958, 37.66423], [-122.40018, 37.66434]]]} | Open Access 1 | 15580 | Gardiner Lot | 19209 | 1341 | South San Francisco, City of 60 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | San Mateo 15 | 0.528 | Gardiner Lot | 0 | Local Other or Unknown 14 | 4 | |
4647 | 4647 | 4646 | {"type": "Polygon", "coordinates": [[[-122.38148, 37.73182], [-122.38122, 37.73211], [-122.38122, 37.73223], [-122.38105, 37.73214], [-122.38098, 37.73216], [-122.3807, 37.73205], [-122.38067, 37.73203], [-122.38065, 37.73199], [-122.38066, 37.73194], [-122.38081, 37.73176], [-122.38103, 37.73152], [-122.38108, 37.7315], [-122.38114, 37.7315], [-122.38118, 37.73152], [-122.38134, 37.73167], [-122.38138, 37.73177], [-122.38148, 37.73182]]]} | Open Access 1 | 36528 | Unnamed site - San Francisco, City of | 28697 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.816 | 0 | Local Other or Unknown 14 | 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]);