units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 48 and DES_TP = 1400
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16427 | 16427 | 16426 | {"type": "MultiPolygon", "coordinates": [[[[-118.55583, 34.03798], [-118.55572, 34.03834], [-118.55517, 34.03833], [-118.55476, 34.03835], [-118.55393, 34.03844], [-118.55365, 34.03853], [-118.55269, 34.0388], [-118.55086, 34.03926], [-118.55047, 34.03934], [-118.55001, 34.03938], [-118.54954, 34.03937], [-118.54848, 34.03928], [-118.54787, 34.03929], [-118.54788, 34.03919], [-118.54536, 34.03872], [-118.54392, 34.03887], [-118.54391, 34.03921], [-118.54177, 34.0386], [-118.54124, 34.03842], [-118.54064, 34.03816], [-118.53918, 34.03738], [-118.53794, 34.03677], [-118.53795, 34.03674], [-118.53598, 34.03579], [-118.53542, 34.03543], [-118.53468, 34.03487], [-118.5344, 34.0347], [-118.5341, 34.03456], [-118.52867, 34.03231], [-118.52815, 34.03215], [-118.52686, 34.03188], [-118.52656, 34.03176], [-118.52654, 34.03177], [-118.52486, 34.03107], [-118.52441, 34.03083], [-118.5219, 34.02944], [-118.52067, 34.02865], [-118.52039, 34.02851], [-118.51971, 34.02825], [-118.51943, 34.02808], [-118.51941, 34.028], [-118.51917, 34.02783], [-118.51907, 34.02783], [-118.51818, 34.02729], [-118.51707, 34.02675], [-118.51792, 34.02557], [-118.51861, 34.02602], [-118.51897, 34.02622], [-118.51932, 34.02639], [-118.51971, 34.02665], [-118.52001, 34.02686], [-118.52008, 34.02703], [-118.52009, 34.02722], [-118.52027, 34.02748], [-118.52039, 34.0275], [-118.52057, 34.02756], [-118.52113, 34.02756], [-118.52161, 34.02782], [-118.52185, 34.02803], [-118.52209, 34.02818], [-118.52234, 34.0284], [-118.52258, 34.02854], [-118.52283, 34.02862], [-118.52392, 34.02934], [-118.52482, 34.02988], [-118.52574, 34.0304], [-118.52621, 34.03076], [-118.52699, 34.03109], [-118.52718, 34.03109], [-118.52751, 34.03113], [-118.5281, 34.03131], [-118.52834, 34.03145], [-118.52868, 34.03169], [-118.52961, 34.03226], [-118.53042, 34.03258], [-118.53069, 34.03241], [-118.5309, 34.03248], [-118.5313, 34.03266], [-118.53192, 34.03299], [-118.53255, 34.03326], [-118.53291, 34.03344], [-118.53402, 34.03391], [-118.53482, 34.03431], [-118.53539, 34.03453], [-118.53588, 34.03479], [-118.53651, 34.035], [-118.53687, 34.03506], [-118.53715, 34.03518], [-118.53784, 34.03539], [-118.53811, 34.03551], [-118.53834, 34.0357], [-118.53857, 34.03584], [-118.53882, 34.03596], [-118.53909, 34.03605], [-118.53939, 34.03618], [-118.53973, 34.0363], [-118.54037, 34.03661], [-118.5409, 34.03697], [-118.54185, 34.03732], [-118.54249, 34.03762], [-118.54277, 34.03781], [-118.54308, 34.03797], [-118.54365, 34.03813], [-118.54399, 34.03819], [-118.5442, 34.03826], [-118.54444, 34.0383], [-118.54486, 34.03848], [-118.54487, 34.03852], [-118.5452, 34.03846], [-118.54588, 34.03865], [-118.54639, 34.03877], [-118.54736, 34.03894], [-118.54794, 34.03903], [-118.54881, 34.03909], [-118.54997, 34.0391], [-118.55042, 34.03906], [-118.55141, 34.03889], [-118.55269, 34.03862], [-118.55302, 34.03848], [-118.55385, 34.03797], [-118.55415, 34.03788], [-118.55472, 34.0378], [-118.55512, 34.03779], [-118.55568, 34.03785], [-118.55568, 34.03788], [-118.55583, 34.03798]]], [[[-118.56722, 34.04165], [-118.5663, 34.0415], [-118.56567, 34.04136], [-118.56518, 34.04127], [-118.56419, 34.04122], [-118.56383, 34.04116], [-118.56349, 34.04108], [-118.56299, 34.0409], [-118.56244, 34.0406], [-118.56207, 34.04043], [-118.56005, 34.03982], [-118.55953, 34.03964], [-118.55896, 34.03942], [-118.55764, 34.03883], [-118.55706, 34.03859], [-118.5564, 34.0384], [-118.55601, 34.03836], [-118.55601, 34.03826], [-118.55621, 34.03794], [-118.55636, 34.03797], [-118.55682, 34.0382], [-118.5576, 34.03848], [-118.55785, 34.03861], [-118.55814, 34.03869], [-118.55846, 34.03884], [-118.5589, 34.03899], [-118.55955, 34.03916], [-118.5601, 34.03938], [-118.5605, 34.03959], [-118.56097, 34.03979], [-118.56121, 34.03986], [-118.56173, 34.04004], [-118.56201, 34.04011], [-118.56227, 34.04024], [-118.56256, 34.04031], [-118.56281, 34.04041], [-118.56333, 34.04056], [-118.56392, 34.04065], [-118.5643, 34.0407], [-118.56541, 34.04096], [-118.56562, 34.04093], [-118.5668, 34.04117], [-118.56682, 34.04132], [-118.56714, 34.04138], [-118.56714, 34.04156], [-118.56722, 34.04165]]]]} | Open Access 1 | 5469 | Will Rogers State Beach | 30714 | 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 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://www.parks.ca.gov/?page_id=625 | Los Angeles 6 | 90.632 | Will Rogers SB | 1931 | None 1400 |
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]);