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 = "Westport-Union Landing SB"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16489 | 16489 | 16488 | {"type": "MultiPolygon", "coordinates": [[[[-123.78456, 39.64243], [-123.78456, 39.64243], [-123.78452, 39.64529], [-123.78442, 39.64493], [-123.78437, 39.6448], [-123.78425, 39.64458], [-123.78404, 39.64432], [-123.784, 39.64424], [-123.78399, 39.64414], [-123.78421, 39.64329], [-123.78427, 39.64244], [-123.78456, 39.64243]]], [[[-123.7845, 39.64705], [-123.78449, 39.6476], [-123.78449, 39.6476], [-123.78428, 39.64731], [-123.7845, 39.64705]]], [[[-123.80082, 39.69674], [-123.80026, 39.69725], [-123.80025, 39.69728], [-123.80014, 39.6971], [-123.79998, 39.69695], [-123.79908, 39.69639], [-123.79893, 39.69626], [-123.79879, 39.69609], [-123.79871, 39.69587], [-123.79871, 39.69566], [-123.7988, 39.69532], [-123.79881, 39.69512], [-123.79875, 39.69488], [-123.79862, 39.69466], [-123.79851, 39.69454], [-123.79709, 39.69321], [-123.79668, 39.69288], [-123.79623, 39.69258], [-123.79562, 39.69213], [-123.79514, 39.69173], [-123.79473, 39.69133], [-123.79423, 39.69077], [-123.79384, 39.69025], [-123.79369, 39.69002], [-123.79341, 39.68954], [-123.79316, 39.68902], [-123.79295, 39.68848], [-123.79244, 39.68669], [-123.79301, 39.68631], [-123.7927, 39.68524], [-123.79183, 39.68455], [-123.79137, 39.68322], [-123.79114, 39.68241], [-123.79092, 39.68133], [-123.7902, 39.67875], [-123.79014, 39.67849], [-123.79006, 39.67795], [-123.79004, 39.67768], [-123.79003, 39.6772], [-123.79005, 39.67687], [-123.79011, 39.67633], [-123.79021, 39.67582], [-123.79072, 39.67383], [-123.79073, 39.67355], [-123.79103, 39.67119], [-123.79087, 39.6705], [-123.79077, 39.66994], [-123.79059, 39.66939], [-123.79035, 39.66884], [-123.79007, 39.66831], [-123.78922, 39.66685], [-123.78893, 39.66589], [-123.78834, 39.66534], [-123.78732, 39.66359], [-123.78726, 39.66359], [-123.78583, 39.66112], [-123.78567, 39.6608], [-123.78555, 39.66047], [-123.78546, 39.66022], [-123.78548, 39.66009], [-123.78571, 39.66016], [-123.7859, 39.66029], [-123.78625, 39.66018], [-123.78625, 39.66021], [-123.7863, 39.66031], [-123.78675, 39.66088], [-123.78686, 39.66105], [-123.78698, 39.66122], [-123.78703, 39.66132], [-123.78733, 39.66168], [-123.7874, 39.66188], [-123.78742, 39.66236], [-123.78748, 39.66247], [-123.78752, 39.66259], [-123.78764, 39.66272], [-123.78774, 39.66276], [-123.7878, 39.66284], [-123.7878, 39.66294], [-123.78785, 39.66303], [-123.78819, 39.66358], [-123.78845, 39.66394], [-123.78872, 39.66449], [-123.7888, 39.66463], [-123.78891, 39.66489], [-123.78912, 39.66514], [-123.78922, 39.66517], [-123.78944, 39.66548], [-123.78961, 39.66562], [-123.78976, 39.6658], [-123.7899, 39.66592], [-123.79026, 39.66609], [-123.79042, 39.6661], [-123.79054, 39.66612], [-123.79082, 39.66623], [-123.79092, 39.66629], [-123.79101, 39.66636], [-123.79109, 39.6665], [-123.79116, 39.66657], [-123.79135, 39.66662], [-123.79163, 39.66677], [-123.79191, 39.66683], [-123.79228, 39.66682], [-123.79241, 39.66704], [-123.79253, 39.66709], [-123.79266, 39.6671], [-123.79282, 39.66716], [-123.79289, 39.66724], [-123.79289, 39.66731], [-123.79278, 39.66739], [-123.79272, 39.66742], [-123.79252, 39.66743], [-123.79247, 39.66748], [-123.79244, 39.66763], [-123.79245, 39.66769], [-123.79241, 39.6678], [-123.79231, 39.66776], [-123.79215, 39.66783], [-123.79212, 39.66788], [-123.79198, 39.66817], [-123.79193, 39.66846], [-123.79195, 39.66896], [-123.79193, 39.66902], [-123.79189, 39.66904], [-123.79184, 39.66901], [-123.79174, 39.66902], [-123.79166, 39.66909], [-123.7916, 39.6692], [-123.79153, 39.66947], [-123.79153, 39.66961], [-123.79147, 39.66997], [-123.7915, 39.67021], [-123.79176, 39.67134], [-123.79166, 39.67144], [-123.79162, 39.67158], [-123.79165, 39.67164], [-123.79163, 39.67176], [-123.79158, 39.67185], [-123.79155, 39.67199], [-123.79154, 39.67228], [-123.79157, 39.67242], [-123.79154, 39.67273], [-123.7915, 39.67299], [-123.79141, 39.6731], [-123.79141, 39.67319], [-123.79144, 39.6733], [-123.79146, 39.6736], [-123.79132, 39.67428], [-123.79134, 39.67463], [-123.79146, 39.67529], [-123.79147, 39.67554], [-123.79155, 39.6758], [-123.79154, 39.67601], [-123.79151, 39.67611], [-123.79135, 39.67629], [-123.79143, 39.67674], [-123.79153, 39.67685], [-123.79157, 39.67691], [-123.79151, 39.67703], [-123.79147, 39.67718], [-123.79151, 39.67741], [-123.79147, 39.67755], [-123.79141, 39.67762], [-123.79135, 39.67776], [-123.79139, 39.67781], [-123.79144, 39.67778], [-123.7915, 39.67778], [-123.7917, 39.678], [-123.79176, 39.67812], [-123.79176, 39.67832], [-123.79177, 39.67842], [-123.79191, 39.67842], [-123.79205, 39.67839], [-123.7921, 39.67839], [-123.79212, 39.67842], [-123.79212, 39.67851], [-123.79207, 39.67869], [-123.79196, 39.67881], [-123.79193, 39.679], [-123.79183, 39.67914], [-123.79181, 39.67935], [-123.79176, 39.67956], [-123.79165, 39.67981], [-123.79163, 39.68002], [-123.79176, 39.6809], [-123.79184, 39.68124], [-123.79195, 39.68145], [-123.79202, 39.68147], [-123.79203, 39.68151], [-123.79193, 39.68166], [-123.79195, 39.68223], [-123.7921, 39.68263], [-123.79234, 39.68344], [-123.79244, 39.68366], [-123.79247, 39.68391], [-123.7925, 39.68401], [-123.79271, 39.68444], [-123.79286, 39.68492], [-123.79299, 39.68505], [-123.79305, 39.68519], [-123.79309, 39.68531], [-123.79321, 39.68547], [-123.79335, 39.68561], [-123.79346, 39.68577], [-123.79353, 39.68604], [-123.7936, 39.68623], [-123.79379, 39.68721], [-123.79399, 39.68762], [-123.79417, 39.68786], [-123.79437, 39.68803], [-123.79447, 39.68803], [-123.79459, 39.68814], [-123.79474, 39.68834], [-123.79472, 39.68845], [-123.79464, 39.6886], [-123.7946, 39.68875], [-123.79459, 39.68893], [-123.7946, 39.68941], [-123.79466, 39.68959], [-123.79473, 39.68975], [-123.79526, 39.69058], [-123.79547, 39.691], [-123.79559, 39.69114], [-123.79576, 39.69122], [-123.79653, 39.69144], [-123.79667, 39.69157], [-123.79672, 39.69166], [-123.79715, 39.69213], [-123.79736, 39.69224], [-123.79788, 39.69272], [-123.79807, 39.693], [-123.79833, 39.69349], [-123.79852, 39.69373], [-123.7987, 39.69387], [-123.79905, 39.69412], [-123.79931, 39.69433], [-123.79938, 39.69457], [-123.79953, 39.69485], [-123.79957, 39.69497], [-123.7995, 39.69513], [-123.79948, 39.69532], [-123.79983, 39.69601], [-123.8, 39.69622], [-123.8005, 39.69645], [-123.80077, 39.69667], [-123.80082, 39.69674]]]]} | Open Access 1 | 24873 | Westport-Union Landing State Beach | 1786 | 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=440 | Mendocino 24 | 101.52 | Westport-Union Landing SB | 1952 | 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]);