units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where LABEL_NAME = "Sunset 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
317 | 317 | 316 | {"type": "Polygon", "coordinates": [[[-117.19286, 32.68822], [-117.19257, 32.68877], [-117.19138, 32.68843], [-117.19141, 32.68826], [-117.19088, 32.68812], [-117.19082, 32.68806], [-117.19121, 32.68742], [-117.19286, 32.68822]]]} | Open Access 1 | 851 | Sunset Park | 26052 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3816985 | San Diego 4 | 3.475 | Sunset Park | 0 | Local Park 2 | 4 |
451 | 451 | 450 | {"type": "Polygon", "coordinates": [[[-119.35845, 36.30491], [-119.35812, 36.30491], [-119.35813, 36.30483], [-119.35808, 36.30476], [-119.35794, 36.30469], [-119.35539, 36.30267], [-119.35521, 36.30254], [-119.35495, 36.30239], [-119.3547, 36.30229], [-119.35443, 36.30221], [-119.35415, 36.30216], [-119.35414, 36.30183], [-119.35841, 36.30181], [-119.35845, 36.30491]]]} | Open Access 1 | 1428 | Sunset Park | 26060 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 17.015 | Sunset Park | 0 | Local Park 2 | 4 | |
901 | 901 | 900 | {"type": "Polygon", "coordinates": [[[-117.66184, 33.46377], [-117.66182, 33.46383], [-117.66178, 33.46386], [-117.66149, 33.46387], [-117.66112, 33.46385], [-117.66082, 33.46378], [-117.66056, 33.4637], [-117.66027, 33.46356], [-117.66001, 33.46338], [-117.65999, 33.46335], [-117.65999, 33.46331], [-117.66022, 33.46318], [-117.66036, 33.46312], [-117.66068, 33.46302], [-117.66079, 33.46302], [-117.66101, 33.46308], [-117.66132, 33.46306], [-117.66136, 33.46309], [-117.66141, 33.46315], [-117.66184, 33.46377]]]} | Open Access 1 | 5800 | Sunset Park | 26053 | 1079 | Dana Point, City of 134 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | Orange 3 | 2.612 | Sunset Park | 0 | Local Park 2 | 4 | |
1467 | 1467 | 1466 | {"type": "Polygon", "coordinates": [[[-122.63156, 38.23591], [-122.63154, 38.23595], [-122.6314, 38.2361], [-122.63078, 38.23576], [-122.63084, 38.23571], [-122.63152, 38.23585], [-122.63156, 38.23591]]]} | Open Access 1 | 10033 | Sunset Park | 26058 | 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 | 0.319 | Sunset Park | 0 | Local Park 2 | 4 | |
1897 | 1897 | 1896 | {"type": "Polygon", "coordinates": [[[-117.7124, 34.06693], [-117.71125, 34.06835], [-117.71089, 34.06885], [-117.71064, 34.06924], [-117.71044, 34.06962], [-117.71025, 34.07001], [-117.71008, 34.07042], [-117.70919, 34.07041], [-117.70919, 34.06965], [-117.71004, 34.06965], [-117.71004, 34.06867], [-117.71071, 34.06867], [-117.71071, 34.06767], [-117.71141, 34.06767], [-117.71141, 34.06693], [-117.7124, 34.06693]]]} | Open Access 1 | 14596 | Sunset Park | 26057 | 1210 | Montclair, City of 55 | City 2 | City Agency 2 | http://www.ci.montclair.ca.us/ | City 2 | 1210 | Montclair, City of 53 | City 2 | City Agency 2 | San Bernardino 22 | 6.728 | Sunset Park | 0 | Local Park 2 | 4 | |
3905 | 3905 | 3904 | {"type": "Polygon", "coordinates": [[[-117.21535, 33.1462], [-117.21466, 33.14765], [-117.21064, 33.14621], [-117.21065, 33.14618], [-117.20942, 33.14575], [-117.21011, 33.1444], [-117.2111, 33.14476], [-117.21098, 33.145], [-117.21105, 33.14506], [-117.21106, 33.14505], [-117.21116, 33.14507], [-117.21124, 33.14505], [-117.21137, 33.14479], [-117.21238, 33.14513], [-117.21535, 33.1462]]]} | Open Access 1 | 45973 | Sunset Park | 29123 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/155/1081?npage=2 | San Diego 4 | 22.101 | Sunset Park | 0 | Local Park 2 | 4 |
4556 | 4556 | 4555 | {"type": "Polygon", "coordinates": [[[-119.56462, 36.51602], [-119.56445, 36.51602], [-119.56445, 36.51575], [-119.56462, 36.51574], [-119.56462, 36.51602]]]} | Open Access 1 | 29745 | Sunset Park | 26054 | 1153 | Kingsburg, City of 234 | City 2 | City Agency 2 | http://www.cityofkingsburg-ca.gov/ | City 2 | 1153 | Kingsburg, City of 230 | City 2 | City Agency 2 | Fresno 9 | 0.115 | Sunset Park | 0 | Local Park 2 | 4 | |
6774 | 6774 | 6773 | {"type": "Polygon", "coordinates": [[[-121.77487, 37.67169], [-121.77451, 37.67172], [-121.77298, 37.67169], [-121.77301, 37.67168], [-121.7731, 37.67089], [-121.77257, 37.6708], [-121.77246, 37.6697], [-121.77349, 37.66996], [-121.77483, 37.66997], [-121.77487, 37.67169]]]} | Open Access 1 | 5248 | Sunset Park | 26056 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 8.983 | Sunset Park | 0 | Local Park 2 | 4 | |
10694 | 10694 | 10693 | {"type": "Polygon", "coordinates": [[[-117.03893, 32.78198], [-117.03809, 32.78256], [-117.03789, 32.78231], [-117.03721, 32.78271], [-117.03707, 32.78275], [-117.03552, 32.78275], [-117.03549, 32.78274], [-117.03549, 32.78264], [-117.03552, 32.78261], [-117.03554, 32.78265], [-117.03558, 32.78267], [-117.03607, 32.78267], [-117.03583, 32.78238], [-117.03689, 32.78154], [-117.03893, 32.78174], [-117.03893, 32.78198]]]} | Open Access 1 | 19850 | Sunset Park | 26055 | 1157 | La Mesa, City of 50 | City 2 | City Agency 2 | http://www.cityoflamesa.com/index.aspx?nid=410 | City 2 | 1157 | La Mesa, City of 48 | City 2 | City Agency 2 | http://www.cityoflamesa.com/400/Sunset-Park | San Diego 4 | 6.322 | Sunset Park | 0 | Local Park 2 | 4 |
11707 | 11707 | 11706 | {"type": "Polygon", "coordinates": [[[-121.45555, 38.55759], [-121.45548, 38.55775], [-121.45419, 38.55739], [-121.45387, 38.55726], [-121.45385, 38.55722], [-121.45386, 38.55719], [-121.4539, 38.55718], [-121.4543, 38.55725], [-121.45555, 38.55759]]]} | Open Access 1 | 24004 | Sunset Park | 26059 | 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 | 0.633 | Sunset Park | 0 | Local Park 2 | 4 | |
12386 | 12386 | 12385 | {"type": "Polygon", "coordinates": [[[-115.56879, 32.85944], [-115.5669, 32.85942], [-115.56688, 32.85899], [-115.56679, 32.85842], [-115.56681, 32.8584], [-115.56731, 32.85833], [-115.56777, 32.85819], [-115.56803, 32.85807], [-115.56808, 32.85808], [-115.56825, 32.85827], [-115.5684, 32.85849], [-115.56853, 32.85871], [-115.56864, 32.85895], [-115.56879, 32.85944]]]} | Open Access 1 | 26525 | Sunset Park | 26061 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 5.149 | Sunset Park | 0 | Local Park 2 | 4 | |
12934 | 12934 | 12933 | {"type": "Polygon", "coordinates": [[[-117.77303, 33.98133], [-117.77296, 33.98135], [-117.77263, 33.98135], [-117.77241, 33.98147], [-117.77233, 33.98167], [-117.77232, 33.98176], [-117.77234, 33.98191], [-117.77243, 33.98203], [-117.77184, 33.98246], [-117.77171, 33.98266], [-117.77168, 33.98247], [-117.77163, 33.9823], [-117.77146, 33.98199], [-117.77142, 33.98185], [-117.77107, 33.98191], [-117.77105, 33.98179], [-117.77105, 33.98166], [-117.77107, 33.98152], [-117.77113, 33.98139], [-117.77143, 33.98149], [-117.77169, 33.98123], [-117.77202, 33.98112], [-117.77276, 33.98093], [-117.77282, 33.98112], [-117.77303, 33.98133]]]} | Open Access 1 | 30390 | Sunset Park | 26051 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.547 | Sunset Park | 0 | Local Park 2 | 4 | |
14509 | 14509 | 14508 | {"type": "Polygon", "coordinates": [[[-117.09846, 33.46835], [-117.09812, 33.46893], [-117.09775, 33.4688], [-117.09757, 33.46869], [-117.09743, 33.46855], [-117.09731, 33.46834], [-117.09734, 33.46829], [-117.09782, 33.46814], [-117.09819, 33.46799], [-117.09846, 33.46835]]]} | Open Access 1 | 47175 | Sunset Park | 30866 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/SunsetPark.htm | Riverside 10 | 1.613 | Sunset 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]);