units_with_maps

Table actions

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

1 row where COUNTY = 26 and DES_TP = 905

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
10346 10346 10345 {"type": "Polygon", "coordinates": [[[-122.19567, 38.13207], [-122.19607, 38.1323], [-122.19607, 38.1323], [-122.1969, 38.13267], [-122.19794, 38.13308], [-122.19855, 38.13337], [-122.19901, 38.13361], [-122.19996, 38.1342], [-122.20165, 38.13531], [-122.20208, 38.13557], [-122.20272, 38.13596], [-122.20326, 38.13619], [-122.20352, 38.13629], [-122.20489, 38.13665], [-122.20612, 38.13692], [-122.20724, 38.13706], [-122.20547, 38.13799], [-122.20543, 38.13823], [-122.20762, 38.13847], [-122.20991, 38.13874], [-122.20972, 38.13981], [-122.20973, 38.13982], [-122.21088, 38.13993], [-122.21174, 38.14005], [-122.21298, 38.14019], [-122.2131, 38.13937], [-122.21532, 38.13962], [-122.21525, 38.14005], [-122.21545, 38.1406], [-122.21382, 38.14057], [-122.21368, 38.14204], [-122.21291, 38.14191], [-122.21264, 38.14192], [-122.21255, 38.14225], [-122.21271, 38.14272], [-122.2134, 38.14303], [-122.21288, 38.14606], [-122.20837, 38.14896], [-122.20599, 38.14589], [-122.19995, 38.14373], [-122.19935, 38.14304], [-122.19853, 38.14245], [-122.19668, 38.14098], [-122.19475, 38.13958], [-122.19412, 38.13869], [-122.19448, 38.13723], [-122.19423, 38.13573], [-122.19408, 38.13498], [-122.19238, 38.13177], [-122.19208, 38.13161], [-122.19179, 38.13148], [-122.19139, 38.13124], [-122.19095, 38.13094], [-122.19068, 38.13063], [-122.19033, 38.13018], [-122.18977, 38.1297], [-122.18938, 38.12931], [-122.18901, 38.1289], [-122.18861, 38.12857], [-122.18982, 38.12792], [-122.19073, 38.12752], [-122.19077, 38.12764], [-122.19086, 38.12773], [-122.19143, 38.12808], [-122.19189, 38.12829], [-122.192, 38.12829], [-122.19217, 38.12822], [-122.19363, 38.13011], [-122.19405, 38.13058], [-122.19453, 38.13106], [-122.19501, 38.13153], [-122.19554, 38.132], [-122.19567, 38.13207]]]} No Public Access 3 18255 Northgate 22870 1365 Vallejo, City of 531 City 2 City Agency 2 http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails City 2 1365 Vallejo, City of 524 City 2 City Agency 2   Solano 26 435.488 Northgate 1999 None 905  

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