units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 75, COUNTY = 4 and MNG_AGENCY = 47
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16472 | 16472 | 16471 | {"type": "Polygon", "coordinates": [[[-117.20426, 32.64359], [-117.16473, 32.66737], [-117.16448, 32.66717], [-117.16425, 32.66694], [-117.16363, 32.66626], [-117.16331, 32.66598], [-117.16307, 32.66571], [-117.1626, 32.66505], [-117.1621, 32.66445], [-117.16187, 32.66422], [-117.16165, 32.66393], [-117.16114, 32.66336], [-117.16064, 32.66286], [-117.16043, 32.66261], [-117.16029, 32.66237], [-117.16021, 32.66217], [-117.16003, 32.66169], [-117.15987, 32.66144], [-117.15963, 32.66114], [-117.15946, 32.66097], [-117.15929, 32.66077], [-117.15889, 32.66005], [-117.15812, 32.65921], [-117.15793, 32.65906], [-117.15755, 32.65871], [-117.15739, 32.65851], [-117.1571, 32.65799], [-117.15694, 32.65776], [-117.15677, 32.65757], [-117.15658, 32.65739], [-117.15621, 32.65698], [-117.15593, 32.65663], [-117.15578, 32.6564], [-117.15564, 32.65609], [-117.15498, 32.65501], [-117.15477, 32.65474], [-117.15427, 32.65402], [-117.15389, 32.65331], [-117.15368, 32.65306], [-117.15319, 32.65226], [-117.153, 32.65202], [-117.15283, 32.65174], [-117.15258, 32.6512], [-117.15201, 32.65045], [-117.15173, 32.65013], [-117.1509, 32.64872], [-117.15066, 32.64835], [-117.15043, 32.64805], [-117.15027, 32.64776], [-117.15012, 32.64743], [-117.14982, 32.64691], [-117.14918, 32.64598], [-117.14897, 32.64562], [-117.1489, 32.64538], [-117.14861, 32.64471], [-117.14842, 32.64437], [-117.14816, 32.64397], [-117.14802, 32.64365], [-117.14779, 32.64331], [-117.14732, 32.6424], [-117.14691, 32.64169], [-117.14656, 32.64096], [-117.14644, 32.64064], [-117.14626, 32.64031], [-117.14614, 32.64002], [-117.14562, 32.63901], [-117.14545, 32.63873], [-117.1452, 32.63826], [-117.14512, 32.63797], [-117.14503, 32.63777], [-117.14467, 32.63727], [-117.14454, 32.63704], [-117.14446, 32.63682], [-117.14416, 32.63629], [-117.14406, 32.63614], [-117.14395, 32.63587], [-117.14362, 32.63521], [-117.14283, 32.63397], [-117.14276, 32.63383], [-117.14262, 32.63341], [-117.14251, 32.63318], [-117.14224, 32.63271], [-117.14204, 32.63231], [-117.14196, 32.6321], [-117.14173, 32.63142], [-117.14161, 32.63129], [-117.14151, 32.63109], [-117.14126, 32.63036], [-117.14114, 32.63008], [-117.14105, 32.62976], [-117.1408, 32.6292], [-117.14066, 32.62885], [-117.14041, 32.62835], [-117.13984, 32.62683], [-117.1397, 32.6265], [-117.13956, 32.62608], [-117.13928, 32.62534], [-117.13923, 32.62505], [-117.13922, 32.62478], [-117.13908, 32.62439], [-117.1389, 32.62397], [-117.13855, 32.62303], [-117.13822, 32.62189], [-117.1381, 32.62158], [-117.13798, 32.6211], [-117.13789, 32.62083], [-117.13776, 32.62055], [-117.13766, 32.62025], [-117.13757, 32.61987], [-117.13745, 32.61957], [-117.13716, 32.61865], [-117.13664, 32.6167], [-117.13652, 32.61631], [-117.13626, 32.61523], [-117.13614, 32.61471], [-117.13604, 32.61446], [-117.13583, 32.61371], [-117.1358, 32.6134], [-117.1357, 32.61295], [-117.13556, 32.61213], [-117.13489, 32.60924], [-117.18518, 32.60043], [-117.18826, 32.60889], [-117.19042, 32.6163], [-117.19451, 32.62552], [-117.19672, 32.63018], [-117.19795, 32.63266], [-117.2007, 32.6379], [-117.20216, 32.64043], [-117.20426, 32.64359]]]} | Open Access 1 | 44948 | Silver Strand State Beach | 1743 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=654 | San Diego 4 | 7227.929 | Silver Strand SB | 1932 | 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]);