units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "320.047" and MNG_AG_TYP = 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7235 | 7235 | 7234 | {"type": "MultiPolygon", "coordinates": [[[[-117.9711, 33.97414], [-117.97033, 33.97501], [-117.96902, 33.97501], [-117.96879, 33.97516], [-117.96856, 33.97495], [-117.96849, 33.97498], [-117.96757, 33.9742], [-117.96722, 33.9738], [-117.96704, 33.97344], [-117.96865, 33.97343], [-117.9711, 33.97414]]], [[[-118.00131, 33.96455], [-118.00116, 33.96476], [-118.00086, 33.96505], [-118.00056, 33.96529], [-118.00022, 33.9656], [-117.99995, 33.96573], [-117.99909, 33.96585], [-117.99817, 33.96629], [-117.99774, 33.96624], [-117.99667, 33.96659], [-117.99639, 33.96663], [-117.99593, 33.96712], [-117.99495, 33.96767], [-117.9948, 33.96769], [-117.99422, 33.96798], [-117.99409, 33.96831], [-117.99383, 33.96841], [-117.99382, 33.96849], [-117.99213, 33.96952], [-117.99173, 33.9698], [-117.99137, 33.97011], [-117.98983, 33.97173], [-117.9895, 33.97202], [-117.98906, 33.97235], [-117.98858, 33.97265], [-117.98818, 33.97286], [-117.98643, 33.97368], [-117.98598, 33.9739], [-117.9854, 33.97424], [-117.98516, 33.9744], [-117.98477, 33.97468], [-117.98422, 33.97511], [-117.97765, 33.97509], [-117.97666, 33.97483], [-117.97664, 33.97254], [-117.97665, 33.96784], [-117.98953, 33.96796], [-117.98955, 33.96635], [-117.98955, 33.96502], [-117.98981, 33.96474], [-117.98999, 33.96459], [-117.99016, 33.96448], [-117.99378, 33.96454], [-118.00131, 33.96455]]]]} | Open Access 1 | 6520 | Arroyo San Miguel Open Space | 29672 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 320.047 | Arroyo San Miguel 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]);