units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AGENCY = 100 and UNIT_NAME = "Brand 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16237 | 16237 | 16236 | {"type": "Polygon", "coordinates": [[[-118.28033, 34.19262], [-118.27496, 34.19266], [-118.27505, 34.20609], [-118.2751, 34.20718], [-118.27514, 34.20974], [-118.27513, 34.211], [-118.2747, 34.2106], [-118.27456, 34.21049], [-118.27419, 34.21017], [-118.27382, 34.20931], [-118.27345, 34.20873], [-118.27305, 34.20791], [-118.27354, 34.20634], [-118.27271, 34.20513], [-118.27144, 34.20385], [-118.26751, 34.20362], [-118.26625, 34.20347], [-118.26623, 34.20192], [-118.26608, 34.19554], [-118.26606, 34.19274], [-118.26591, 34.18029], [-118.26627, 34.18037], [-118.26633, 34.18021], [-118.26621, 34.17987], [-118.26642, 34.1796], [-118.26652, 34.17912], [-118.26684, 34.17878], [-118.26688, 34.17833], [-118.26999, 34.17828], [-118.27, 34.17892], [-118.27013, 34.17915], [-118.27127, 34.17875], [-118.27158, 34.17918], [-118.27142, 34.17932], [-118.27165, 34.17944], [-118.27193, 34.17949], [-118.27224, 34.1794], [-118.2728, 34.17963], [-118.27313, 34.17937], [-118.27345, 34.17935], [-118.27369, 34.1791], [-118.27402, 34.17917], [-118.27439, 34.1793], [-118.27466, 34.17951], [-118.27447, 34.17966], [-118.27465, 34.17982], [-118.27507, 34.1797], [-118.27491, 34.1839], [-118.27639, 34.18401], [-118.27734, 34.18474], [-118.27721, 34.18501], [-118.27736, 34.18508], [-118.27614, 34.18742], [-118.27562, 34.18829], [-118.27604, 34.18854], [-118.27822, 34.18973], [-118.27752, 34.19051], [-118.2778, 34.19073], [-118.27813, 34.19035], [-118.27876, 34.19003], [-118.27998, 34.1907], [-118.28032, 34.19087], [-118.28033, 34.19262]]]} | Open Access 1 | 46045 | Brand Canyon Open Space | 29367 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 651.63 | Brand 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]);