units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Lowell Brandt OS" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 1
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16050 | 16050 | 16049 | {"type": "Polygon", "coordinates": [[[-117.75625, 34.14581], [-117.75608, 34.14612], [-117.75606, 34.1465], [-117.7559, 34.14671], [-117.75581, 34.14696], [-117.75576, 34.14718], [-117.75548, 34.14745], [-117.75534, 34.14782], [-117.75531, 34.14803], [-117.75533, 34.14808], [-117.7552, 34.14819], [-117.75524, 34.1484], [-117.75505, 34.14856], [-117.75487, 34.14857], [-117.75472, 34.14875], [-117.75482, 34.14892], [-117.75468, 34.1491], [-117.75476, 34.1493], [-117.75475, 34.14939], [-117.75466, 34.1496], [-117.75471, 34.14968], [-117.75464, 34.14969], [-117.75458, 34.14974], [-117.75457, 34.14983], [-117.75459, 34.14985], [-117.75438, 34.14997], [-117.75442, 34.15017], [-117.75466, 34.1503], [-117.75451, 34.15059], [-117.75447, 34.15064], [-117.75451, 34.15091], [-117.75458, 34.15112], [-117.75445, 34.15137], [-117.75433, 34.15133], [-117.75407, 34.15117], [-117.75396, 34.1511], [-117.75385, 34.15099], [-117.75392, 34.15094], [-117.75395, 34.15081], [-117.75387, 34.15066], [-117.75382, 34.1506], [-117.75382, 34.15048], [-117.75378, 34.15044], [-117.75373, 34.15045], [-117.75362, 34.15056], [-117.7536, 34.15065], [-117.75345, 34.1507], [-117.75345, 34.15073], [-117.75327, 34.1507], [-117.75307, 34.15074], [-117.75289, 34.15083], [-117.75266, 34.15101], [-117.7525, 34.15106], [-117.75235, 34.15105], [-117.75196, 34.15096], [-117.75076, 34.15095], [-117.75079, 34.15093], [-117.75273, 34.15092], [-117.75483, 34.1482], [-117.75553, 34.14714], [-117.75565, 34.14638], [-117.75574, 34.14624], [-117.75582, 34.1461], [-117.75587, 34.14597], [-117.75591, 34.14577], [-117.75625, 34.14581]]]} | Open Access 1 | 6792 | Lowell Brandt Open Space | 21554 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 8.271 | Lowell Brandt 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]);