units_with_maps

Table actions

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

4 rows where AGNCY_NAME = 255, DES_TP = 3 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 4 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 4 ✖

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
8108 8108 8107 {"type": "Polygon", "coordinates": [[[-121.7186, 37.98188], [-121.71717, 37.98189], [-121.71708, 37.98103], [-121.71859, 37.98103], [-121.7186, 37.98188]]]} Open Access 1 12214 Laurel Fields Park 21093 1229 Oakley, City of 255 City 2 City Agency 2 http://www.ci.oakley.ca.us/subpage.cfm?id=441408 City 2 1229 Oakley, City of 251 City 2 City Agency 2   Contra Costa 12 3.017 Laurel Fields Park 0 Local Recreation Area 3 4
12508 12508 12507 {"type": "Polygon", "coordinates": [[[-121.71602, 37.97038], [-121.71571, 37.97038], [-121.71558, 37.97048], [-121.71558, 37.97135], [-121.71427, 37.97137], [-121.71426, 37.96914], [-121.71429, 37.96909], [-121.716, 37.96905], [-121.71602, 37.97038]]]} Open Access 1 29026 Freedom Soccer Fields 19089 1229 Oakley, City of 255 City 2 City Agency 2 http://www.ci.oakley.ca.us/subpage.cfm?id=441408 City 2 1229 Oakley, City of 251 City 2 City Agency 2   Contra Costa 12 8.636 Freedom Soccer Fields 0 Local Recreation Area 3 4
12534 12534 12533 {"type": "Polygon", "coordinates": [[[-121.71172, 37.98513], [-121.70833, 37.98514], [-121.70831, 37.98338], [-121.7111, 37.98336], [-121.71108, 37.98406], [-121.71172, 37.98403], [-121.71172, 37.98513]]]} Open Access 1 29034 Laurel Ball Fields 21086 1229 Oakley, City of 255 City 2 City Agency 2 http://www.ci.oakley.ca.us/subpage.cfm?id=441408 City 2 1229 Oakley, City of 251 City 2 City Agency 2   Contra Costa 12 13.446 Laurel Ball Fields 0 Local Recreation Area 3 4
15526 15526 15525 {"type": "Polygon", "coordinates": [[[-121.70145, 37.97426], [-121.70144, 37.97607], [-121.70003, 37.97607], [-121.70002, 37.97587], [-121.70012, 37.97586], [-121.7001, 37.97571], [-121.69982, 37.97565], [-121.69982, 37.97519], [-121.7, 37.97516], [-121.69999, 37.97493], [-121.70017, 37.97491], [-121.70017, 37.97447], [-121.70028, 37.97446], [-121.70027, 37.97428], [-121.70145, 37.97426]]]} Open Access 1 29043 Simoni Ranch Open Space 25512 1229 Oakley, City of 255 City 2 City Agency 2 http://www.ci.oakley.ca.us/subpage.cfm?id=441408 City 2 1229 Oakley, City of 251 City 2 City Agency 2   Contra Costa 12 6.122 Simoni Ranch OS 0 Local Recreation Area 3 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]);