units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where UNIT_NAME = "Canyon Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1596 | 1596 | 1595 | {"type": "Polygon", "coordinates": [[[-117.80729, 33.64338], [-117.80672, 33.64397], [-117.80653, 33.6441], [-117.80609, 33.64423], [-117.8057, 33.64424], [-117.8056, 33.64404], [-117.80559, 33.6439], [-117.80564, 33.64372], [-117.80575, 33.64351], [-117.80584, 33.6434], [-117.8064, 33.6429], [-117.80645, 33.6429], [-117.80729, 33.64338]]]} | Open Access 1 | 12168 | Canyon Park | 16824 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 3.434 | Canyon Park | 0 | Local Park 2 | 4 | |
4400 | 4400 | 4399 | {"type": "Polygon", "coordinates": [[[-117.90951, 34.14686], [-117.9095, 34.1481], [-117.90942, 34.14811], [-117.90929, 34.14758], [-117.90916, 34.14691], [-117.9092, 34.14685], [-117.90928, 34.14683], [-117.90951, 34.14683], [-117.90951, 34.14686]]]} | Open Access 1 | 46030 | Canyon Park | 29355 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 0.735 | Canyon Park | 0 | Local Park 2 | 4 | |
8677 | 8677 | 8676 | {"type": "Polygon", "coordinates": [[[-117.94388, 33.65053], [-117.94298, 33.65055], [-117.94297, 33.64956], [-117.94221, 33.64903], [-117.94242, 33.64852], [-117.94219, 33.64805], [-117.94197, 33.64801], [-117.94124, 33.64827], [-117.93923, 33.6483], [-117.93923, 33.64781], [-117.93995, 33.6472], [-117.93958, 33.64674], [-117.93878, 33.64692], [-117.93835, 33.64726], [-117.93812, 33.64802], [-117.93748, 33.64796], [-117.93643, 33.64778], [-117.93643, 33.64733], [-117.93741, 33.64732], [-117.93742, 33.64661], [-117.93774, 33.64661], [-117.93777, 33.64667], [-117.93798, 33.64664], [-117.93798, 33.64661], [-117.93818, 33.6466], [-117.93816, 33.64589], [-117.93925, 33.64587], [-117.93924, 33.64524], [-117.93875, 33.64428], [-117.93875, 33.64414], [-117.93984, 33.64411], [-117.93984, 33.64505], [-117.94018, 33.6457], [-117.9409, 33.64553], [-117.94173, 33.64553], [-117.94174, 33.64781], [-117.94383, 33.64781], [-117.94388, 33.65053]]]} | Open Access 1 | 14007 | Canyon Park | 16823 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 35.363 | Canyon Park | 0 | Local Park 2 | 4 | |
15132 | 15132 | 15131 | {"type": "Polygon", "coordinates": [[[-117.99065, 34.17244], [-117.99011, 34.1798], [-117.98605, 34.1798], [-117.98619, 34.17245], [-117.99065, 34.17244]]]} | Open Access 1 | 45952 | Canyon Park | 29061 | 1209 | Monrovia, City of 312 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/publicworks/page/parks | City 2 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/recreation/page/canyon-park | Los Angeles 6 | 79.128 | Canyon 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]);