units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where PARK_URL = "http://lamountains.com/parks.asp?parkid=51"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51 | 51 | 50 | {"type": "Polygon", "coordinates": [[[-118.674, 34.29348], [-118.67397, 34.29777], [-118.67398, 34.29799], [-118.67395, 34.30795], [-118.67392, 34.32596], [-118.65355, 34.32593], [-118.6368, 34.29182], [-118.63356, 34.27021], [-118.63407, 34.26984], [-118.63486, 34.26943], [-118.63545, 34.26914], [-118.63594, 34.26887], [-118.63651, 34.26874], [-118.63636, 34.2682], [-118.63686, 34.26821], [-118.63699, 34.26795], [-118.63775, 34.2679], [-118.63862, 34.26735], [-118.63882, 34.26705], [-118.64002, 34.26694], [-118.64055, 34.26718], [-118.64124, 34.26707], [-118.64161, 34.26757], [-118.64205, 34.268], [-118.64292, 34.26794], [-118.64321, 34.26815], [-118.64384, 34.26796], [-118.64476, 34.26861], [-118.64486, 34.26885], [-118.64554, 34.26919], [-118.64591, 34.26945], [-118.64587, 34.26972], [-118.64605, 34.26992], [-118.64617, 34.27043], [-118.64649, 34.27042], [-118.64736, 34.27032], [-118.64857, 34.2705], [-118.64975, 34.27054], [-118.65053, 34.27066], [-118.65167, 34.27079], [-118.65135, 34.27117], [-118.65102, 34.27141], [-118.6505, 34.27233], [-118.65068, 34.27264], [-118.651, 34.27288], [-118.65206, 34.27291], [-118.65241, 34.2726], [-118.65269, 34.27253], [-118.65287, 34.27283], [-118.6536, 34.27319], [-118.65554, 34.27312], [-118.65564, 34.27322], [-118.6557, 34.27352], [-118.65552, 34.27365], [-118.65526, 34.27388], [-118.65532, 34.27401], [-118.6557, 34.27417], [-118.65686, 34.2756], [-118.65684, 34.27585], [-118.65692, 34.276], [-118.65743, 34.27643], [-118.65769, 34.27678], [-118.65796, 34.27742], [-118.65835, 34.27777], [-118.65861, 34.2779], [-118.657, 34.2786], [-118.65697, 34.2852], [-118.65552, 34.2852], [-118.65553, 34.28163], [-118.65284, 34.28162], [-118.65281, 34.2889], [-118.65656, 34.28891], [-118.65656, 34.28992], [-118.65968, 34.28993], [-118.65966, 34.29346], [-118.674, 34.29348]], [[-118.65173, 34.28695], [-118.65174, 34.28673], [-118.65148, 34.28674], [-118.65148, 34.28695], [-118.65173, 34.28695]]]} | Open Access 1 | 147 | Rocky Peak Park | 7206 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://lamountains.com/parks.asp?parkid=51 | Ventura 8 | 3570.979 | Rocky Peak Park | 0 | Local Park 2 | 4 |
4310 | 4310 | 4309 | {"type": "MultiPolygon", "coordinates": [[[[-118.63485, 34.30711], [-118.63246, 34.30711], [-118.63238, 34.31063], [-118.628, 34.31062], [-118.62808, 34.30711], [-118.6259, 34.3071], [-118.62582, 34.30534], [-118.62364, 34.30534], [-118.62336, 34.29831], [-118.62776, 34.2983], [-118.62783, 34.30006], [-118.63221, 34.30006], [-118.6321, 34.29654], [-118.63381, 34.29654], [-118.63485, 34.30711]]], [[[-118.65352, 34.32591], [-118.63593, 34.32593], [-118.63574, 34.32116], [-118.65118, 34.32114], [-118.65352, 34.32591]]]]} | Open Access 1 | 10284 | Rocky Peak Park | 7206 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://lamountains.com/parks.asp?parkid=51 | Los Angeles 6 | 458.301 | Rocky Peak Park | 0 | Local Park 2 | 4 |
15235 | 15235 | 15234 | {"type": "Polygon", "coordinates": [[[-118.65118, 34.32114], [-118.63214, 34.32116], [-118.6323, 34.31415], [-118.62792, 34.31414], [-118.628, 34.31062], [-118.63237, 34.31063], [-118.63245, 34.30711], [-118.63485, 34.3071], [-118.63347, 34.29303], [-118.63739, 34.29303], [-118.65118, 34.32114]]]} | Open Access 1 | 46402 | Rocky Peak Park | 7206 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://lamountains.com/parks.asp?parkid=51 | Los Angeles 6 | 823.42 | Rocky Peak Park | 0 | Local Park 2 | 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]);