units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Lighthouse Field SB", MNG_AGENCY = 47 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16466 | 16466 | 16465 | {"type": "MultiPolygon", "coordinates": [[[[-122.03229, 36.95194], [-122.03218, 36.95192], [-122.03218, 36.95196], [-122.03186, 36.95192], [-122.0316, 36.95192], [-122.03132, 36.95195], [-122.03069, 36.95207], [-122.02978, 36.9521], [-122.02889, 36.95226], [-122.02866, 36.95226], [-122.02819, 36.95221], [-122.02819, 36.95188], [-122.02831, 36.95192], [-122.02843, 36.95202], [-122.02864, 36.95208], [-122.0288, 36.9521], [-122.02887, 36.95203], [-122.02888, 36.95197], [-122.02904, 36.95195], [-122.02916, 36.95198], [-122.0293, 36.95205], [-122.02938, 36.95206], [-122.02941, 36.95205], [-122.02953, 36.95194], [-122.02967, 36.95193], [-122.02985, 36.95188], [-122.02993, 36.95178], [-122.03, 36.95178], [-122.03023, 36.95172], [-122.03023, 36.95166], [-122.03024, 36.95164], [-122.0304, 36.95174], [-122.03059, 36.95173], [-122.03069, 36.9517], [-122.03072, 36.95168], [-122.03079, 36.9517], [-122.031, 36.9517], [-122.03116, 36.95162], [-122.0313, 36.9516], [-122.03135, 36.95157], [-122.03138, 36.95153], [-122.0314, 36.95141], [-122.03143, 36.95139], [-122.03148, 36.95141], [-122.03149, 36.95143], [-122.03145, 36.95149], [-122.03143, 36.95155], [-122.03147, 36.9516], [-122.03147, 36.95163], [-122.03157, 36.95161], [-122.03167, 36.95167], [-122.0317, 36.95171], [-122.03178, 36.9517], [-122.03183, 36.95174], [-122.03195, 36.95171], [-122.03206, 36.95172], [-122.03215, 36.95178], [-122.03228, 36.95181], [-122.03229, 36.95194]]], [[[-122.03263, 36.95389], [-122.03167, 36.95398], [-122.03166, 36.95402], [-122.02508, 36.95468], [-122.02561, 36.95329], [-122.02585, 36.95287], [-122.02589, 36.95286], [-122.02613, 36.95258], [-122.02622, 36.95242], [-122.02627, 36.95228], [-122.02621, 36.95222], [-122.02632, 36.95209], [-122.02648, 36.952], [-122.02667, 36.95197], [-122.02711, 36.95198], [-122.0273, 36.95202], [-122.0281, 36.95227], [-122.02834, 36.95231], [-122.02866, 36.95234], [-122.0289, 36.95234], [-122.02979, 36.95218], [-122.03066, 36.95216], [-122.03093, 36.95212], [-122.03135, 36.95203], [-122.03162, 36.952], [-122.03188, 36.952], [-122.03228, 36.95205], [-122.03233, 36.95207], [-122.03263, 36.95389]]]]} | Open Access 1 | 17342 | Lighthouse Field State Beach | 1605 | 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=550 | Santa Cruz 5 | 38.463 | Lighthouse Field SB | 1978 | 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]);