units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AG_TYP = 6 and UNIT_NAME = "Las Flores Canyon Open Space"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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]);