units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, LABEL_NAME = "Kellogg Park" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130 | 130 | 129 | {"type": "Polygon", "coordinates": [[[-117.25801, 32.85566], [-117.25562, 32.85961], [-117.25539, 32.8596], [-117.25546, 32.85849], [-117.25734, 32.85536], [-117.25801, 32.85566]]]} | Open Access 1 | 324 | Kellogg Park | 20584 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/kelloggpark | San Diego 4 | 7.979 | Kellogg Park | 0 | Local Park 2 | 4 |
6523 | 6523 | 6522 | {"type": "Polygon", "coordinates": [[[-117.80958, 34.05732], [-117.80924, 34.05769], [-117.80883, 34.05801], [-117.80842, 34.05824], [-117.80809, 34.05839], [-117.80786, 34.05847], [-117.80618, 34.05741], [-117.80655, 34.05711], [-117.80708, 34.0573], [-117.80711, 34.05746], [-117.80747, 34.05747], [-117.8082, 34.05789], [-117.80899, 34.05708], [-117.80907, 34.05715], [-117.80915, 34.05719], [-117.80924, 34.0572], [-117.80934, 34.05717], [-117.80958, 34.05732]]]} | Open Access 1 | 2778 | Kellogg Park | 20583 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 4.928 | Kellogg Park | 0 | Local Park 2 | 4 | |
6716 | 6716 | 6715 | {"type": "Polygon", "coordinates": [[[-117.559, 33.8633], [-117.5584, 33.86365], [-117.55765, 33.86422], [-117.55735, 33.86439], [-117.5567, 33.86459], [-117.55642, 33.86477], [-117.55641, 33.86476], [-117.55712, 33.86398], [-117.55829, 33.86246], [-117.55841, 33.86232], [-117.559, 33.8633]]]} | Open Access 1 | 5678 | Kellogg Park | 20581 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 4.546 | Kellogg Park | 0 | Local Park 2 | 4 | |
9173 | 9173 | 9172 | {"type": "Polygon", "coordinates": [[[-122.14937, 37.44026], [-122.14842, 37.44053], [-122.14744, 37.43992], [-122.14798, 37.43938], [-122.14937, 37.44026]]]} | Open Access 1 | 15223 | Kellogg Park | 20582 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 2.513 | Kellogg Park | 1926 | Local Park 2 | 4 | |
11314 | 11314 | 11313 | {"type": "Polygon", "coordinates": [[[-119.29785, 34.29071], [-119.29772, 34.29114], [-119.2966, 34.29091], [-119.29648, 34.29126], [-119.29632, 34.29123], [-119.29642, 34.29087], [-119.2958, 34.29074], [-119.29592, 34.29032], [-119.29596, 34.2903], [-119.29736, 34.29059], [-119.2978, 34.29069], [-119.29785, 34.29071]]]} | Open Access 1 | 48050 | Kellogg Park | 32544 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.ca.gov/521/Kellogg-Park | Ventura 8 | 2.467 | Kellogg Park | 2012 | Local Park 2 | 4 |
12051 | 12051 | 12050 | {"type": "Polygon", "coordinates": [[[-121.40427, 37.71437], [-121.40422, 37.71452], [-121.40414, 37.71465], [-121.40387, 37.71489], [-121.40375, 37.71505], [-121.40367, 37.71508], [-121.40345, 37.71506], [-121.4029, 37.71505], [-121.40271, 37.71503], [-121.40249, 37.71498], [-121.40226, 37.71489], [-121.40213, 37.71481], [-121.402, 37.71469], [-121.40192, 37.71456], [-121.40197, 37.71449], [-121.40237, 37.7144], [-121.40278, 37.71424], [-121.40301, 37.7141], [-121.40327, 37.71391], [-121.40336, 37.71391], [-121.40379, 37.71416], [-121.404, 37.71424], [-121.40422, 37.7143], [-121.40427, 37.71437]]]} | Open Access 1 | 24732 | Kellogg Park | 20585 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 4.088 | Kellogg 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]);