superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where MNG_AG_TYP = 2 and PARK_NAME = "University Park"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9120 | 9120 | 9119 | {"type": "MultiPolygon", "coordinates": [[[[-121.40892, 38.56163], [-121.4089, 38.5621], [-121.40883, 38.56227], [-121.40819, 38.56243], [-121.40787, 38.5625], [-121.40788, 38.56186], [-121.40892, 38.56163]]], [[[-121.40901, 38.56247], [-121.40895, 38.5634], [-121.4079, 38.56338], [-121.40793, 38.56264], [-121.40833, 38.56256], [-121.40901, 38.56247]]]]} | Open Access 1 | University Park | 26687 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.716 | University Park | ||
10569 | 10569 | 10568 | {"type": "Polygon", "coordinates": [[[-122.30021, 37.88301], [-122.30014, 37.88322], [-122.30003, 37.88341], [-122.29993, 37.88366], [-122.29987, 37.88392], [-122.29984, 37.88409], [-122.29831, 37.88438], [-122.29793, 37.88322], [-122.29818, 37.88324], [-122.29967, 37.88294], [-122.30015, 37.88282], [-122.30021, 37.88301]]]} | Open Access 1 | University Park | 26684 | 1002 | Albany, City of 269 | City 2 | City Agency 2 | http://www.albanyca.org/index.aspx?page=473 | City 2 | 5.426 | University Park | ||
10573 | 10573 | 10572 | {"type": "Polygon", "coordinates": [[[-118.94539, 35.40501], [-118.94194, 35.40505], [-118.94195, 35.40379], [-118.94538, 35.40375], [-118.94539, 35.40501]]]} | Open Access 1 | University Park | 26685 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 10.769 | University Park | ||
10574 | 10574 | 10573 | {"type": "Polygon", "coordinates": [[[-119.77627, 36.79171], [-119.77626, 36.7921], [-119.77622, 36.79217], [-119.77614, 36.79222], [-119.77607, 36.79223], [-119.77477, 36.79223], [-119.77479, 36.79156], [-119.7761, 36.79158], [-119.77621, 36.79162], [-119.77627, 36.79171]]]} | Open Access 1 | University Park | 26686 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 2.375 | University 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]);