units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 2, LABEL_NAME = "Eaton Canyon Natural Area Park and Nature Ctr." and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17029 | 17029 | 17028 | {"type": "MultiPolygon", "coordinates": [[[[-118.10512, 34.19263], [-118.10495, 34.19317], [-118.1048, 34.19329], [-118.10424, 34.19328], [-118.10399, 34.19293], [-118.10371, 34.19231], [-118.10354, 34.19237], [-118.1038, 34.193], [-118.104, 34.19328], [-118.10044, 34.19324], [-118.10041, 34.1896], [-118.10041, 34.18951], [-118.10037, 34.18595], [-118.10038, 34.18582], [-118.10173, 34.18646], [-118.10183, 34.18719], [-118.1017, 34.1876], [-118.10216, 34.18872], [-118.10269, 34.18896], [-118.10291, 34.18931], [-118.10293, 34.18951], [-118.10319, 34.19046], [-118.10314, 34.19063], [-118.10327, 34.19076], [-118.10336, 34.19121], [-118.10395, 34.19177], [-118.10426, 34.19224], [-118.10479, 34.19236], [-118.10512, 34.19263]]], [[[-118.10571, 34.19254], [-118.10563, 34.19268], [-118.10553, 34.1927], [-118.10502, 34.19312], [-118.10516, 34.19262], [-118.10481, 34.19233], [-118.10428, 34.19222], [-118.10398, 34.19175], [-118.10339, 34.1912], [-118.10331, 34.19075], [-118.10319, 34.19062], [-118.10324, 34.19046], [-118.10298, 34.18951], [-118.10295, 34.1893], [-118.10272, 34.18893], [-118.1022, 34.1887], [-118.10175, 34.18759], [-118.10186, 34.1872], [-118.10176, 34.18644], [-118.10069, 34.18594], [-118.10038, 34.18578], [-118.10038, 34.18574], [-118.10068, 34.18593], [-118.10069, 34.18592], [-118.10079, 34.18485], [-118.10155, 34.18475], [-118.101, 34.18412], [-118.10077, 34.18394], [-118.10058, 34.18376], [-118.10078, 34.1839], [-118.10092, 34.18397], [-118.10117, 34.18406], [-118.10152, 34.18424], [-118.10166, 34.18435], [-118.10214, 34.1848], [-118.10237, 34.18498], [-118.10214, 34.18519], [-118.10241, 34.18574], [-118.10243, 34.18574], [-118.10251, 34.18568], [-118.10281, 34.18591], [-118.10321, 34.18648], [-118.10296, 34.18664], [-118.10296, 34.18666], [-118.10326, 34.18664], [-118.10359, 34.18659], [-118.10361, 34.18666], [-118.10381, 34.18697], [-118.10372, 34.18768], [-118.10397, 34.18819], [-118.10412, 34.18822], [-118.10441, 34.18852], [-118.10486, 34.18921], [-118.10493, 34.18974], [-118.10492, 34.19033], [-118.10482, 34.19037], [-118.10459, 34.19071], [-118.10473, 34.19087], [-118.10491, 34.19087], [-118.10491, 34.19109], [-118.10516, 34.19141], [-118.10541, 34.19194], [-118.10545, 34.19211], [-118.10571, 34.19254]]], [[[-118.10683, 34.19331], [-118.1061, 34.19332], [-118.10604, 34.1933], [-118.1053, 34.1933], [-118.10529, 34.19326], [-118.10508, 34.1933], [-118.10505, 34.19327], [-118.10561, 34.19283], [-118.10575, 34.1928], [-118.10589, 34.19253], [-118.10561, 34.19205], [-118.10558, 34.19192], [-118.10588, 34.19227], [-118.10683, 34.19331]]]]} | Open Access 1 | 48133 | Eaton Canyon Natural Area Park and Nature Center | 32658 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | https://www.ecnca.org/index.php | Los Angeles 6 | 82.896 | Eaton Canyon Natural Area Park and Nature Ctr. | 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]);