superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, ACRES = "0.176" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4037 | 4037 | 4036 | {"type": "Polygon", "coordinates": [[[-118.38316, 33.85905], [-118.38291, 33.85906], [-118.38291, 33.85878], [-118.38315, 33.85878], [-118.38316, 33.85905]]]} | Open Access 1 | Ensenada Parkette | 18681 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.176 | Ensenada Parkette | ||
4726 | 4726 | 4725 | {"type": "Polygon", "coordinates": [[[-118.37763, 33.86101], [-118.37763, 33.86143], [-118.37747, 33.86143], [-118.37746, 33.86101], [-118.37763, 33.86101]]]} | Open Access 1 | La Paz Parkette | 20785 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.176 | La Paz Parkette | ||
9331 | 9331 | 9330 | {"type": "Polygon", "coordinates": [[[-120.42993, 34.90438], [-120.4295, 34.90438], [-120.42947, 34.90435], [-120.42977, 34.90426], [-120.42977, 34.90424], [-120.42937, 34.90378], [-120.42935, 34.90377], [-120.42912, 34.90348], [-120.42901, 34.90343], [-120.42909, 34.90341], [-120.42993, 34.90438]]]} | Open Access 1 | Santa Maria holding 6 | 25110 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 0.176 | Santa Maria holding 6 | ||
10700 | 10700 | 10699 | {"type": "Polygon", "coordinates": [[[-119.29875, 34.30564], [-119.29856, 34.30616], [-119.29808, 34.30606], [-119.29829, 34.30606], [-119.29848, 34.30599], [-119.29856, 34.30592], [-119.29862, 34.30585], [-119.29869, 34.30563], [-119.29875, 34.30564]]]} | Open Access 1 | Ventura holding 12 | 26874 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 0.176 | Ventura holding 12 | ||
10905 | 10905 | 10904 | {"type": "Polygon", "coordinates": [[[-118.64244, 34.1297], [-118.64235, 34.12973], [-118.64225, 34.12975], [-118.6422, 34.12974], [-118.64217, 34.12971], [-118.64215, 34.12964], [-118.64215, 34.1295], [-118.64224, 34.12948], [-118.64238, 34.12949], [-118.64244, 34.12954], [-118.64246, 34.12966], [-118.64244, 34.1297]]]} | Open Access 1 | Highlands Park | http://www.cityofcalabasas.com/vtour/highlands/highlands.html | 29426 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 0.176 | Highlands Park | |
12512 | 12512 | 12511 | {"type": "Polygon", "coordinates": [[[-118.39439, 34.08904], [-118.39439, 34.08904], [-118.39388, 34.08937], [-118.39391, 34.08929], [-118.39389, 34.08915], [-118.39396, 34.08911], [-118.39396, 34.08907], [-118.394, 34.08902], [-118.39408, 34.08905], [-118.39417, 34.08907], [-118.39427, 34.08906], [-118.39437, 34.08902], [-118.39439, 34.08904]]]} | Open Access 1 | Sierra Park | 29604 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 0.176 | Sierra Park | ||
13490 | 13490 | 13489 | {"type": "Polygon", "coordinates": [[[-121.73123, 38.54961], [-121.73123, 38.54972], [-121.73057, 38.5497], [-121.73057, 38.54959], [-121.73123, 38.54961]]]} | Open Access 1 | N Street Mini-Park | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/40/2926?npage=3 | 30908 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.176 | N Street Mini-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]);