units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where UNIT_NAME = "Las Flores Canyon Open Space"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1069 | 1069 | 1068 | {"type": "Polygon", "coordinates": [[[-118.64067, 34.06497], [-118.64065, 34.06495], [-118.64055, 34.065], [-118.6405, 34.06505], [-118.64048, 34.06512], [-118.6405, 34.06525], [-118.64059, 34.06544], [-118.63925, 34.0655], [-118.6403, 34.06406], [-118.64038, 34.06412], [-118.64057, 34.0642], [-118.64081, 34.06442], [-118.64085, 34.06449], [-118.64086, 34.06455], [-118.64083, 34.06472], [-118.64088, 34.06484], [-118.64087, 34.06487], [-118.64083, 34.06492], [-118.64067, 34.06497]]]} | Open Access 1 | 6433 | Las Flores Canyon Open Space | 21048 | 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 | Los Angeles 6 | 3.131 | Las Flores Canyon OS | 0 | Local Recreation Area 3 | 4 | |
7240 | 7240 | 7239 | {"type": "MultiPolygon", "coordinates": [[[[-118.63834, 34.05331], [-118.63828, 34.05338], [-118.63796, 34.05287], [-118.63805, 34.05287], [-118.63822, 34.05318], [-118.63834, 34.05331]]], [[[-118.6403, 34.06405], [-118.63999, 34.06447], [-118.63883, 34.06406], [-118.63887, 34.06394], [-118.63886, 34.06386], [-118.63882, 34.06371], [-118.63874, 34.06362], [-118.63846, 34.06342], [-118.63832, 34.06326], [-118.63943, 34.06277], [-118.63948, 34.06284], [-118.63955, 34.06289], [-118.63962, 34.06291], [-118.63971, 34.06301], [-118.63979, 34.06313], [-118.63977, 34.06316], [-118.64005, 34.06353], [-118.64004, 34.06366], [-118.64009, 34.06377], [-118.6403, 34.06405]]]]} | No Public Access 3 | 6434 | Las Flores Canyon Open Space | 29666 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 4.661 | Las Flores Canyon OS | 0 | Private Recreation or Education 65 | 4 | |
7778 | 7778 | 7777 | {"type": "MultiPolygon", "coordinates": [[[[-118.64122, 34.07483], [-118.63252, 34.07463], [-118.63248, 34.06368], [-118.6343, 34.06368], [-118.63436, 34.06384], [-118.63435, 34.06395], [-118.63431, 34.06402], [-118.63417, 34.06418], [-118.63412, 34.06433], [-118.63414, 34.06449], [-118.63423, 34.06462], [-118.63437, 34.06473], [-118.63475, 34.06484], [-118.63481, 34.06489], [-118.63488, 34.06498], [-118.63488, 34.06515], [-118.63491, 34.06524], [-118.63497, 34.06533], [-118.63506, 34.0654], [-118.63522, 34.06546], [-118.63551, 34.06546], [-118.63558, 34.06548], [-118.63624, 34.06577], [-118.63639, 34.06585], [-118.63656, 34.06601], [-118.63682, 34.06638], [-118.63684, 34.06736], [-118.63685, 34.07103], [-118.64119, 34.07112], [-118.64122, 34.07483]]], [[[-118.63682, 34.06615], [-118.63661, 34.06588], [-118.63647, 34.06576], [-118.63631, 34.06567], [-118.63563, 34.06537], [-118.63552, 34.06535], [-118.63528, 34.06536], [-118.63514, 34.06532], [-118.63507, 34.06526], [-118.63503, 34.06518], [-118.63501, 34.06496], [-118.63493, 34.06483], [-118.6348, 34.06474], [-118.63447, 34.06465], [-118.63434, 34.06457], [-118.63427, 34.06445], [-118.63425, 34.06436], [-118.63429, 34.06423], [-118.63442, 34.06408], [-118.63449, 34.06395], [-118.63449, 34.0638], [-118.63444, 34.06368], [-118.6368, 34.06368], [-118.63682, 34.06615]]]]} | Open Access 1 | 6432 | Las Flores Canyon Open Space | 21047 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 160.304 | Las Flores Canyon OS | 0 | State Recreation Area 39 | 4 | |
16041 | 16041 | 16040 | {"type": "MultiPolygon", "coordinates": [[[[-118.64113, 34.05286], [-118.64113, 34.05487], [-118.64026, 34.05501], [-118.64029, 34.05494], [-118.6403, 34.05485], [-118.64028, 34.05478], [-118.64019, 34.05463], [-118.64017, 34.05445], [-118.64018, 34.05438], [-118.64025, 34.05429], [-118.64062, 34.05407], [-118.64067, 34.05398], [-118.64068, 34.05391], [-118.64064, 34.05382], [-118.64056, 34.05376], [-118.64048, 34.05373], [-118.64023, 34.05371], [-118.64013, 34.05366], [-118.63997, 34.05354], [-118.63986, 34.05351], [-118.63989, 34.0535], [-118.63989, 34.05286], [-118.64113, 34.05286]]], [[[-118.63816, 34.05318], [-118.63828, 34.05338], [-118.63764, 34.05419], [-118.63844, 34.05443], [-118.63877, 34.0544], [-118.63912, 34.05433], [-118.63921, 34.05429], [-118.63929, 34.05422], [-118.63937, 34.05426], [-118.63937, 34.05475], [-118.63844, 34.05491], [-118.63844, 34.05505], [-118.6384, 34.05495], [-118.63725, 34.05467], [-118.63707, 34.0549], [-118.63836, 34.05523], [-118.6384, 34.05523], [-118.63839, 34.05526], [-118.63834, 34.05532], [-118.63822, 34.05538], [-118.63812, 34.05544], [-118.63804, 34.05555], [-118.63802, 34.05564], [-118.63773, 34.05592], [-118.63763, 34.05595], [-118.63755, 34.05599], [-118.63739, 34.05617], [-118.63731, 34.05635], [-118.6372, 34.05654], [-118.63715, 34.05687], [-118.63716, 34.05694], [-118.63709, 34.05697], [-118.63704, 34.05708], [-118.63644, 34.05725], [-118.63646, 34.05793], [-118.63706, 34.05793], [-118.63688, 34.05846], [-118.63689, 34.05898], [-118.63735, 34.05968], [-118.63745, 34.06002], [-118.6374, 34.06002], [-118.6374, 34.06004], [-118.63763, 34.06083], [-118.63736, 34.06178], [-118.63733, 34.06256], [-118.63723, 34.06258], [-118.63723, 34.06348], [-118.6368, 34.06368], [-118.63444, 34.06368], [-118.63421, 34.06315], [-118.63383, 34.06264], [-118.63367, 34.06249], [-118.63334, 34.06229], [-118.63329, 34.06223], [-118.63326, 34.06217], [-118.63318, 34.0618], [-118.63455, 34.06144], [-118.63498, 34.06093], [-118.6344, 34.06005], [-118.63247, 34.06006], [-118.63249, 34.05288], [-118.63796, 34.05287], [-118.63816, 34.05318]]], [[[-118.6343, 34.06368], [-118.63248, 34.06368], [-118.63247, 34.06167], [-118.63261, 34.06161], [-118.63277, 34.06161], [-118.63291, 34.06167], [-118.63298, 34.06174], [-118.63302, 34.06182], [-118.63305, 34.06182], [-118.63313, 34.06219], [-118.63317, 34.06227], [-118.63326, 34.06237], [-118.63357, 34.06256], [-118.63371, 34.0627], [-118.63409, 34.0632], [-118.6343, 34.06368]]]]} | Open Access 1 | 6429 | Las Flores Canyon Open Space | 21048 | 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 | Los Angeles 6 | 131.468 | Las Flores Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16043 | 16043 | 16042 | {"type": "MultiPolygon", "coordinates": [[[[-118.63872, 34.06381], [-118.63873, 34.06394], [-118.63869, 34.06403], [-118.63859, 34.06413], [-118.6384, 34.06421], [-118.63832, 34.06427], [-118.63824, 34.06439], [-118.63822, 34.06452], [-118.63825, 34.06461], [-118.6383, 34.06469], [-118.63863, 34.06493], [-118.63869, 34.065], [-118.63872, 34.06508], [-118.63873, 34.06517], [-118.63871, 34.06525], [-118.63858, 34.06549], [-118.63853, 34.06563], [-118.63851, 34.06584], [-118.63854, 34.06598], [-118.63892, 34.06725], [-118.63893, 34.06745], [-118.6389, 34.06757], [-118.63884, 34.06769], [-118.6387, 34.06785], [-118.6381, 34.06827], [-118.638, 34.0683], [-118.63786, 34.0683], [-118.63773, 34.06823], [-118.63766, 34.06813], [-118.63756, 34.06745], [-118.63751, 34.06726], [-118.63743, 34.06707], [-118.63732, 34.06688], [-118.63682, 34.06615], [-118.6368, 34.0639], [-118.63872, 34.06381]]], [[[-118.6412, 34.07112], [-118.63685, 34.07104], [-118.63684, 34.06734], [-118.63682, 34.06638], [-118.6372, 34.06694], [-118.63734, 34.06719], [-118.63743, 34.06745], [-118.63753, 34.06815], [-118.63757, 34.06824], [-118.63769, 34.06835], [-118.63779, 34.06839], [-118.6379, 34.06842], [-118.63802, 34.06841], [-118.63813, 34.06838], [-118.63822, 34.06833], [-118.63873, 34.06798], [-118.63891, 34.06781], [-118.63899, 34.06768], [-118.63905, 34.06753], [-118.63907, 34.06739], [-118.63906, 34.06727], [-118.63866, 34.06595], [-118.63864, 34.06583], [-118.63865, 34.06571], [-118.63868, 34.06559], [-118.63881, 34.06534], [-118.63885, 34.06523], [-118.63885, 34.06506], [-118.63881, 34.06495], [-118.63873, 34.06486], [-118.63842, 34.06464], [-118.63837, 34.06458], [-118.63835, 34.06451], [-118.63837, 34.0644], [-118.63842, 34.06434], [-118.63869, 34.0642], [-118.63877, 34.06413], [-118.63883, 34.06405], [-118.64, 34.06447], [-118.63925, 34.0655], [-118.6393, 34.06626], [-118.64064, 34.06621], [-118.64081, 34.06651], [-118.6408, 34.06671], [-118.64082, 34.06681], [-118.64085, 34.06687], [-118.6409, 34.06691], [-118.641, 34.06695], [-118.64108, 34.06695], [-118.64117, 34.06692], [-118.6412, 34.07112]]]]} | Open Access 1 | 6431 | Las Flores Canyon Open Space | 21048 | 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 | Los Angeles 6 | 65.568 | Las Flores Canyon OS | 0 | Local Recreation Area 3 | 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]);