units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and LABEL_NAME = "Huntington SB"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16449 | 16449 | 16448 | {"type": "Polygon", "coordinates": [[[-117.98834, 33.64701], [-117.98813, 33.64738], [-117.98811, 33.64739], [-117.98791, 33.6478], [-117.97361, 33.63942], [-117.96958, 33.63745], [-117.96882, 33.63728], [-117.96708, 33.63642], [-117.96309, 33.63401], [-117.95841, 33.63112], [-117.9583, 33.63108], [-117.95861, 33.63082], [-117.95913, 33.63002], [-117.95912, 33.62999], [-117.95931, 33.6295], [-117.95943, 33.62955], [-117.96027, 33.63023], [-117.96078, 33.6307], [-117.96163, 33.6312], [-117.96193, 33.63147], [-117.96282, 33.63208], [-117.96297, 33.63214], [-117.96332, 33.63234], [-117.96355, 33.63251], [-117.9641, 33.63284], [-117.9645, 33.63313], [-117.96484, 33.6332], [-117.96544, 33.63356], [-117.96577, 33.6338], [-117.96605, 33.63397], [-117.96638, 33.63407], [-117.96742, 33.63467], [-117.96945, 33.63579], [-117.96989, 33.63609], [-117.97027, 33.63622], [-117.97138, 33.63698], [-117.97183, 33.63718], [-117.97223, 33.63741], [-117.97277, 33.63778], [-117.97325, 33.63802], [-117.97374, 33.63833], [-117.974, 33.63845], [-117.97433, 33.63856], [-117.97451, 33.63868], [-117.97481, 33.63875], [-117.9754, 33.63905], [-117.97558, 33.63919], [-117.97594, 33.63938], [-117.97662, 33.63989], [-117.97695, 33.63994], [-117.97745, 33.64018], [-117.97871, 33.64102], [-117.97926, 33.64124], [-117.97971, 33.64156], [-117.98037, 33.64188], [-117.98143, 33.64262], [-117.98168, 33.64282], [-117.98287, 33.64338], [-117.98322, 33.64368], [-117.98376, 33.64397], [-117.98437, 33.6444], [-117.98535, 33.64486], [-117.98588, 33.64525], [-117.98633, 33.64546], [-117.98673, 33.6459], [-117.987, 33.64595], [-117.98709, 33.64615], [-117.98739, 33.64636], [-117.98792, 33.64668], [-117.98814, 33.64688], [-117.98834, 33.64701]]]} | Open Access 1 | 2044 | Huntington State Beach | 1575 | 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 | http://www.parks.ca.gov/?page_id=643 | Orange 3 | 115.772 | Huntington SB | 1942 | State Park 15 | 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]);