units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, LABEL_NAME = "Gateway Park" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1053 | 1053 | 1052 | {"type": "MultiPolygon", "coordinates": [[[[-117.92987, 33.61876], [-117.92979, 33.61914], [-117.92968, 33.6191], [-117.92985, 33.61876], [-117.92987, 33.61876]]], [[[-117.93059, 33.61792], [-117.93044, 33.61839], [-117.93035, 33.61837], [-117.93034, 33.61835], [-117.93036, 33.61789], [-117.93059, 33.61792]]]]} | Open Access 1 | 5654 | Gateway Park | 19238 | 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 | 0.272 | Gateway Park | 0 | Local Park 2 | 4 | |
1063 | 1063 | 1062 | {"type": "Polygon", "coordinates": [[[-117.24634, 33.96132], [-117.24471, 33.9628], [-117.24417, 33.96359], [-117.2441, 33.96359], [-117.24407, 33.96106], [-117.24632, 33.96104], [-117.24634, 33.96132]]]} | Open Access 1 | 5655 | Gateway Park | 19237 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 7.603 | Gateway Park | 0 | Local Park 2 | 4 | |
3060 | 3060 | 3059 | {"type": "Polygon", "coordinates": [[[-121.45678, 38.62592], [-121.45678, 38.62592], [-121.45334, 38.62588], [-121.45427, 38.62553], [-121.45533, 38.62505], [-121.4557, 38.62501], [-121.45639, 38.62499], [-121.45673, 38.62501], [-121.45678, 38.62592]]]} | Open Access 1 | 21082 | Gateway Park | 19239 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.014 | Gateway Park | 0 | Local Park 2 | 4 | |
7990 | 7990 | 7989 | {"type": "Polygon", "coordinates": [[[-122.17275, 38.0908], [-122.17251, 38.0911], [-122.17217, 38.09094], [-122.1725, 38.09066], [-122.17275, 38.0908]]]} | Open Access 1 | 10955 | Gateway Park | 19236 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 0.309 | Gateway Park | 0 | Local Park 2 | 4 | |
14956 | 14956 | 14955 | {"type": "Polygon", "coordinates": [[[-120.55955, 38.07348], [-120.55892, 38.07348], [-120.55892, 38.07354], [-120.55864, 38.07366], [-120.5587, 38.07358], [-120.55857, 38.07303], [-120.55837, 38.07291], [-120.55911, 38.07285], [-120.55944, 38.07326], [-120.55955, 38.07348]]]} | Open Access 1 | 45562 | Gateway Park | 28390 | 1447 | Angels Camp, City of 1006 | City 2 | City Agency 2 | http://www.angelscamp.gov/ | City 2 | 1447 | Angels Camp, City of 969 | City 2 | City Agency 2 | http://angelscamp.gov/files/12_Parks%20&%20Recreation.pdf | Calaveras 53 | 1.194 | Gateway Park | 0 | Local Park 2 | 4 |
15202 | 15202 | 15201 | {"type": "Polygon", "coordinates": [[[-118.36291, 33.74101], [-118.36226, 33.74149], [-118.36219, 33.74153], [-118.36209, 33.74152], [-118.36185, 33.74174], [-118.36172, 33.74183], [-118.36049, 33.74264], [-118.36037, 33.74271], [-118.36009, 33.74282], [-118.35993, 33.74286], [-118.3599, 33.74268], [-118.35989, 33.74249], [-118.36001, 33.74045], [-118.36009, 33.7404], [-118.36045, 33.74054], [-118.3608, 33.74065], [-118.36132, 33.74078], [-118.36291, 33.74101]]]} | Open Access 1 | 46082 | Gateway Park | 29425 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 9.456 | Gateway 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]);