units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "137.724", COUNTY = 4 and DES_TP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7772 | 7772 | 7771 | {"type": "MultiPolygon", "coordinates": [[[[-117.24181, 33.1531], [-117.24157, 33.15477], [-117.24103, 33.15465], [-117.24011, 33.15443], [-117.23977, 33.1544], [-117.23943, 33.15443], [-117.23913, 33.15449], [-117.23886, 33.15459], [-117.23805, 33.15504], [-117.23768, 33.15519], [-117.23643, 33.15551], [-117.23557, 33.15556], [-117.23476, 33.15575], [-117.2344, 33.15578], [-117.23438, 33.15308], [-117.23872, 33.15306], [-117.23868, 33.15112], [-117.23964, 33.15112], [-117.23971, 33.15153], [-117.24025, 33.15187], [-117.2404, 33.15165], [-117.24043, 33.15167], [-117.24028, 33.1519], [-117.24046, 33.15201], [-117.24049, 33.15202], [-117.2402, 33.15284], [-117.24043, 33.1531], [-117.24081, 33.15331], [-117.24103, 33.15331], [-117.24112, 33.1531], [-117.24181, 33.1531]], [[-117.23902, 33.15372], [-117.23903, 33.15371], [-117.23898, 33.15342], [-117.23861, 33.15346], [-117.23866, 33.15376], [-117.23902, 33.15372]]], [[[-117.24845, 33.15757], [-117.24813, 33.15766], [-117.24782, 33.15777], [-117.24752, 33.15792], [-117.24725, 33.15808], [-117.24699, 33.15827], [-117.24676, 33.15847], [-117.24655, 33.1587], [-117.24608, 33.15926], [-117.24576, 33.15956], [-117.24552, 33.15973], [-117.24524, 33.1599], [-117.24498, 33.16004], [-117.24471, 33.16016], [-117.24469, 33.15742], [-117.24413, 33.15763], [-117.24405, 33.1575], [-117.24393, 33.15739], [-117.24403, 33.15731], [-117.24402, 33.15677], [-117.24171, 33.15678], [-117.24241, 33.15172], [-117.24245, 33.15121], [-117.24243, 33.1507], [-117.24277, 33.15068], [-117.24341, 33.15037], [-117.24314, 33.14994], [-117.24335, 33.14987], [-117.24364, 33.14985], [-117.2441, 33.15058], [-117.24389, 33.15068], [-117.2428, 33.1508], [-117.24324, 33.15203], [-117.2473, 33.15188], [-117.24741, 33.15314], [-117.24722, 33.15314], [-117.24721, 33.15315], [-117.24745, 33.15677], [-117.2482, 33.15678], [-117.24845, 33.15757]], [[-117.24785, 33.15725], [-117.24772, 33.1573], [-117.24779, 33.15742], [-117.24769, 33.15748], [-117.24775, 33.15759], [-117.24799, 33.15749], [-117.24785, 33.15725]]], [[[-117.24736, 33.16176], [-117.24736, 33.16243], [-117.24402, 33.16245], [-117.24399, 33.1621], [-117.24405, 33.16206], [-117.24405, 33.1619], [-117.24411, 33.16187], [-117.24414, 33.16183], [-117.24471, 33.16182], [-117.24471, 33.16176], [-117.24736, 33.16176]]]]} | Open Access 1 | 47651 | Buena Vista Park | 16496 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.ci.vista.ca.us/home/showdocument?id=1170 | San Diego 4 | 137.724 | Buena Vista Park | 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]);