superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

7 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and PARK_NAME = "Sierra Vista Park"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 7 ✖

ACCESS_TYP 1

  • Open Access · 7 ✖
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
9639 9639 9638 {"type": "Polygon", "coordinates": [[[-117.64859, 34.11782], [-117.6463, 34.11782], [-117.64629, 34.11663], [-117.64803, 34.11662], [-117.64805, 34.11672], [-117.64859, 34.11672], [-117.64859, 34.11782]]]} Open Access 1 Sierra Vista Park   25471 1363 Upland, City of 141 City 2 City Agency 2 http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp City 2 6.812 Sierra Vista Park  
9641 9641 9640 {"type": "Polygon", "coordinates": [[[-121.95816, 38.33944], [-121.95762, 38.3395], [-121.95738, 38.33972], [-121.95716, 38.33985], [-121.95692, 38.33969], [-121.95616, 38.33968], [-121.95527, 38.33976], [-121.95516, 38.33913], [-121.95519, 38.33875], [-121.95525, 38.33857], [-121.95572, 38.33855], [-121.9561, 38.33881], [-121.95629, 38.33868], [-121.95673, 38.33901], [-121.95731, 38.33858], [-121.95739, 38.33862], [-121.95781, 38.33829], [-121.9581, 38.33849], [-121.95813, 38.33907], [-121.95816, 38.33944]]]} Open Access 1 Sierra Vista Park   25472 1364 Vacaville, City of 147 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 7.156 Sierra Vista Park  
9648 9648 9647 {"type": "Polygon", "coordinates": [[[-116.16405, 33.68222], [-116.16403, 33.68328], [-116.16253, 33.68221], [-116.16253, 33.68221], [-116.16405, 33.68222]]]} Open Access 1 Sierra Vista Park   25467 1061 Coachella, City of 85 City 2 City Agency 2 http://www.coachella.org/departments/public-works-department/parks-maintenance City 2 2.041 Sierra Vista Park  
9649 9649 9648 {"type": "Polygon", "coordinates": [[[-118.11526, 34.0661], [-118.11415, 34.06611], [-118.11415, 34.06495], [-118.11462, 34.06495], [-118.11464, 34.06501], [-118.11526, 34.06501], [-118.11526, 34.0661]]]} Open Access 1 Sierra Vista Park   25468 1213 Monterey Park, City of 130 City 2 City Agency 2 http://www.ci.monterey-park.ca.us/ City 2 3.152 Sierra Vista Park  
9660 9660 9659 {"type": "MultiPolygon", "coordinates": [[[[-121.44531, 38.55478], [-121.44524, 38.55494], [-121.44395, 38.55458], [-121.44361, 38.55445], [-121.44357, 38.55443], [-121.44355, 38.55439], [-121.44357, 38.55436], [-121.44361, 38.55436], [-121.44391, 38.5544], [-121.44531, 38.55478]]], [[[-121.44712, 38.55534], [-121.44711, 38.55537], [-121.44708, 38.55539], [-121.44675, 38.55535], [-121.4454, 38.55498], [-121.44547, 38.55483], [-121.44679, 38.55519], [-121.44703, 38.55528], [-121.4471, 38.55531], [-121.44712, 38.55534]]]]} Open Access 1 Sierra Vista Park   25469 1287 Sacramento, City of 534 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 1.304 Sierra Vista Park  
9661 9661 9660 {"type": "Polygon", "coordinates": [[[-118.04186, 34.16395], [-118.04168, 34.16397], [-118.04169, 34.16473], [-118.0409, 34.16485], [-118.04029, 34.16292], [-118.03947, 34.16291], [-118.03944, 34.16382], [-118.03845, 34.16397], [-118.03844, 34.16205], [-118.04067, 34.16205], [-118.04068, 34.16203], [-118.04085, 34.16203], [-118.04085, 34.16236], [-118.04108, 34.16275], [-118.04149, 34.16309], [-118.04127, 34.1631], [-118.04128, 34.16392], [-118.04186, 34.16393], [-118.04186, 34.16395]]]} Open Access 1 Sierra Vista Park   25470 1333 Sierra Madre, City of 308 City 2 City Agency 2 http://www.cityofsierramadre.com/parks City 2 12.261 Sierra Vista Park  
13211 13211 13210 {"type": "Polygon", "coordinates": [[[-122.0896, 37.41713], [-122.08952, 37.41717], [-122.0891, 37.41714], [-122.089, 37.41649], [-122.08953, 37.41652], [-122.08961, 37.41709], [-122.0896, 37.41713]]]} Open Access 1 Sierra Vista Park https://www.mountainview.gov/depts/cs/parks/parks/city_parks.asp 33401 1218 Mountain View, City of 453 City 2 City Agency 2 http://www.ci.mtnview.ca.us/services/parks/default.asp City 2 0.813 Sierra Vista Park  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);