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 ACCESS_TYP
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Ventura, City of 101
- Roseville, City of 43
- Poway, City of 34
- Irvine, City of 29
- Los Angeles, City of 24
- California City, City of 23
- Encinitas, City of 21
- Napa, City of 21
- Rocklin, City of 17
- Seaside, City of 16
- Lompoc, City of 13
- Santa Cruz, City of 12
- San Diego, City of 11
- Santa Barbara, City of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Mammoth Lakes, Town of 10
- Santa Maria, City of 9
- Escondido, City of 9
- Oroville, City of 9
- Scotts Valley, City of 7
- Watsonville, City of 6
- Torrance, City of 6
- San Luis Obispo, City of 5
- Salinas, City of 5
- Stockton, City of 5
- Anaheim, City of 4
- San Marcos, City of 4
- Marina, City of 4
- Los Angeles - Department of Water and Power, City of 4
- …
ACCESS_TYP 4
- Open Access 541
- No Public Access 60
- Unknown Access 16
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 623 ✖
DES_TP 1
- Local Other or Unknown · 623 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4581 | 4581 | 4580 | {"type": "Polygon", "coordinates": [[[-120.68305, 35.25007], [-120.68298, 35.25011], [-120.68277, 35.25009], [-120.68274, 35.25012], [-120.68269, 35.25007], [-120.68285, 35.24982], [-120.68305, 35.25007]]]} | Open Access 1 | 35336 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.137 | 0 | Local Other or Unknown 14 | 4 | ||
4584 | 4584 | 4583 | {"type": "MultiPolygon", "coordinates": [[[[-119.29299, 34.28177], [-119.29297, 34.28184], [-119.29281, 34.28191], [-119.29269, 34.28203], [-119.29249, 34.28203], [-119.29249, 34.28177], [-119.29299, 34.28177]]], [[[-119.29359, 34.28203], [-119.29355, 34.28202], [-119.2935, 34.28196], [-119.29342, 34.2819], [-119.29328, 34.28185], [-119.29326, 34.28181], [-119.29325, 34.28176], [-119.29359, 34.28175], [-119.29359, 34.28203]]]]} | Open Access 1 | 35403 | Unknown park - Ventura, City of | 30393 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.37 | 0 | Local Other or Unknown 14 | 4 | ||
4596 | 4596 | 4595 | {"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28304, 33.04495], [-117.28303, 33.04494], [-117.28298, 33.04494], [-117.28297, 33.04495], [-117.28295, 33.04495], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]} | Open Access 1 | 35531 | Unknown park - Encinitas, City of | 28635 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.21 | 0 | Local Other or Unknown 14 | 4 | ||
4597 | 4597 | 4596 | {"type": "Polygon", "coordinates": [[[-117.18544, 33.1626], [-117.18544, 33.16267], [-117.18537, 33.16299], [-117.18467, 33.1629], [-117.18466, 33.16288], [-117.18471, 33.16253], [-117.18544, 33.1626]]]} | Open Access 1 | 35551 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.736 | 0 | Local Other or Unknown 14 | 4 | ||
4614 | 4614 | 4613 | {"type": "Polygon", "coordinates": [[[-117.14137, 33.15374], [-117.14114, 33.15399], [-117.1411, 33.154], [-117.14106, 33.154], [-117.14103, 33.15398], [-117.14101, 33.15395], [-117.14087, 33.15347], [-117.14094, 33.15346], [-117.14137, 33.15374]]]} | Open Access 1 | 35852 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.339 | 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 | ||
4631 | 4631 | 4630 | {"type": "MultiPolygon", "coordinates": [[[[-122.34618, 38.30909], [-122.34596, 38.30934], [-122.34614, 38.30944], [-122.34597, 38.30955], [-122.34589, 38.30957], [-122.34581, 38.30954], [-122.34512, 38.30898], [-122.34519, 38.30876], [-122.34544, 38.30879], [-122.34534, 38.30904], [-122.34535, 38.30905], [-122.34567, 38.30906], [-122.34612, 38.30899], [-122.34618, 38.30909]]], [[[-122.3487, 38.31069], [-122.34864, 38.31088], [-122.34806, 38.31077], [-122.34714, 38.31048], [-122.34688, 38.31036], [-122.34665, 38.31022], [-122.34613, 38.30976], [-122.3461, 38.30972], [-122.34611, 38.30968], [-122.34617, 38.30961], [-122.34625, 38.30956], [-122.34634, 38.30965], [-122.34665, 38.30968], [-122.34674, 38.30993], [-122.34686, 38.31013], [-122.34726, 38.31024], [-122.3475, 38.31039], [-122.34763, 38.31031], [-122.34789, 38.31053], [-122.34805, 38.31036], [-122.34821, 38.31049], [-122.34838, 38.31044], [-122.34859, 38.31072], [-122.3487, 38.31069]]]]} | Open Access 1 | 36294 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.657 | 0 | Local Other or Unknown 14 | 4 | ||
4632 | 4632 | 4631 | {"type": "Polygon", "coordinates": [[[-122.27703, 38.31682], [-122.27674, 38.3171], [-122.27647, 38.31702], [-122.27594, 38.31695], [-122.27565, 38.31688], [-122.27558, 38.31653], [-122.27581, 38.31638], [-122.27597, 38.3162], [-122.27656, 38.31622], [-122.27679, 38.31615], [-122.27678, 38.31633], [-122.27683, 38.31652], [-122.27691, 38.31667], [-122.27703, 38.31682]]]} | Open Access 1 | 36315 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.219 | 0 | Local Other or Unknown 14 | 4 | ||
4634 | 4634 | 4633 | {"type": "Polygon", "coordinates": [[[-122.27749, 38.30276], [-122.27737, 38.30283], [-122.27718, 38.30304], [-122.27707, 38.30306], [-122.27701, 38.30305], [-122.27692, 38.30298], [-122.27666, 38.3027], [-122.27686, 38.3028], [-122.27706, 38.30284], [-122.27729, 38.30283], [-122.27735, 38.30281], [-122.27736, 38.30279], [-122.27749, 38.30276]]]} | Open Access 1 | 36319 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.235 | 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 | ||
4636 | 4636 | 4635 | {"type": "Polygon", "coordinates": [[[-122.34106, 38.30681], [-122.341, 38.30679], [-122.34093, 38.30667], [-122.34086, 38.30658], [-122.34045, 38.3062], [-122.34007, 38.30593], [-122.33968, 38.30568], [-122.33914, 38.3054], [-122.3391, 38.30534], [-122.33912, 38.30527], [-122.33923, 38.30535], [-122.33938, 38.3054], [-122.33952, 38.30542], [-122.33961, 38.30547], [-122.33966, 38.30552], [-122.3398, 38.30569], [-122.33993, 38.3058], [-122.34012, 38.30586], [-122.34049, 38.30593], [-122.34063, 38.30599], [-122.34068, 38.30605], [-122.34073, 38.30625], [-122.3408, 38.30635], [-122.34083, 38.30638], [-122.34091, 38.30639], [-122.34105, 38.30635], [-122.34106, 38.30681]]]} | Open Access 1 | 36336 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.856 | 0 | Local Other or Unknown 14 | 4 | ||
4637 | 4637 | 4636 | {"type": "Polygon", "coordinates": [[[-122.31969, 38.31537], [-122.31968, 38.3154], [-122.31965, 38.31542], [-122.31947, 38.31545], [-122.31931, 38.31498], [-122.31956, 38.31521], [-122.31969, 38.31537]]]} | Open Access 1 | 36337 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.169 | 0 | Local Other or Unknown 14 | 4 | ||
4638 | 4638 | 4637 | {"type": "Polygon", "coordinates": [[[-122.2977, 38.32825], [-122.2972, 38.3285], [-122.29663, 38.32864], [-122.29655, 38.32859], [-122.29758, 38.3281], [-122.2977, 38.32825]]]} | Open Access 1 | 36340 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.452 | 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 | ||
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 | ||
4656 | 4656 | 4655 | {"type": "Polygon", "coordinates": [[[-120.65374, 35.27663], [-120.65364, 35.27676], [-120.65352, 35.27662], [-120.65365, 35.27654], [-120.65374, 35.27663]]]} | Open Access 1 | 36580 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.06 | 0 | Local Other or Unknown 14 | 4 | ||
4660 | 4660 | 4659 | {"type": "Polygon", "coordinates": [[[-118.445, 34.26558], [-118.44458, 34.26545], [-118.44422, 34.26529], [-118.4438, 34.26504], [-118.44347, 34.26478], [-118.44336, 34.26486], [-118.44333, 34.26484], [-118.44307, 34.26456], [-118.44309, 34.26422], [-118.44317, 34.26385], [-118.445, 34.26558]]]} | Open Access 1 | 36591 | Unnamed site - Los Angeles, City of | 28718 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.286 | 0 | Local Other or Unknown 14 | 4 | ||
4662 | 4662 | 4661 | {"type": "Polygon", "coordinates": [[[-122.28082, 38.28098], [-122.27751, 38.28071], [-122.27753, 38.28051], [-122.28081, 38.28064], [-122.28082, 38.28098]]]} | Open Access 1 | 36601 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.159 | 0 | Local Other or Unknown 14 | 4 | ||
4663 | 4663 | 4662 | {"type": "Polygon", "coordinates": [[[-122.31677, 38.29327], [-122.31482, 38.29396], [-122.31422, 38.29403], [-122.31412, 38.29363], [-122.31425, 38.29329], [-122.31436, 38.29316], [-122.3144, 38.29308], [-122.3144, 38.29298], [-122.31651, 38.29297], [-122.31651, 38.29326], [-122.31677, 38.29327]]]} | Open Access 1 | 36605 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 4.243 | 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 |
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]);