superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1 and MNG_AGENCY = 701

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Trinidad, City of · 2 ✖

ACCESS_TYP 1

  • Open 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
10461 10461 10460 {"type": "Polygon", "coordinates": [[[-124.15321, 41.05423], [-124.15271, 41.05488], [-124.15229, 41.05661], [-124.15206, 41.05669], [-124.15203, 41.05709], [-124.14985, 41.05669], [-124.14873, 41.05627], [-124.14866, 41.05582], [-124.14772, 41.05465], [-124.14731, 41.05383], [-124.14725, 41.05301], [-124.14791, 41.0522], [-124.14977, 41.0522], [-124.15099, 41.05294], [-124.15272, 41.05295], [-124.15297, 41.05333], [-124.1532, 41.05337], [-124.15321, 41.05423]], [[-124.15022, 41.05434], [-124.15023, 41.05436], [-124.15082, 41.05448], [-124.15107, 41.05383], [-124.15048, 41.0537], [-124.15022, 41.05434]]]} Open Access 1 Trinidad holding 1   26538 1664 Trinidad, City of 701 City 2 City Agency 2 http://www.trinidad.ca.gov/ City 2 45.998 Trinidad holding 1  
10473 10473 10472 {"type": "Polygon", "coordinates": [[[-124.14507, 41.05769], [-124.14489, 41.05781], [-124.14479, 41.05795], [-124.14489, 41.05811], [-124.14453, 41.05839], [-124.14421, 41.05841], [-124.14377, 41.0584], [-124.1432, 41.05837], [-124.14317, 41.05823], [-124.14302, 41.05823], [-124.14301, 41.05837], [-124.14057, 41.05836], [-124.14054, 41.05825], [-124.13974, 41.05835], [-124.1395, 41.05884], [-124.13923, 41.05903], [-124.13892, 41.05909], [-124.13916, 41.05822], [-124.14054, 41.05772], [-124.14055, 41.05731], [-124.14186, 41.05739], [-124.14207, 41.0573], [-124.1432, 41.05748], [-124.14409, 41.05757], [-124.1448, 41.05732], [-124.14507, 41.05769]]]} Open Access 1 Tsurai Village   26557 1664 Trinidad, City of 701 City 2 City Agency 2 http://www.trinidad.ca.gov/ City 2 11.487 Tsurai Village  

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