units_with_maps

Table actions

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

1 row where AGNCY_NAME = 391, MNG_AGENCY = 174 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • Walnut Creek, City of · 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
15049 15049 15048 {"type": "Polygon", "coordinates": [[[-121.9967, 37.94255], [-121.99652, 37.94296], [-121.99619, 37.94352], [-121.99599, 37.944], [-121.99537, 37.94451], [-121.99465, 37.94464], [-121.99464, 37.94497], [-121.99426, 37.94561], [-121.99346, 37.9464], [-121.99311, 37.94657], [-121.99268, 37.94675], [-121.99238, 37.94686], [-121.99217, 37.94691], [-121.99194, 37.94667], [-121.99167, 37.9465], [-121.99143, 37.9464], [-121.99077, 37.9462], [-121.99081, 37.94611], [-121.99076, 37.94605], [-121.99073, 37.9459], [-121.9907, 37.94582], [-121.99051, 37.94563], [-121.99045, 37.94559], [-121.9903, 37.94545], [-121.99018, 37.94531], [-121.99012, 37.94508], [-121.99016, 37.94486], [-121.99012, 37.94479], [-121.99013, 37.94474], [-121.99022, 37.9447], [-121.9903, 37.94468], [-121.99027, 37.94462], [-121.99012, 37.94448], [-121.99008, 37.94449], [-121.99007, 37.94448], [-121.99006, 37.9444], [-121.99008, 37.94433], [-121.99014, 37.94426], [-121.99015, 37.94399], [-121.99013, 37.94387], [-121.99016, 37.94372], [-121.99014, 37.94368], [-121.99019, 37.94348], [-121.98994, 37.94317], [-121.98738, 37.9429], [-121.98721, 37.94315], [-121.98689, 37.94316], [-121.98665, 37.94352], [-121.98598, 37.94379], [-121.98467, 37.94399], [-121.98418, 37.93722], [-121.98166, 37.93529], [-121.98283, 37.93445], [-121.98246, 37.93314], [-121.98159, 37.93253], [-121.98162, 37.93214], [-121.98193, 37.93191], [-121.9967, 37.94255]]]} Open Access 1 45720 Lime Ridge Open Space 14664 1066 Concord, City of 391 City 2 City Agency 2 http://www.ci.concord.ca.us/page.asp?pid=3002 City 2 1371 Walnut Creek, City of 174 City 2 City Agency 2 http://www.walnut-creek.org/citygov/depts/ps/openspace/limeridge.asp Contra Costa 12 208.851 Lime Ridge 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]);