superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, LAYER = 10 and MNG_AGENCY = 491

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 3 ✖
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
9394 9394 9393 {"type": "Polygon", "coordinates": [[[-119.91557, 36.85121], [-119.91115, 36.85122], [-119.91114, 36.8488], [-119.91467, 36.84879], [-119.91557, 36.84957], [-119.91557, 36.85121]]]} Open Access 1 Schneider Property   25186 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10 http://www.riverparkway.org Non Governmental Organization 10 25.33 Schneider Property  
10179 10179 10178 {"type": "Polygon", "coordinates": [[[-119.83687, 36.85657], [-119.83636, 36.85653], [-119.83406, 36.8556], [-119.83382, 36.85617], [-119.83164, 36.85548], [-119.82957, 36.85468], [-119.82958, 36.85894], [-119.82911, 36.85877], [-119.82676, 36.85836], [-119.82546, 36.85798], [-119.82482, 36.85787], [-119.82444, 36.85787], [-119.82146, 36.85849], [-119.82124, 36.85821], [-119.82014, 36.85846], [-119.82014, 36.85839], [-119.82013, 36.85838], [-119.81682, 36.85918], [-119.81609, 36.85969], [-119.81549, 36.85966], [-119.81521, 36.85915], [-119.8137, 36.85798], [-119.8133, 36.85721], [-119.8141, 36.85621], [-119.81385, 36.85511], [-119.81452, 36.85355], [-119.81774, 36.85267], [-119.81816, 36.85175], [-119.81874, 36.85089], [-119.81827, 36.85053], [-119.81819, 36.84968], [-119.82062, 36.84889], [-119.82609, 36.8502], [-119.82888, 36.85138], [-119.82983, 36.85209], [-119.83077, 36.85256], [-119.83253, 36.85338], [-119.8334, 36.85372], [-119.83687, 36.85657]]]} Open Access 1 Sycamore Island   26131 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10 http://www.riverparkway.org Non Governmental Organization 10 328.724 Sycamore Island  
15599 15599 15598 {"type": "Polygon", "coordinates": [[[-119.75792, 36.91239], [-119.75661, 36.91246], [-119.75643, 36.91024], [-119.75775, 36.91023], [-119.75792, 36.91239]]]} Open Access 1 River Center   24407 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10 http://www.riverparkway.org Non Governmental Organization 10 7.034 River Ctr.  

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