units_with_maps

Table actions

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

1 row where COUNTY = 23 and DES_TP = 154

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

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
1884 1884 1883 {"type": "MultiPolygon", "coordinates": [[[[-122.52606, 38.05916], [-122.52581, 38.05915], [-122.52559, 38.05905], [-122.52536, 38.05898], [-122.52502, 38.05895], [-122.52492, 38.05887], [-122.52492, 38.05882], [-122.52477, 38.05882], [-122.52476, 38.05887], [-122.52465, 38.05894], [-122.52381, 38.0589], [-122.5239, 38.0578], [-122.52378, 38.05772], [-122.52321, 38.05712], [-122.5231, 38.05716], [-122.52298, 38.05699], [-122.52259, 38.05723], [-122.52277, 38.05741], [-122.52277, 38.05745], [-122.52273, 38.05751], [-122.5228, 38.05758], [-122.52287, 38.05755], [-122.52292, 38.05757], [-122.5231, 38.05775], [-122.52282, 38.05791], [-122.52282, 38.0577], [-122.52251, 38.05774], [-122.52245, 38.05763], [-122.52236, 38.05756], [-122.52227, 38.05752], [-122.52215, 38.05749], [-122.52215, 38.05721], [-122.5225, 38.05698], [-122.5225, 38.05636], [-122.52225, 38.05605], [-122.52196, 38.05598], [-122.52157, 38.05609], [-122.52143, 38.05637], [-122.52132, 38.05668], [-122.52114, 38.057], [-122.5208, 38.05731], [-122.52076, 38.05765], [-122.52089, 38.05796], [-122.52089, 38.05839], [-122.5213, 38.05841], [-122.52127, 38.05875], [-122.51914, 38.05854], [-122.51906, 38.05851], [-122.51903, 38.05844], [-122.51913, 38.05822], [-122.51957, 38.05837], [-122.51967, 38.05814], [-122.51976, 38.05818], [-122.52088, 38.05685], [-122.52088, 38.05683], [-122.52042, 38.05659], [-122.52067, 38.0563], [-122.52091, 38.0561], [-122.52124, 38.05589], [-122.52156, 38.05577], [-122.52315, 38.05541], [-122.52456, 38.05763], [-122.52491, 38.05814], [-122.52524, 38.05854], [-122.52563, 38.05892], [-122.52565, 38.05894], [-122.52577, 38.05894], [-122.52606, 38.05916]]], [[[-122.53179, 38.06079], [-122.53147, 38.06072], [-122.53075, 38.06077], [-122.53046, 38.06068], [-122.53057, 38.05939], [-122.53088, 38.05941], [-122.53116, 38.05991], [-122.53131, 38.06015], [-122.53166, 38.06063], [-122.53179, 38.06079]]]]} Open Access 1 16079 Novato Lands 003 22914 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 19.741 Novato Lands 003   None 154  

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