units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where LAYER = 9 and MNG_AG_ID = 2032 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
DES_TP 6
- Local Park 1
- Local Recreation Area 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
13066 | 13066 | 13065 | {"type": "Polygon", "coordinates": [[[-121.74145, 37.61399], [-121.74132, 37.61413], [-121.74116, 37.61418], [-121.74067, 37.61426], [-121.74045, 37.61437], [-121.74047, 37.61426], [-121.74145, 37.61399]]]} | Open Access 1 | 34939 | Lake Del Valle SRA | 1594 | 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.parks.ca.gov/?page_id=537 | Alameda 17 | 0.204 | Lake Del Valle SRA | 2000 | None 1132 | |
16547 | 16547 | 16546 | {"type": "MultiPolygon", "coordinates": [[[[-122.32, 37.89774], [-122.31954, 37.89799], [-122.31891, 37.89855], [-122.31905, 37.89825], [-122.31963, 37.89787], [-122.32, 37.89774]]], [[[-122.32553, 37.89867], [-122.3253, 37.89925], [-122.32527, 37.89971], [-122.32522, 37.89971], [-122.32521, 37.89938], [-122.32487, 37.89938], [-122.32487, 37.89924], [-122.32464, 37.89867], [-122.32456, 37.89855], [-122.3243, 37.8983], [-122.32386, 37.89801], [-122.32482, 37.89704], [-122.32226, 37.89542], [-122.32129, 37.89638], [-122.32156, 37.89656], [-122.32103, 37.89709], [-122.32103, 37.89664], [-122.32117, 37.8962], [-122.32142, 37.89597], [-122.32151, 37.89571], [-122.32216, 37.8953], [-122.32275, 37.89529], [-122.32298, 37.89561], [-122.32319, 37.89586], [-122.32496, 37.89698], [-122.32459, 37.89744], [-122.32537, 37.89797], [-122.32535, 37.89834], [-122.32553, 37.89867]]], [[[-122.3261, 37.90816], [-122.32595, 37.90814], [-122.32579, 37.90809], [-122.32458, 37.9076], [-122.3235, 37.90705], [-122.32313, 37.90684], [-122.3228, 37.9066], [-122.32235, 37.90632], [-122.32211, 37.90606], [-122.32159, 37.90561], [-122.32125, 37.90533], [-122.32088, 37.90498], [-122.3203, 37.90434], [-122.31987, 37.90381], [-122.32522, 37.90109], [-122.32523, 37.90161], [-122.32526, 37.90164], [-122.32525, 37.90223], [-122.32528, 37.90303], [-122.32537, 37.9072], [-122.3261, 37.90816]]], [[[-122.3256, 37.90938], [-122.32441, 37.90871], [-122.32387, 37.90873], [-122.32346, 37.90851], [-122.32331, 37.90864], [-122.32054, 37.90518], [-122.32029, 37.90492], [-122.31957, 37.90397], [-122.32022, 37.90468], [-122.32039, 37.90483], [-122.32094, 37.9054], [-122.32145, 37.90584], [-122.32205, 37.90627], [-122.32317, 37.90701], [-122.32432, 37.90764], [-122.32454, 37.90774], [-122.32475, 37.9078], [-122.32557, 37.90811], [-122.3256, 37.90938]]]]} | Open Access 1 | 35120 | McLaughlin Eastshore State Park | 29199 | 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 | Contra Costa 12 | 69.746 | McLaughlin Eastshore SP | 0 | None 1413 | |
16592 | 16592 | 16591 | {"type": "Polygon", "coordinates": [[[-122.32764, 37.88931], [-122.32767, 37.88943], [-122.3277, 37.88994], [-122.32777, 37.89025], [-122.32775, 37.89047], [-122.32776, 37.8908], [-122.32755, 37.89163], [-122.32748, 37.89129], [-122.3275, 37.89097], [-122.32745, 37.89074], [-122.32717, 37.89084], [-122.32691, 37.89087], [-122.3265, 37.89088], [-122.326, 37.89082], [-122.32568, 37.8908], [-122.32561, 37.89111], [-122.32559, 37.89174], [-122.32566, 37.89202], [-122.32592, 37.89206], [-122.32599, 37.89234], [-122.32573, 37.89251], [-122.32444, 37.89221], [-122.32409, 37.89132], [-122.32356, 37.89131], [-122.32311, 37.8899], [-122.31991, 37.88993], [-122.31763, 37.89086], [-122.31635, 37.8909], [-122.31625, 37.89169], [-122.31393, 37.8917], [-122.31197, 37.89022], [-122.312, 37.88997], [-122.31333, 37.88985], [-122.31333, 37.88964], [-122.31592, 37.88964], [-122.31593, 37.88793], [-122.31595, 37.88794], [-122.31602, 37.88795], [-122.31709, 37.88922], [-122.31722, 37.88925], [-122.32312, 37.8891], [-122.32321, 37.88893], [-122.32315, 37.88872], [-122.32319, 37.88833], [-122.32341, 37.88824], [-122.32374, 37.88809], [-122.32431, 37.88803], [-122.32463, 37.88788], [-122.32501, 37.88804], [-122.3254, 37.88804], [-122.32577, 37.88823], [-122.32585, 37.88825], [-122.32584, 37.88827], [-122.32619, 37.88847], [-122.32661, 37.88861], [-122.32695, 37.88868], [-122.32718, 37.88871], [-122.32763, 37.88855], [-122.32756, 37.88886], [-122.32764, 37.88931]]]} | Open Access 1 | 29694 | McLaughlin Eastshore State Park | 29199 | 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 | 71.308 | McLaughlin Eastshore SP | None 1414 | ||
4978 | 4978 | 4977 | {"type": "Polygon", "coordinates": [[[-122.28393, 37.76682], [-122.28393, 37.77013], [-122.28285, 37.77012], [-122.28281, 37.77095], [-122.28162, 37.77109], [-122.28162, 37.76827], [-122.27932, 37.76826], [-122.2793, 37.76863], [-122.27857, 37.76862], [-122.27848, 37.77085], [-122.27851, 37.77086], [-122.2785, 37.771], [-122.27847, 37.77101], [-122.27845, 37.77136], [-122.27822, 37.77135], [-122.27828, 37.76974], [-122.2759, 37.76967], [-122.27589, 37.7695], [-122.2753, 37.76949], [-122.27531, 37.76908], [-122.27476, 37.76908], [-122.27475, 37.76858], [-122.27202, 37.76755], [-122.27198, 37.7675], [-122.27186, 37.76731], [-122.2718, 37.76716], [-122.27175, 37.76698], [-122.27172, 37.76683], [-122.27172, 37.76649], [-122.27166, 37.76597], [-122.27166, 37.76247], [-122.27158, 37.76221], [-122.27292, 37.76284], [-122.27475, 37.76352], [-122.28282, 37.76638], [-122.28393, 37.76682]]]} | Open Access 1 | 15087 | Crown Memorial Regional Shoreline | 1486 | 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/crown_beach | Alameda 17 | 133.46 | Crown Memorial Reg. Shoreline | 1967 | Local Park 2 | 4 |
16638 | 16638 | 16637 | {"type": "MultiPolygon", "coordinates": [[[[-121.68009, 37.56802], [-121.68007, 37.57196], [-121.67069, 37.57206], [-121.67068, 37.57153], [-121.67092, 37.56801], [-121.68009, 37.56802]]], [[[-121.75246, 37.62111], [-121.7509, 37.62112], [-121.74958, 37.62186], [-121.74837, 37.62184], [-121.74806, 37.62246], [-121.74691, 37.62312], [-121.74699, 37.62353], [-121.74526, 37.62599], [-121.74283, 37.62803], [-121.74131, 37.62789], [-121.74099, 37.62211], [-121.73255, 37.62201], [-121.72876, 37.61978], [-121.72583, 37.61775], [-121.72459, 37.61429], [-121.72235, 37.60768], [-121.72202, 37.60661], [-121.71757, 37.60609], [-121.71465, 37.60075], [-121.70746, 37.60051], [-121.70274, 37.60031], [-121.69821, 37.60029], [-121.6969, 37.60016], [-121.69481, 37.60002], [-121.68929, 37.59975], [-121.68806, 37.60524], [-121.68772, 37.60502], [-121.68755, 37.60487], [-121.68735, 37.60465], [-121.68719, 37.60441], [-121.6871, 37.60422], [-121.68703, 37.60403], [-121.68698, 37.60376], [-121.68698, 37.60355], [-121.687, 37.60335], [-121.68705, 37.60315], [-121.68712, 37.60296], [-121.68722, 37.60277], [-121.68734, 37.60259], [-121.68749, 37.60242], [-121.68852, 37.60137], [-121.68868, 37.60116], [-121.68882, 37.60093], [-121.68895, 37.60057], [-121.68905, 37.59996], [-121.68916, 37.59976], [-121.68915, 37.59974], [-121.68908, 37.59974], [-121.68907, 37.59964], [-121.68913, 37.5994], [-121.68924, 37.59917], [-121.68967, 37.59852], [-121.68977, 37.5983], [-121.68982, 37.59812], [-121.68983, 37.59793], [-121.68982, 37.59774], [-121.68977, 37.59756], [-121.68966, 37.59734], [-121.68921, 37.59661], [-121.69368, 37.59664], [-121.69366, 37.59323], [-121.68823, 37.59339], [-121.68825, 37.59314], [-121.68843, 37.59202], [-121.68842, 37.59178], [-121.68836, 37.59155], [-121.68825, 37.59133], [-121.68805, 37.59109], [-121.68789, 37.59095], [-121.68733, 37.59055], [-121.68714, 37.59037], [-121.68705, 37.59023], [-121.68698, 37.59009], [-121.68694, 37.58997], [-121.68691, 37.5898], [-121.68693, 37.58959], [-121.68763, 37.58629], [-121.68796, 37.58607], [-121.68796, 37.58606], [-121.68035, 37.58639], [-121.68036, 37.56411], [-121.6895, 37.56405], [-121.68904, 37.56571], [-121.68899, 37.56577], [-121.69498, 37.56996], [-121.70798, 37.57891], [-121.71095, 37.58324], [-121.71589, 37.5859], [-121.71967, 37.58835], [-121.72581, 37.59067], [-121.73422, 37.59831], [-121.7459, 37.60902], [-121.74736, 37.61049], [-121.74896, 37.61319], [-121.74962, 37.61621], [-121.74793, 37.61702], [-121.74793, 37.61704], [-121.74834, 37.61757], [-121.74891, 37.61788], [-121.75182, 37.61916], [-121.7518, 37.6192], [-121.7515, 37.62024], [-121.75246, 37.62111]], [[-121.74972, 37.62053], [-121.75031, 37.61969], [-121.74918, 37.6192], [-121.7486, 37.62004], [-121.74972, 37.62053]]]]} | Open Access 1 | 47527 | Lake Del Valle State Recreation Area | 31232 | 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.parks.ca.gov/?page_id=537 | Alameda 17 | 3851.412 | Lake Del Valle SRA | 1967 | Local Recreation Area 3 | 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]);