units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and UNIT_NAME = "Rotary Centennial Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2951 | 2951 | 2950 | {"type": "Polygon", "coordinates": [[[-118.16535, 33.78974], [-118.16492, 33.78974], [-118.16342, 33.78877], [-118.16342, 33.78849], [-118.16535, 33.78974]]]} | Open Access 1 | 20230 | Rotary Centennial Park | 24683 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.209 | Rotary Centennial Park | 0 | Local Park 2 | 4 | |
9695 | 9695 | 9694 | {"type": "Polygon", "coordinates": [[[-120.94402, 37.72135], [-120.94378, 37.72263], [-120.94364, 37.72261], [-120.94344, 37.72254], [-120.94332, 37.72247], [-120.94323, 37.72238], [-120.94295, 37.72195], [-120.94286, 37.72178], [-120.94273, 37.72141], [-120.9432, 37.72103], [-120.94338, 37.72114], [-120.94358, 37.72124], [-120.94379, 37.72131], [-120.94402, 37.72135]]]} | Open Access 1 | 47893 | Rotary Centennial Park | 31850 | 1278 | Riverbank, City of 41 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/facilities/facility/details/Rotary-Centennial-Park-11 | Stanislaus 2 | 3.1 | Rotary Centennial Park | 0 | Local Park 2 | 4 |
12585 | 12585 | 12584 | {"type": "Polygon", "coordinates": [[[-121.23267, 36.33082], [-121.23205, 36.33118], [-121.23168, 36.33074], [-121.2323, 36.33039], [-121.23235, 36.33039], [-121.23263, 36.33072], [-121.23267, 36.33082]]]} | Open Access 1 | 29155 | Rotary Centennial Park | 30769 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 1.022 | Rotary Centennial Park | 0 | Local Park 2 | 4 | |
14316 | 14316 | 14315 | {"type": "Polygon", "coordinates": [[[-120.42735, 34.90903], [-120.42735, 34.90909], [-120.42706, 34.90914], [-120.42679, 34.90928], [-120.42667, 34.9093], [-120.42662, 34.90934], [-120.42659, 34.90939], [-120.42658, 34.90946], [-120.4266, 34.9095], [-120.42666, 34.90955], [-120.42676, 34.90958], [-120.42681, 34.90964], [-120.42687, 34.90985], [-120.42686, 34.91008], [-120.42682, 34.91013], [-120.42677, 34.91014], [-120.42642, 34.91004], [-120.42574, 34.90993], [-120.42563, 34.90995], [-120.42555, 34.91002], [-120.42552, 34.91011], [-120.4256, 34.91064], [-120.42562, 34.91174], [-120.42566, 34.91186], [-120.42572, 34.91196], [-120.42483, 34.91231], [-120.42424, 34.91125], [-120.42413, 34.91101], [-120.42406, 34.91076], [-120.42401, 34.9105], [-120.424, 34.91033], [-120.424, 34.90909], [-120.42409, 34.90902], [-120.42735, 34.90903]]]} | Open Access 1 | 44279 | Rotary Centennial Park | 24684 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 14.36 | Rotary Centennial 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]);