units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, LABEL_NAME = "Franklin Park" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1029 | 1029 | 1028 | {"type": "Polygon", "coordinates": [[[-118.02866, 33.75342], [-118.02769, 33.75342], [-118.02749, 33.75337], [-118.02741, 33.75339], [-118.02734, 33.75347], [-118.02707, 33.7534], [-118.02705, 33.75282], [-118.02729, 33.75282], [-118.02737, 33.75286], [-118.02739, 33.75291], [-118.02741, 33.75315], [-118.02825, 33.75314], [-118.02841, 33.75306], [-118.02866, 33.75306], [-118.02866, 33.75342]]]} | Open Access 1 | 5645 | Franklin Park | 19062 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 1.45 | Franklin Park | 0 | Local Park 2 | 4 | |
1754 | 1754 | 1753 | {"type": "Polygon", "coordinates": [[[-122.26219, 37.76826], [-122.26215, 37.76912], [-122.26062, 37.76844], [-122.26111, 37.76773], [-122.26212, 37.76817], [-122.26217, 37.76821], [-122.26219, 37.76826]]]} | Open Access 1 | 13146 | Franklin Park | 19060 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.958 | Franklin Park | 0 | Local Park 2 | 4 | |
1870 | 1870 | 1869 | {"type": "Polygon", "coordinates": [[[-119.51885, 34.40531], [-119.5185, 34.40564], [-119.51824, 34.40594], [-119.51806, 34.40622], [-119.51784, 34.40664], [-119.51779, 34.40679], [-119.51776, 34.40693], [-119.51755, 34.40688], [-119.51773, 34.40641], [-119.51825, 34.40559], [-119.51853, 34.40523], [-119.51885, 34.40531]]]} | Open Access 1 | 16019 | Franklin Park | 19061 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 1.02 | Franklin Park | 0 | Local Park 2 | 4 | |
3890 | 3890 | 3889 | {"type": "Polygon", "coordinates": [[[-117.16958, 34.03894], [-117.16953, 34.03899], [-117.1692, 34.03898], [-117.16895, 34.03895], [-117.1685, 34.03896], [-117.16833, 34.03888], [-117.16789, 34.03895], [-117.16768, 34.03903], [-117.16745, 34.03902], [-117.16736, 34.03898], [-117.16749, 34.03887], [-117.16759, 34.03883], [-117.1677, 34.03882], [-117.16952, 34.03886], [-117.16958, 34.03894]]]} | Open Access 1 | 640 | Franklin Park | 19064 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 0.649 | Franklin Park | 0 | Local Park 2 | 4 | |
6787 | 6787 | 6786 | {"type": "Polygon", "coordinates": [[[-122.71291, 38.46188], [-122.71241, 38.46199], [-122.71217, 38.46155], [-122.7115, 38.46172], [-122.70972, 38.46007], [-122.70965, 38.45995], [-122.71273, 38.45904], [-122.71291, 38.46188]]]} | Open Access 1 | 5286 | Franklin Park | 19066 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 13.313 | Franklin Park | 0 | Local Park 2 | 4 | |
8499 | 8499 | 8498 | {"type": "Polygon", "coordinates": [[[-122.24868, 37.79278], [-122.24791, 37.79333], [-122.24715, 37.79266], [-122.24792, 37.79211], [-122.24868, 37.79278]]]} | Open Access 1 | 13296 | Franklin Park | 19063 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 2.248 | Franklin Park | 0 | Local Park 2 | 4 | |
13285 | 13285 | 13284 | {"type": "Polygon", "coordinates": [[[-118.3602, 33.86163], [-118.35988, 33.86163], [-118.35987, 33.86189], [-118.359, 33.86189], [-118.359, 33.8606], [-118.3602, 33.8606], [-118.3602, 33.86163]]]} | Open Access 1 | 44082 | Franklin Park | 19065 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 3.734 | Franklin 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]);