units_with_maps

Table actions

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

1 row where AGNCY_NAME = 444 and DES_TP = 836

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
9687 9687 9686 {"type": "MultiPolygon", "coordinates": [[[[-122.5738, 38.0748], [-122.57374, 38.07513], [-122.57352, 38.07506], [-122.57336, 38.07513], [-122.57324, 38.07511], [-122.573, 38.07515], [-122.57284, 38.07521], [-122.57273, 38.07555], [-122.57268, 38.07576], [-122.57249, 38.07592], [-122.57248, 38.07599], [-122.5722, 38.07595], [-122.5721, 38.07578], [-122.57194, 38.07573], [-122.57167, 38.0758], [-122.5714, 38.07568], [-122.57062, 38.07526], [-122.57063, 38.07523], [-122.57048, 38.0751], [-122.57043, 38.07504], [-122.57041, 38.07497], [-122.57026, 38.07492], [-122.56982, 38.07491], [-122.56971, 38.07493], [-122.56939, 38.07488], [-122.56978, 38.07457], [-122.56949, 38.07437], [-122.56952, 38.07418], [-122.5694, 38.07399], [-122.56918, 38.07393], [-122.56931, 38.0739], [-122.56954, 38.07392], [-122.56959, 38.07422], [-122.56954, 38.07433], [-122.56957, 38.07437], [-122.56999, 38.07469], [-122.57064, 38.07463], [-122.57077, 38.07471], [-122.57079, 38.07478], [-122.57077, 38.07488], [-122.57077, 38.07494], [-122.57087, 38.07498], [-122.57081, 38.07504], [-122.571, 38.07516], [-122.57106, 38.07526], [-122.57141, 38.07545], [-122.57158, 38.07541], [-122.57234, 38.07557], [-122.57264, 38.07508], [-122.57294, 38.07492], [-122.57327, 38.07489], [-122.57352, 38.07477], [-122.5738, 38.0748]]], [[[-122.57278, 38.07419], [-122.57273, 38.0745], [-122.57254, 38.0746], [-122.57232, 38.07466], [-122.57233, 38.07451], [-122.57161, 38.07445], [-122.57157, 38.07466], [-122.57147, 38.07468], [-122.57103, 38.07453], [-122.57073, 38.07435], [-122.57078, 38.07402], [-122.57278, 38.07419]]]]} Open Access 1 16355 Novato Lands 004 22915 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 5.723 Novato Lands 004   None 836  

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