units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 4, MNG_AGENCY = 47 and SUID_NMA = 1461
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8098 | 8098 | 8097 | {"type": "MultiPolygon", "coordinates": [[[[-117.28072, 33.01369], [-117.2807, 33.01369], [-117.28063, 33.01356], [-117.28072, 33.01369], [-117.28072, 33.01369]]], [[[-117.28063, 33.01356], [-117.28045, 33.01326], [-117.28026, 33.01287], [-117.28008, 33.01244], [-117.27991, 33.01197], [-117.27956, 33.01203], [-117.27926, 33.01079], [-117.27908, 33.01002], [-117.27893, 33.00928], [-117.27874, 33.00818], [-117.27846, 33.00623], [-117.27838, 33.00492], [-117.27806, 33.0039], [-117.27784, 33.00333], [-117.27751, 33.00264], [-117.27729, 33.00228], [-117.27657, 33.00125], [-117.27671, 33.00128], [-117.27704, 33.00097], [-117.27745, 33.00082], [-117.2777, 33.00067], [-117.27798, 33.00055], [-117.27817, 33.00055], [-117.2781, 33.00006], [-117.27798, 33.00005], [-117.27798, 33.00001], [-117.2778, 32.99993], [-117.27767, 32.99954], [-117.27738, 32.99917], [-117.2774, 32.99916], [-117.27784, 32.99911], [-117.27799, 32.99932], [-117.27817, 32.99965], [-117.2783, 32.99995], [-117.27839, 33.00025], [-117.27846, 33.00067], [-117.27848, 33.00173], [-117.27849, 33.00175], [-117.27851, 33.00234], [-117.27855, 33.00446], [-117.27861, 33.00551], [-117.27867, 33.006], [-117.27882, 33.00684], [-117.27909, 33.00803], [-117.27933, 33.00876], [-117.27993, 33.01114], [-117.28063, 33.01356]]], [[[-117.28192, 33.01539], [-117.28192, 33.01545], [-117.28187, 33.01556], [-117.28179, 33.01567], [-117.28138, 33.0157], [-117.2813, 33.01547], [-117.28049, 33.01418], [-117.28033, 33.01395], [-117.28016, 33.01376], [-117.28076, 33.01375], [-117.28192, 33.01539]]]]} | Open Access 1 | 12170 | Cardiff State Beach | 1461 | 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/default.asp?page_id=656 | San Diego 4 | 23.131 | Cardiff SB | 1949 | State Park 15 | 4 |
| 11340 | 11340 | 11339 | {"type": "Polygon", "coordinates": [[[-117.29351, 33.0127], [-117.28215, 33.01572], [-117.28063, 33.01356], [-117.27993, 33.01114], [-117.2788, 33.00672], [-117.27857, 33.00476], [-117.27851, 33.00234], [-117.27849, 33.00175], [-117.27848, 33.00174], [-117.27846, 33.00067], [-117.27843, 33.00048], [-117.27835, 33.00009], [-117.27817, 32.99964], [-117.27799, 32.99932], [-117.27783, 32.9991], [-117.2793, 32.99887], [-117.27931, 32.9989], [-117.28762, 32.99758], [-117.29351, 33.0127]]]} | Open Access 1 | 28052 | Cardiff State Beach | 1461 | 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/default.asp?page_id=656 | San Diego 4 | 485.781 | Cardiff SB | 1949 | 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]);