units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where LAYER = 9 and MNG_AGENCY = 42
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16452 | 16452 | 16451 | {"type": "Polygon", "coordinates": [[[-117.31058, 33.07647], [-117.31024, 33.07647], [-117.30983, 33.07527], [-117.30891, 33.07324], [-117.30866, 33.07256], [-117.30669, 33.06808], [-117.30625, 33.06704], [-117.30608, 33.0665], [-117.30551, 33.06583], [-117.30541, 33.0655], [-117.30479, 33.06563], [-117.30446, 33.06469], [-117.30483, 33.06459], [-117.30492, 33.06399], [-117.30429, 33.06269], [-117.30461, 33.06262], [-117.30504, 33.06328], [-117.30518, 33.06356], [-117.3054, 33.06412], [-117.30551, 33.06446], [-117.30564, 33.06468], [-117.30568, 33.06484], [-117.30572, 33.06532], [-117.30575, 33.06545], [-117.30593, 33.06584], [-117.30644, 33.06646], [-117.30657, 33.06663], [-117.30681, 33.06708], [-117.30691, 33.06733], [-117.30715, 33.06807], [-117.30726, 33.0683], [-117.30735, 33.06859], [-117.30748, 33.06898], [-117.30764, 33.06936], [-117.30785, 33.06979], [-117.30805, 33.07028], [-117.30825, 33.07082], [-117.30893, 33.07212], [-117.30901, 33.0724], [-117.3091, 33.07289], [-117.31058, 33.07647]]]} | Open Access 1 | 4045 | Leucadia State Beach | 30658 | 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 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 15.812 | Leucadia SB | 1949 | None 1403 | |
16454 | 16454 | 16453 | {"type": "MultiPolygon", "coordinates": [[[[-117.29601, 33.04852], [-117.29434, 33.04867], [-117.29425, 33.04809], [-117.29422, 33.04808], [-117.2942, 33.04794], [-117.2959, 33.04778], [-117.29595, 33.04815], [-117.29601, 33.04852]]], [[[-117.29802, 33.04877], [-117.29769, 33.0488], [-117.29769, 33.04872], [-117.29776, 33.04866], [-117.29781, 33.04865], [-117.2979, 33.04869], [-117.29798, 33.04869], [-117.29801, 33.04872], [-117.29802, 33.04877]]], [[[-117.29663, 33.04875], [-117.29631, 33.04878], [-117.29629, 33.04866], [-117.29661, 33.04863], [-117.29663, 33.04875]]], [[[-117.29605, 33.04882], [-117.29572, 33.04885], [-117.2957, 33.04871], [-117.29603, 33.04868], [-117.29605, 33.04882]]], [[[-117.29565, 33.04886], [-117.29534, 33.04888], [-117.29532, 33.04875], [-117.29564, 33.04872], [-117.29565, 33.04886]]], [[[-117.29466, 33.04895], [-117.29438, 33.04898], [-117.29436, 33.04884], [-117.29464, 33.04881], [-117.29466, 33.04895]]], [[[-117.29921, 33.04945], [-117.29911, 33.04946], [-117.29906, 33.04935], [-117.29873, 33.04939], [-117.29861, 33.04844], [-117.29812, 33.04848], [-117.29811, 33.04845], [-117.29806, 33.04846], [-117.29797, 33.04843], [-117.29789, 33.04845], [-117.29781, 33.0485], [-117.2978, 33.04856], [-117.29777, 33.0486], [-117.29765, 33.04867], [-117.29763, 33.04871], [-117.29763, 33.04881], [-117.2973, 33.04883], [-117.29724, 33.0484], [-117.29627, 33.04849], [-117.29608, 33.04721], [-117.29743, 33.04707], [-117.29736, 33.04645], [-117.29767, 33.04642], [-117.29749, 33.04498], [-117.29747, 33.04497], [-117.29745, 33.04483], [-117.29747, 33.04482], [-117.29725, 33.0431], [-117.29727, 33.04302], [-117.29734, 33.04365], [-117.29745, 33.04422], [-117.29804, 33.04641], [-117.29814, 33.04686], [-117.29815, 33.04688], [-117.29822, 33.04688], [-117.2988, 33.04824], [-117.29921, 33.04945]]]]} | Open Access 1 | 5464 | Moonlight State Beach | 30664 | 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 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 15.875 | Moonlight SB | 1949 | None 1404 |
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]);