superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1 and ACRES = "0.599"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 5
ACCESS_TYP 1
- Open Access · 5 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3782 | 3782 | 3781 | {"type": "Polygon", "coordinates": [[[-121.43954, 38.54796], [-121.43925, 38.54796], [-121.43924, 38.54707], [-121.43947, 38.54706], [-121.43948, 38.5472], [-121.43953, 38.54721], [-121.43954, 38.54796]]]} | Open Access 1 | Greenfair Park | 19476 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.599 | Greenfair Park | ||
7171 | 7171 | 7170 | {"type": "Polygon", "coordinates": [[[-117.94442, 33.91445], [-117.94432, 33.91452], [-117.94376, 33.91451], [-117.94376, 33.91415], [-117.94441, 33.91415], [-117.94442, 33.91445]]]} | Open Access 1 | Montwood Park | 22445 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 0.599 | Montwood Park | ||
8264 | 8264 | 8263 | {"type": "Polygon", "coordinates": [[[-117.64544, 33.44089], [-117.64521, 33.44122], [-117.64472, 33.44093], [-117.64482, 33.44062], [-117.64519, 33.44075], [-117.64544, 33.44089]]]} | Open Access 1 | Poche Beach Park | 23820 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.599 | Poche Beach Park | ||
10012 | 10012 | 10011 | {"type": "Polygon", "coordinates": [[[-117.38275, 33.19269], [-117.38235, 33.19291], [-117.38201, 33.19252], [-117.3824, 33.19229], [-117.38275, 33.19269]]]} | Open Access 1 | Strand Beach Park (Seagaze Park) | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#42 | 25906 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 0.599 | Strand Beach Park (Seagaze Park) | |
11420 | 11420 | 11419 | {"type": "Polygon", "coordinates": [[[-116.21195, 33.69645], [-116.2112, 33.69645], [-116.21119, 33.69617], [-116.21124, 33.69613], [-116.21187, 33.69613], [-116.21195, 33.6962], [-116.21195, 33.69645]]]} | Open Access 1 | Ye'we'vichem Park | 27766 | 1061 | Coachella, City of 85 | City 2 | City Agency 2 | http://www.coachella.org/departments/public-works-department/parks-maintenance | City 2 | 0.599 | Ye'we'vichem Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);