units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 18, PARK_URL = "http://www.schollcanyongc.com/" and SUID_NMA = 29385
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17053 | 17053 | 17052 | {"type": "Polygon", "coordinates": [[[-118.20385, 34.15912], [-118.20364, 34.15913], [-118.20283, 34.15904], [-118.20265, 34.15903], [-118.20242, 34.15906], [-118.20215, 34.15918], [-118.20198, 34.15931], [-118.20187, 34.15946], [-118.20181, 34.15961], [-118.20163, 34.16029], [-118.20152, 34.16049], [-118.20134, 34.16069], [-118.20113, 34.16084], [-118.20035, 34.16128], [-118.19998, 34.16144], [-118.19952, 34.16158], [-118.19932, 34.16163], [-118.19902, 34.16167], [-118.19849, 34.16169], [-118.19592, 34.16158], [-118.19553, 34.16156], [-118.19518, 34.16157], [-118.19473, 34.16163], [-118.19442, 34.1617], [-118.19389, 34.16188], [-118.19365, 34.16167], [-118.19365, 34.16163], [-118.19384, 34.16147], [-118.19386, 34.16142], [-118.19384, 34.16133], [-118.19377, 34.1612], [-118.19376, 34.16113], [-118.19382, 34.16092], [-118.19381, 34.16077], [-118.19383, 34.16072], [-118.19397, 34.16063], [-118.19415, 34.16047], [-118.1942, 34.16046], [-118.19428, 34.16047], [-118.19437, 34.16057], [-118.19449, 34.16065], [-118.19459, 34.16067], [-118.19469, 34.16066], [-118.19481, 34.16059], [-118.19508, 34.16038], [-118.1952, 34.16036], [-118.19532, 34.16032], [-118.19559, 34.16013], [-118.19567, 34.16001], [-118.19576, 34.15995], [-118.19586, 34.15985], [-118.19589, 34.15979], [-118.1959, 34.1593], [-118.19593, 34.15921], [-118.19598, 34.15913], [-118.19606, 34.15906], [-118.19614, 34.15902], [-118.19629, 34.15897], [-118.1965, 34.15894], [-118.19678, 34.15894], [-118.19707, 34.15878], [-118.19761, 34.15832], [-118.19787, 34.15792], [-118.19805, 34.15789], [-118.1985, 34.1582], [-118.19855, 34.15817], [-118.19866, 34.15816], [-118.199, 34.15799], [-118.1992, 34.15792], [-118.19932, 34.15784], [-118.19949, 34.15777], [-118.19957, 34.1577], [-118.19971, 34.15763], [-118.19978, 34.1576], [-118.19992, 34.15761], [-118.20004, 34.15771], [-118.2004, 34.15772], [-118.20115, 34.15799], [-118.20281, 34.15819], [-118.20278, 34.1576], [-118.20345, 34.15779], [-118.20361, 34.15821], [-118.20366, 34.15888], [-118.20384, 34.15885], [-118.20385, 34.15912]]]} | Restricted Access 2 | 6955 | Scholl Canyon Golf Course & Tennis Center | 29385 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 6098 | American Golf 1103 | Private 7 | Commercial 18 | http://www.schollcanyongc.com/ | Los Angeles 6 | 60.199 | Scholl Canyon GC & Tennis Ctr. | None 1427 |
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]);