superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2 and MNG_AGENCY = 174

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Walnut Creek, City of · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
10608 10608 10607 {"type": "Polygon", "coordinates": [[[-122.01457, 37.93282], [-122.01322, 37.93363], [-122.01205, 37.93236], [-122.01398, 37.93158], [-122.01414, 37.93182], [-122.01456, 37.93195], [-122.01454, 37.93209], [-122.01455, 37.93222], [-122.01416, 37.93238], [-122.01457, 37.93282]]]} Restricted Access 2 Valle Verde Park   26771 1371 Walnut Creek, City of 174 City 2 City Agency 2 http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp City 2 6.867 Valle Verde Park  
13217 13217 13216 {"type": "Polygon", "coordinates": [[[-122.0059, 37.9266], [-122.00588, 37.92724], [-122.00532, 37.92828], [-122.0051, 37.92889], [-122.00468, 37.92966], [-122.00455, 37.92973], [-122.00424, 37.92981], [-122.00406, 37.92996], [-122.00278, 37.93026], [-122.00219, 37.9292], [-121.99905, 37.92943], [-121.99763, 37.92762], [-121.99599, 37.92776], [-121.99374, 37.92453], [-121.99457, 37.92375], [-121.99637, 37.9236], [-121.99942, 37.92264], [-122.00486, 37.92176], [-122.00508, 37.9224], [-122.0052, 37.92451], [-122.00519, 37.92546], [-122.0054, 37.9259], [-122.00549, 37.92588], [-122.00561, 37.92605], [-122.0059, 37.9266]]]} Restricted Access 2 Boundary Oak Golf Course   33081 1371 Walnut Creek, City of 174 City 2 City Agency 2 http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp City 2 159.595 Boundary Oak GC  

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