units_with_maps

Table actions

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

2 rows where COUNTY = 45 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

Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
4059 4059 4058 {"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.14301, 41.05823], [-124.14301, 41.05837], [-124.14057, 41.05836], [-124.14055, 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 44400 Tsurai Village 26557 1664 Trinidad, City of 718 City 2 City Agency 2 http://www.trinidad.ca.gov/ City 2 1664 Trinidad, City of 701 City 2 City Agency 2   Humboldt 45 11.477 Tsurai Village   None 351  
13968 13968 13967 {"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.15021, 41.05434], [-124.15022, 41.05435], [-124.15082, 41.05449], [-124.15108, 41.05383], [-124.15048, 41.05369], [-124.15021, 41.05434]]]} Open Access 1 36634 Trinidad holding 1 26538 1664 Trinidad, City of 718 City 2 City Agency 2 http://www.trinidad.ca.gov/ City 2 1664 Trinidad, City of 701 City 2 City Agency 2   Humboldt 45 45.982 Trinidad holding 1 0 Local Other or Unknown 14 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);