units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2, COUNTY = 17 and LAYER = 9
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, MNG_AG_LEV, YR_EST
DES_TP 4
- State Recreation Area 1
- None 1
- None 1
- None 1
MNG_AG_TYP 2
ACCESS_TYP 1
- Restricted Access · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12466 | 12466 | 12465 | {"type": "Polygon", "coordinates": [[[-122.31807, 37.82977], [-122.3145, 37.83558], [-122.31384, 37.83676], [-122.31367, 37.83701], [-122.30448, 37.837], [-122.30448, 37.83642], [-122.30311, 37.83642], [-122.3031, 37.83648], [-122.30259, 37.83653], [-122.3021, 37.83672], [-122.30152, 37.83669], [-122.30051, 37.83676], [-122.29922, 37.83705], [-122.29895, 37.83704], [-122.29802, 37.83651], [-122.29744, 37.83499], [-122.29694, 37.83457], [-122.29688, 37.8339], [-122.29615, 37.83373], [-122.29546, 37.83375], [-122.29554, 37.83363], [-122.29611, 37.83345], [-122.29659, 37.83311], [-122.29672, 37.8329], [-122.29619, 37.83224], [-122.29627, 37.83193], [-122.29587, 37.83155], [-122.29613, 37.83127], [-122.29629, 37.83082], [-122.29615, 37.83062], [-122.29632, 37.83055], [-122.29641, 37.83044], [-122.29629, 37.83016], [-122.29573, 37.82964], [-122.29595, 37.82963], [-122.29654, 37.82997], [-122.29727, 37.83023], [-122.29786, 37.83006], [-122.29816, 37.83018], [-122.2983, 37.82971], [-122.2982, 37.82942], [-122.29796, 37.82915], [-122.29825, 37.82843], [-122.29849, 37.82846], [-122.29865, 37.82825], [-122.29901, 37.82821], [-122.29925, 37.8278], [-122.30112, 37.82678], [-122.3011, 37.82645], [-122.30548, 37.82556], [-122.30748, 37.82592], [-122.30868, 37.82589], [-122.31807, 37.82977]]]} | Restricted Access 2 | 28130 | McLaughlin Eastshore State Park | 29198 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Alameda 17 | 456.308 | McLaughlin Eastshore SP | None 1084 | ||
12606 | 12606 | 12605 | {"type": "MultiPolygon", "coordinates": [[[[-122.31376, 37.89702], [-122.31276, 37.89724], [-122.3125, 37.89694], [-122.31163, 37.89607], [-122.31036, 37.89455], [-122.31003, 37.89409], [-122.30983, 37.89374], [-122.30966, 37.89338], [-122.30945, 37.89281], [-122.30928, 37.89225], [-122.30916, 37.89226], [-122.30913, 37.89207], [-122.30909, 37.89161], [-122.3091, 37.89106], [-122.30915, 37.89066], [-122.3093, 37.8898], [-122.30997, 37.89189], [-122.31013, 37.89227], [-122.31036, 37.89272], [-122.31064, 37.89313], [-122.31376, 37.89702]]], [[[-122.32444, 37.89221], [-122.32262, 37.89493], [-122.32102, 37.89532], [-122.32101, 37.89498], [-122.31872, 37.89504], [-122.31871, 37.89587], [-122.31644, 37.89642], [-122.31394, 37.89698], [-122.31081, 37.89309], [-122.31056, 37.89272], [-122.31042, 37.89247], [-122.31022, 37.89207], [-122.31011, 37.89177], [-122.30943, 37.88963], [-122.30934, 37.88963], [-122.30949, 37.88875], [-122.30955, 37.8886], [-122.30959, 37.88857], [-122.30966, 37.88854], [-122.30979, 37.88855], [-122.30993, 37.88863], [-122.31022, 37.88909], [-122.31037, 37.88923], [-122.31047, 37.88963], [-122.31333, 37.88964], [-122.31334, 37.88985], [-122.312, 37.88997], [-122.31197, 37.89022], [-122.31394, 37.8917], [-122.31624, 37.89169], [-122.31634, 37.8909], [-122.31763, 37.89086], [-122.31991, 37.88993], [-122.32312, 37.8899], [-122.32356, 37.8913], [-122.32409, 37.89131], [-122.32444, 37.89221]]]]} | Restricted Access 2 | 29272 | Albany State Marine Reserve | 30562 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 181.83 | Albany State Marine Reserve | 1985 | None 1092 | ||
12997 | 12997 | 12996 | {"type": "Polygon", "coordinates": [[[-122.3031, 37.83648], [-122.3031, 37.837], [-122.30105, 37.837], [-122.2977, 37.83767], [-122.29768, 37.83765], [-122.29741, 37.8377], [-122.29731, 37.83767], [-122.2972, 37.83753], [-122.29701, 37.83713], [-122.29573, 37.83491], [-122.29545, 37.83431], [-122.29554, 37.83429], [-122.29554, 37.83428], [-122.2955, 37.83419], [-122.29541, 37.83422], [-122.29463, 37.83251], [-122.29457, 37.8323], [-122.29463, 37.83228], [-122.29454, 37.83192], [-122.29448, 37.83192], [-122.29442, 37.83131], [-122.29443, 37.83091], [-122.29455, 37.82968], [-122.29459, 37.82943], [-122.29471, 37.82908], [-122.29486, 37.82876], [-122.29532, 37.82895], [-122.2954, 37.82883], [-122.29539, 37.82882], [-122.29494, 37.82864], [-122.29515, 37.82836], [-122.29537, 37.82813], [-122.29566, 37.82789], [-122.29604, 37.82765], [-122.2964, 37.82748], [-122.29679, 37.82734], [-122.29713, 37.82725], [-122.3011, 37.82645], [-122.30112, 37.82678], [-122.29925, 37.8278], [-122.29901, 37.82821], [-122.29865, 37.82825], [-122.29849, 37.82846], [-122.29825, 37.82844], [-122.29796, 37.82915], [-122.2982, 37.82942], [-122.2983, 37.82971], [-122.29816, 37.83018], [-122.29786, 37.83006], [-122.29727, 37.83023], [-122.29654, 37.82997], [-122.29596, 37.82963], [-122.29574, 37.82964], [-122.29629, 37.83016], [-122.29641, 37.83044], [-122.29632, 37.83055], [-122.29616, 37.83062], [-122.29629, 37.83081], [-122.29613, 37.83127], [-122.29587, 37.83155], [-122.29628, 37.83193], [-122.29619, 37.83224], [-122.29672, 37.8329], [-122.29659, 37.83311], [-122.29611, 37.83345], [-122.29554, 37.83363], [-122.29547, 37.83374], [-122.29615, 37.83373], [-122.29688, 37.8339], [-122.29694, 37.83457], [-122.29744, 37.83499], [-122.29802, 37.83651], [-122.29895, 37.83704], [-122.29922, 37.83705], [-122.30051, 37.83676], [-122.30152, 37.83669], [-122.3021, 37.83672], [-122.30259, 37.83653], [-122.3031, 37.83648]]]} | Restricted Access 2 | 46940 | Emeryville Crescent State Marine Reserve | 30564 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 58.981 | Emeryville Crescent State Marine Reserve | 1985 | None 1127 | ||
16688 | 16688 | 16687 | {"type": "MultiPolygon", "coordinates": [[[[-121.63315, 37.64335], [-121.63279, 37.64354], [-121.63119, 37.64418], [-121.63057, 37.64447], [-121.63043, 37.64468], [-121.6299, 37.64486], [-121.6299, 37.64487], [-121.63006, 37.64497], [-121.63002, 37.64507], [-121.62922, 37.64539], [-121.62826, 37.64573], [-121.62691, 37.6458], [-121.62516, 37.64599], [-121.62365, 37.64629], [-121.62244, 37.64643], [-121.62214, 37.64651], [-121.62194, 37.6466], [-121.62173, 37.64676], [-121.62146, 37.64691], [-121.6207, 37.64726], [-121.62042, 37.6474], [-121.61916, 37.64814], [-121.61877, 37.64833], [-121.61798, 37.64868], [-121.61776, 37.64881], [-121.61748, 37.64901], [-121.61629, 37.64942], [-121.61606, 37.64953], [-121.61546, 37.64993], [-121.61533, 37.65003], [-121.61518, 37.65021], [-121.61513, 37.65033], [-121.6151, 37.65043], [-121.61301, 37.6504], [-121.61269, 37.65007], [-121.61244, 37.64986], [-121.6122, 37.64971], [-121.61168, 37.64944], [-121.61131, 37.64928], [-121.61086, 37.64912], [-121.61072, 37.64903], [-121.61065, 37.64895], [-121.61061, 37.64888], [-121.61055, 37.64863], [-121.61056, 37.64847], [-121.61063, 37.64829], [-121.61065, 37.64816], [-121.61063, 37.64801], [-121.61056, 37.64787], [-121.6104, 37.64773], [-121.61002, 37.64752], [-121.60982, 37.64745], [-121.60955, 37.64741], [-121.60932, 37.64743], [-121.60918, 37.64745], [-121.60859, 37.64765], [-121.60841, 37.64776], [-121.60835, 37.64783], [-121.60829, 37.64792], [-121.60802, 37.64928], [-121.60802, 37.64939], [-121.60805, 37.64948], [-121.60817, 37.64971], [-121.60823, 37.64993], [-121.60823, 37.65016], [-121.60819, 37.65031], [-121.60817, 37.65033], [-121.60554, 37.65029], [-121.60101, 37.65028], [-121.60085, 37.65019], [-121.60074, 37.65007], [-121.6007, 37.64994], [-121.60072, 37.64979], [-121.60077, 37.64972], [-121.60091, 37.64963], [-121.60108, 37.64957], [-121.60133, 37.64953], [-121.60146, 37.6495], [-121.6016, 37.64943], [-121.60173, 37.64932], [-121.60183, 37.64917], [-121.60187, 37.64902], [-121.60185, 37.64886], [-121.60179, 37.64872], [-121.60167, 37.64861], [-121.60153, 37.64855], [-121.5997, 37.6484], [-121.59955, 37.64835], [-121.59939, 37.64827], [-121.59924, 37.64818], [-121.59913, 37.64807], [-121.59903, 37.64794], [-121.59882, 37.64757], [-121.5988, 37.64746], [-121.59881, 37.64736], [-121.59884, 37.64721], [-121.59891, 37.64706], [-121.59905, 37.64688], [-121.59907, 37.64679], [-121.59907, 37.6467], [-121.59901, 37.64658], [-121.59887, 37.64644], [-121.59879, 37.64631], [-121.59863, 37.6457], [-121.59845, 37.64541], [-121.59843, 37.64523], [-121.59848, 37.64498], [-121.59844, 37.64484], [-121.59837, 37.64477], [-121.59818, 37.64464], [-121.59808, 37.64454], [-121.59802, 37.64442], [-121.59797, 37.6442], [-121.59793, 37.64412], [-121.59787, 37.64405], [-121.59686, 37.64345], [-121.59666, 37.64328], [-121.59655, 37.64315], [-121.59599, 37.64223], [-121.59585, 37.64204], [-121.59569, 37.64188], [-121.59554, 37.64176], [-121.59485, 37.64133], [-121.59467, 37.64119], [-121.5945, 37.64099], [-121.59427, 37.64065], [-121.59421, 37.64052], [-121.59411, 37.64041], [-121.594, 37.64034], [-121.5939, 37.6403], [-121.59381, 37.64028], [-121.59365, 37.64027], [-121.59307, 37.64039], [-121.59267, 37.64051], [-121.59248, 37.64059], [-121.59224, 37.64072], [-121.59174, 37.64125], [-121.59162, 37.64135], [-121.59144, 37.64145], [-121.59126, 37.6415], [-121.59103, 37.64153], [-121.59084, 37.64151], [-121.58975, 37.64127], [-121.5895, 37.64114], [-121.58844, 37.64035], [-121.58828, 37.64026], [-121.58812, 37.64021], [-121.58795, 37.64018], [-121.58675, 37.63988], [-121.58625, 37.63969], [-121.58591, 37.63952], [-121.58626, 37.63876], [-121.58647, 37.6376], [-121.58578, 37.63733], [-121.5853, 37.63725], [-121.58475, 37.63904], [-121.58125, 37.63841], [-121.58095, 37.63837], [-121.58023, 37.63833], [-121.5808, 37.63644], [-121.57877, 37.63615], [-121.5782, 37.63798], [-121.577, 37.6377], [-121.57571, 37.63751], [-121.57448, 37.63754], [-121.57424, 37.63758], [-121.57346, 37.63776], [-121.57311, 37.63786], [-121.57169, 37.63838], [-121.57169, 37.63624], [-121.57146, 37.6361], [-121.57128, 37.63606], [-121.57114, 37.63607], [-121.57099, 37.6361], [-121.57076, 37.63624], [-121.57067, 37.63635], [-121.57061, 37.63651], [-121.5706, 37.63872], [-121.5704, 37.63878], [-121.57018, 37.63879], [-121.56976, 37.63874], [-121.5693, 37.63861], [-121.56875, 37.63839], [-121.56763, 37.63785], [-121.5638, 37.63691], [-121.56162, 37.63659], [-121.55909, 37.63636], [-121.55729, 37.63602], [-121.55719, 37.62034], [-121.5584, 37.62065], [-121.57076, 37.62095], [-121.57114, 37.62135], [-121.57194, 37.62208], [-121.57211, 37.6227], [-121.57269, 37.62315], [-121.57303, 37.62355], [-121.57348, 37.62369], [-121.57357, 37.62382], [-121.57462, 37.62338], [-121.57431, 37.62292], [-121.57378, 37.62276], [-121.57355, 37.6225], [-121.57319, 37.62222], [-121.573, 37.62147], [-121.57279, 37.62139], [-121.57221, 37.62098], [-121.58753, 37.62133], [-121.58739, 37.60781], [-121.60578, 37.60802], [-121.60564, 37.62145], [-121.61113, 37.62148], [-121.61116, 37.63585], [-121.62366, 37.63608], [-121.62366, 37.64326], [-121.63315, 37.64335]]], [[[-121.59535, 37.65026], [-121.58738, 37.65023], [-121.5874, 37.64329], [-121.577, 37.64309], [-121.57506, 37.63858], [-121.5749, 37.6377], [-121.57569, 37.63769], [-121.57685, 37.63785], [-121.5771, 37.63789], [-121.57932, 37.63842], [-121.57982, 37.63848], [-121.58088, 37.63854], [-121.58121, 37.63857], [-121.58481, 37.63929], [-121.58504, 37.63936], [-121.58529, 37.63946], [-121.5859, 37.63981], [-121.58632, 37.64], [-121.58807, 37.64051], [-121.5882, 37.64056], [-121.58837, 37.64065], [-121.58947, 37.64144], [-121.58967, 37.64155], [-121.58986, 37.64161], [-121.5909, 37.64183], [-121.59111, 37.64184], [-121.59132, 37.64182], [-121.59137, 37.64387], [-121.59141, 37.64467], [-121.59202, 37.64823], [-121.59234, 37.64851], [-121.59329, 37.64875], [-121.59393, 37.64908], [-121.59438, 37.64926], [-121.59491, 37.64983], [-121.59535, 37.65026]]], [[[-121.61271, 37.6504], [-121.60843, 37.65033], [-121.60847, 37.65024], [-121.60848, 37.65016], [-121.60848, 37.64988], [-121.60842, 37.64968], [-121.60828, 37.64942], [-121.60826, 37.64928], [-121.60851, 37.64802], [-121.60854, 37.64795], [-121.60861, 37.64788], [-121.60871, 37.64782], [-121.60923, 37.64765], [-121.60945, 37.64761], [-121.60964, 37.64762], [-121.60984, 37.64767], [-121.61023, 37.64788], [-121.61034, 37.64797], [-121.6104, 37.64809], [-121.6104, 37.6482], [-121.61031, 37.64846], [-121.6103, 37.64863], [-121.61038, 37.64896], [-121.61051, 37.64914], [-121.61061, 37.64922], [-121.61072, 37.64928], [-121.61138, 37.64953], [-121.61196, 37.64981], [-121.61218, 37.64995], [-121.61239, 37.6501], [-121.61271, 37.6504]]]]} | Restricted Access 2 | 23048 | Carnegie State Vehicular Recreation Area | 16885 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Alameda 17 | 3858.038 | Carnegie SVRA | 1979 | State Recreation Area 39 | 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]);