units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Arroyo Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1108 | 1108 | 1107 | {"type": "Polygon", "coordinates": [[[-117.8731, 34.02133], [-117.87255, 34.02166], [-117.87217, 34.02181], [-117.87142, 34.02188], [-117.87142, 34.02185], [-117.87131, 34.02164], [-117.87115, 34.02146], [-117.87151, 34.02124], [-117.87185, 34.02091], [-117.87297, 34.02127], [-117.8731, 34.02133]]]} | Open Access 1 | 7064 | Arroyo Park | 15620 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 2.705 | Arroyo Park | 0 | Local Park 2 | 4 | |
5355 | 5355 | 5354 | {"type": "Polygon", "coordinates": [[[-117.76603, 33.89034], [-117.76555, 33.89036], [-117.76559, 33.89099], [-117.76508, 33.89098], [-117.76459, 33.89093], [-117.7651, 33.88981], [-117.76432, 33.88951], [-117.76449, 33.8892], [-117.76455, 33.88903], [-117.7646, 33.88859], [-117.76459, 33.88828], [-117.76455, 33.88802], [-117.76447, 33.88778], [-117.76412, 33.8871], [-117.76407, 33.88694], [-117.76405, 33.88673], [-117.76424, 33.88674], [-117.76429, 33.88698], [-117.76439, 33.8872], [-117.76453, 33.88742], [-117.76492, 33.88793], [-117.76515, 33.88849], [-117.76528, 33.88861], [-117.76553, 33.8887], [-117.76599, 33.88867], [-117.76603, 33.89034]]]} | Open Access 1 | 24629 | Arroyo Park | 15621 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 8.695 | Arroyo Park | 0 | Local Park 2 | 4 | |
6857 | 6857 | 6856 | {"type": "Polygon", "coordinates": [[[-117.64807, 33.50789], [-117.64575, 33.50712], [-117.64569, 33.50699], [-117.64562, 33.50686], [-117.64549, 33.50672], [-117.64548, 33.50667], [-117.64553, 33.5066], [-117.64799, 33.50741], [-117.64799, 33.50758], [-117.64807, 33.50789]]]} | Open Access 1 | 5491 | Arroyo Park | 15617 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 2.77 | Arroyo Park | 0 | Local Park 2 | 4 | |
6858 | 6858 | 6857 | {"type": "Polygon", "coordinates": [[[-117.85946, 33.634], [-117.85948, 33.63441], [-117.85935, 33.63552], [-117.8593, 33.63562], [-117.85881, 33.63618], [-117.85882, 33.63629], [-117.85886, 33.63639], [-117.85897, 33.63653], [-117.85908, 33.6366], [-117.8592, 33.63664], [-117.85944, 33.63667], [-117.85941, 33.63701], [-117.85935, 33.637], [-117.85929, 33.63705], [-117.85887, 33.63704], [-117.85886, 33.63702], [-117.85886, 33.63682], [-117.85864, 33.63666], [-117.85845, 33.63648], [-117.85847, 33.63616], [-117.85839, 33.6359], [-117.85816, 33.63579], [-117.85774, 33.63521], [-117.85789, 33.63512], [-117.85802, 33.635], [-117.85815, 33.63486], [-117.85827, 33.63468], [-117.85839, 33.63443], [-117.85849, 33.6341], [-117.85852, 33.63394], [-117.85852, 33.63379], [-117.85849, 33.63353], [-117.85855, 33.63332], [-117.85855, 33.6332], [-117.85852, 33.63308], [-117.85843, 33.63287], [-117.85814, 33.63262], [-117.85808, 33.63219], [-117.85798, 33.63194], [-117.85789, 33.63179], [-117.85751, 33.63134], [-117.85764, 33.63115], [-117.8577, 33.63098], [-117.8577, 33.63074], [-117.85774, 33.63052], [-117.85773, 33.63018], [-117.85778, 33.62994], [-117.85796, 33.62978], [-117.85802, 33.62952], [-117.85859, 33.6296], [-117.85917, 33.62962], [-117.85907, 33.63001], [-117.85882, 33.63027], [-117.85856, 33.6306], [-117.8585, 33.63078], [-117.85849, 33.631], [-117.85853, 33.63122], [-117.85864, 33.63143], [-117.8588, 33.63161], [-117.85906, 33.63183], [-117.85915, 33.63232], [-117.8592, 33.63271], [-117.85925, 33.63289], [-117.85928, 33.6331], [-117.85939, 33.63344], [-117.8594, 33.63379], [-117.85938, 33.63397], [-117.85946, 33.634]]]} | Open Access 1 | 5492 | Arroyo Park | 15615 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 18.387 | Arroyo Park | 0 | Local Park 2 | 4 | |
7890 | 7890 | 7889 | {"type": "Polygon", "coordinates": [[[-122.60189, 38.24842], [-122.60042, 38.25008], [-122.59944, 38.24939], [-122.59941, 38.24942], [-122.59918, 38.24928], [-122.59886, 38.24905], [-122.59856, 38.24873], [-122.59857, 38.24867], [-122.59885, 38.24853], [-122.59953, 38.24827], [-122.59986, 38.24814], [-122.60036, 38.24785], [-122.60066, 38.24811], [-122.6009, 38.24786], [-122.60189, 38.24842]]]} | Open Access 1 | 9969 | Arroyo Park | 15616 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 9.34 | Arroyo Park | 0 | Local Park 2 | 4 | |
9178 | 9178 | 9177 | {"type": "Polygon", "coordinates": [[[-122.01505, 37.58006], [-122.01496, 37.58031], [-122.01471, 37.58083], [-122.01457, 37.58124], [-122.01436, 37.5812], [-122.01427, 37.58146], [-122.01417, 37.58145], [-122.01402, 37.58187], [-122.01386, 37.58184], [-122.01377, 37.58209], [-122.01357, 37.58208], [-122.01339, 37.5821], [-122.01323, 37.58214], [-122.01307, 37.5822], [-122.01285, 37.58233], [-122.01268, 37.58249], [-122.01305, 37.58141], [-122.01237, 37.58147], [-122.01179, 37.58158], [-122.0105, 37.58127], [-122.01077, 37.58047], [-122.01105, 37.58063], [-122.01219, 37.58083], [-122.01318, 37.5807], [-122.01314, 37.58062], [-122.0133, 37.58059], [-122.01383, 37.58023], [-122.01403, 37.57973], [-122.01455, 37.57985], [-122.01453, 37.57994], [-122.01505, 37.58006]]]} | Open Access 1 | 15237 | Arroyo Park | 15619 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 11.549 | Arroyo Park | 0 | Local Park 2 | 4 | |
9505 | 9505 | 9504 | {"type": "Polygon", "coordinates": [[[-118.79202, 34.27444], [-118.79152, 34.27402], [-118.79102, 34.27366], [-118.79083, 34.27355], [-118.79093, 34.27342], [-118.791, 34.27328], [-118.79202, 34.27328], [-118.79202, 34.27444]]]} | Open Access 1 | 15917 | Arroyo Park | 15622 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 2.006 | Arroyo Park | 0 | Local Park 2 | 4 | |
10958 | 10958 | 10957 | {"type": "Polygon", "coordinates": [[[-121.77799, 38.55534], [-121.77775, 38.55534], [-121.77774, 38.55503], [-121.77687, 38.55503], [-121.77686, 38.55534], [-121.77574, 38.55534], [-121.77573, 38.55531], [-121.77329, 38.55532], [-121.77308, 38.55532], [-121.77276, 38.55536], [-121.7727, 38.55533], [-121.77255, 38.55504], [-121.77236, 38.55479], [-121.77216, 38.55461], [-121.77188, 38.55442], [-121.77241, 38.55385], [-121.77637, 38.55388], [-121.77637, 38.55495], [-121.77781, 38.55495], [-121.77799, 38.55509], [-121.77799, 38.55534]]]} | Open Access 1 | 21017 | Arroyo Park | 15614 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 15.084 | Arroyo 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]);