units_with_maps

Table actions

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

1 row where AGNCY_NAME = 391 and DES_TP = 716

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
8573 8573 8572 {"type": "Polygon", "coordinates": [[[-121.96645, 37.94232], [-121.96608, 37.94253], [-121.96599, 37.94254], [-121.96473, 37.94158], [-121.96454, 37.94147], [-121.96421, 37.94134], [-121.96412, 37.94126], [-121.96395, 37.94126], [-121.96372, 37.94122], [-121.96345, 37.94119], [-121.96335, 37.94117], [-121.96308, 37.94116], [-121.96301, 37.94113], [-121.963, 37.9411], [-121.96298, 37.94078], [-121.96303, 37.94049], [-121.96311, 37.94021], [-121.96344, 37.93939], [-121.96352, 37.93926], [-121.96384, 37.93885], [-121.9639, 37.93884], [-121.96393, 37.93885], [-121.96361, 37.93926], [-121.96346, 37.93958], [-121.96341, 37.93974], [-121.96337, 37.94009], [-121.96338, 37.94027], [-121.96373, 37.94024], [-121.96375, 37.94031], [-121.96381, 37.94046], [-121.96397, 37.94065], [-121.9637, 37.94085], [-121.96387, 37.94097], [-121.96407, 37.94107], [-121.96435, 37.94116], [-121.96463, 37.94119], [-121.96488, 37.94118], [-121.96505, 37.94114], [-121.96512, 37.94122], [-121.96493, 37.94169], [-121.96542, 37.94208], [-121.96561, 37.94216], [-121.96575, 37.9422], [-121.96645, 37.94232]]]} Open Access 1 13606 Pine Hollow Estates 23680 1066 Concord, City of 391 City 2 City Agency 2 http://www.ci.concord.ca.us/page.asp?pid=3002 City 2 1066 Concord, City of 385 City 2 City Agency 2   Contra Costa 12 3.614 Pine Hollow Estates   None 716  

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