units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where ACCESS_TYP = 2 and DES_TP = 14 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY 11
- Los Angeles, County of 1
- San Francisco - Public Utilities Commission, City and County of 1
- Monterey Peninsula Regional Park District 1
- Hayward Area Recreation and Park District 1
- Los Angeles County Flood Control District 1
- Vallejo, City of 1
- Sacramento, County of 1
- Humboldt, County of 1
- Truckee Tahoe Airport District 1
- Borrego Water District 1
- Orange County Department of Education, County of 1
MNG_AG_TYP 7
DES_TP 1
- Local Other or Unknown · 11 ✖
ACCESS_TYP 1
- Restricted Access · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | 46661 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 19.487 | 0 | Local Other or Unknown 14 | 4 | ||
4694 | 4694 | 4693 | {"type": "Polygon", "coordinates": [[[-117.90308, 34.64234], [-117.90298, 34.64592], [-117.89442, 34.64592], [-117.89406, 34.64594], [-117.89415, 34.64234], [-117.89864, 34.64232], [-117.90308, 34.64234]]]} | Restricted Access 2 | 45942 | Unnamed site - Los Angeles, County of | 29046 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 80.519 | 0 | Local Other or Unknown 14 | 4 | ||
4692 | 4692 | 4691 | {"type": "Polygon", "coordinates": [[[-118.35865, 34.26614], [-118.35827, 34.26807], [-118.35695, 34.26791], [-118.35657, 34.2683], [-118.35593, 34.26829], [-118.35637, 34.26785], [-118.35636, 34.26783], [-118.35538, 34.26771], [-118.35584, 34.26829], [-118.35539, 34.26829], [-118.35538, 34.2683], [-118.3577, 34.27107], [-118.35758, 34.2717], [-118.35674, 34.27179], [-118.3562, 34.272], [-118.35591, 34.27203], [-118.35491, 34.27184], [-118.35328, 34.27158], [-118.35331, 34.27145], [-118.35321, 34.27142], [-118.35327, 34.27106], [-118.35311, 34.27121], [-118.35307, 34.27142], [-118.35297, 34.27141], [-118.35294, 34.27154], [-118.35225, 34.27148], [-118.3521, 34.27136], [-118.35132, 34.27105], [-118.35025, 34.27136], [-118.35001, 34.27136], [-118.34913, 34.27125], [-118.34883, 34.27106], [-118.34638, 34.27079], [-118.3461, 34.27079], [-118.34579, 34.27083], [-118.34487, 34.27088], [-118.34383, 34.27067], [-118.34275, 34.27038], [-118.34297, 34.2702], [-118.34461, 34.26985], [-118.34448, 34.26941], [-118.34405, 34.26957], [-118.34268, 34.26987], [-118.34194, 34.26956], [-118.34228, 34.26782], [-118.33932, 34.26743], [-118.33933, 34.26732], [-118.33824, 34.26717], [-118.33809, 34.26706], [-118.33774, 34.26708], [-118.33774, 34.2671], [-118.33771, 34.26708], [-118.33752, 34.26709], [-118.33678, 34.26627], [-118.33684, 34.26622], [-118.33636, 34.26564], [-118.33801, 34.26554], [-118.33802, 34.26556], [-118.33921, 34.26572], [-118.3404, 34.26577], [-118.34054, 34.26507], [-118.34096, 34.26513], [-118.34096, 34.26515], [-118.34167, 34.26525], [-118.34171, 34.26509], [-118.34256, 34.26511], [-118.34257, 34.26507], [-118.34282, 34.26507], [-118.34299, 34.26424], [-118.34363, 34.26427], [-118.34414, 34.26432], [-118.34481, 34.26442], [-118.34531, 34.26452], [-118.34609, 34.26472], [-118.3483, 34.26542], [-118.34897, 34.26558], [-118.34944, 34.26565], [-118.35413, 34.26605], [-118.35603, 34.26619], [-118.35857, 34.26622], [-118.35865, 34.26614]]]} | Restricted Access 2 | 45521 | Unnamed - Los Angeles County Flood Control District | 30959 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/wrd/Projects/BTWMA/index.cfm | Los Angeles 6 | 242.496 | 0 | Local Other or Unknown 14 | 4 | |
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
4519 | 4519 | 4518 | {"type": "Polygon", "coordinates": [[[-117.6523, 33.73705], [-117.6424, 33.73701], [-117.64238, 33.73346], [-117.64935, 33.7315], [-117.65064, 33.73322], [-117.652, 33.73296], [-117.65104, 33.73389], [-117.6515, 33.73494], [-117.6523, 33.73705]]]} | Restricted Access 2 | 12713 | Unnamed site - Orange County Department of Education, County of | 28651 | 313 | Orange County Department of Education, County of 770 | County 3 | County Agency - Other 9 | http://www.ocde.us/ | County 3 | 313 | Orange County Department of Education, County of 751 | County 3 | County Agency - Other 8 | Orange 3 | 105.765 | 0 | Local Other or Unknown 14 | 4 | ||
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
3741 | 3741 | 3740 | {"type": "Polygon", "coordinates": [[[-121.909, 36.51865], [-121.90875, 36.51885], [-121.90885, 36.51911], [-121.90865, 36.51936], [-121.90826, 36.5196], [-121.90811, 36.51967], [-121.90807, 36.51973], [-121.90716, 36.52011], [-121.90656, 36.52042], [-121.90615, 36.52045], [-121.90555, 36.52056], [-121.90501, 36.52079], [-121.9046, 36.52107], [-121.90365, 36.52139], [-121.9025, 36.52232], [-121.90225, 36.5224], [-121.90144, 36.52252], [-121.90107, 36.52238], [-121.90084, 36.52241], [-121.90066, 36.52256], [-121.90048, 36.52259], [-121.89827, 36.52246], [-121.89696, 36.52232], [-121.89571, 36.51565], [-121.8964, 36.51259], [-121.89768, 36.51305], [-121.89768, 36.5118], [-121.90218, 36.51185], [-121.90218, 36.50821], [-121.90668, 36.50827], [-121.90669, 36.51191], [-121.90662, 36.51654], [-121.909, 36.51865]]]} | Restricted Access 2 | 44849 | Whisler-Wilson Ranch | 28252 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 306.464 | Whisler-Wilson Ranch | 0 | Local Other or Unknown 14 | 4 | |
3586 | 3586 | 3585 | {"type": "Polygon", "coordinates": [[[-120.11203, 39.33019], [-120.08116, 39.33018], [-120.08102, 39.32357], [-120.08615, 39.32375], [-120.08611, 39.31645], [-120.10961, 39.31639], [-120.10962, 39.32423], [-120.10845, 39.3243], [-120.10845, 39.32716], [-120.11194, 39.32719], [-120.11203, 39.33019]]]} | Restricted Access 2 | 37007 | Waddle Ranch | 27205 | 2329 | Truckee Tahoe Airport District 663 | Special District 4 | Community Services District 19 | http://www.truckeetahoeairport.com/ | Special District 4 | 2329 | Truckee Tahoe Airport District 651 | Special District 4 | Community Services District 17 | Nevada 30 | 851.88 | Waddle Ranch | 0 | Local Other or Unknown 14 | 4 | |
2719 | 2719 | 2718 | {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} | Restricted Access 2 | 18348 | Oliver Property | 23136 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 118.291 | Oliver Property | 1977 | Local Other or Unknown 14 | 4 | |
2551 | 2551 | 2550 | {"type": "Polygon", "coordinates": [[[-122.19184, 38.13515], [-122.19158, 38.13526], [-122.19131, 38.13478], [-122.19123, 38.13468], [-122.19099, 38.1342], [-122.19079, 38.13407], [-122.19041, 38.13416], [-122.1903, 38.13436], [-122.18981, 38.13471], [-122.18936, 38.13477], [-122.18846, 38.13375], [-122.18772, 38.13324], [-122.18704, 38.13336], [-122.18679, 38.13315], [-122.18649, 38.13293], [-122.18554, 38.13206], [-122.1861, 38.13174], [-122.18524, 38.13097], [-122.18589, 38.13091], [-122.18631, 38.13097], [-122.18726, 38.13107], [-122.18796, 38.13157], [-122.18847, 38.13188], [-122.18936, 38.13246], [-122.19034, 38.13316], [-122.19067, 38.13331], [-122.1909, 38.13352], [-122.19133, 38.13422], [-122.19156, 38.13457], [-122.19184, 38.13515]]]} | Restricted Access 2 | 17806 | McIntyre Ranch | 22040 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 23.753 | McIntyre Ranch | 0 | Local Other or Unknown 14 | 4 | |
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 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]);