units_with_maps

Table actions

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

1 row where DES_TP = 3 and UNIT_NAME = "Arroyo Seco Canyon"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 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
9583 9583 9582 {"type": "MultiPolygon", "coordinates": [[[[-122.05836, 36.97149], [-122.05836, 36.97155], [-122.0569, 36.97155], [-122.05655, 36.97254], [-122.05631, 36.97278], [-122.05625, 36.97294], [-122.05561, 36.97298], [-122.05526, 36.97312], [-122.05529, 36.97301], [-122.05556, 36.97295], [-122.05582, 36.97291], [-122.05601, 36.97265], [-122.0557, 36.9726], [-122.0557, 36.97256], [-122.05606, 36.9725], [-122.05635, 36.97217], [-122.05606, 36.97186], [-122.05609, 36.97184], [-122.05645, 36.97204], [-122.0566, 36.97165], [-122.0562, 36.97139], [-122.05599, 36.97141], [-122.05602, 36.9711], [-122.05552, 36.97118], [-122.05551, 36.97116], [-122.05589, 36.971], [-122.05575, 36.97083], [-122.05595, 36.97054], [-122.05553, 36.97048], [-122.05552, 36.97046], [-122.05597, 36.97044], [-122.05599, 36.96982], [-122.05589, 36.96955], [-122.05493, 36.96988], [-122.05476, 36.97029], [-122.05435, 36.97039], [-122.05389, 36.97046], [-122.05385, 36.97042], [-122.05413, 36.97025], [-122.05451, 36.96983], [-122.05524, 36.96922], [-122.0555, 36.96848], [-122.05522, 36.96762], [-122.05484, 36.9677], [-122.05446, 36.96821], [-122.05422, 36.96812], [-122.05386, 36.96793], [-122.0535, 36.96783], [-122.05393, 36.96716], [-122.05412, 36.96667], [-122.05343, 36.9664], [-122.05281, 36.96664], [-122.05227, 36.9681], [-122.05225, 36.96865], [-122.05211, 36.96917], [-122.05235, 36.96995], [-122.05145, 36.97017], [-122.05141, 36.97005], [-122.05174, 36.96979], [-122.05193, 36.96883], [-122.05192, 36.96882], [-122.05173, 36.96882], [-122.05163, 36.96789], [-122.05183, 36.96705], [-122.05108, 36.96697], [-122.05034, 36.96712], [-122.05004, 36.96615], [-122.05009, 36.96611], [-122.05011, 36.96633], [-122.05102, 36.96668], [-122.05197, 36.96669], [-122.0535, 36.96591], [-122.05367, 36.96523], [-122.05363, 36.96442], [-122.05322, 36.96393], [-122.05293, 36.96378], [-122.05324, 36.96274], [-122.05509, 36.96418], [-122.0551, 36.96498], [-122.05429, 36.96489], [-122.05402, 36.96576], [-122.05555, 36.96595], [-122.05556, 36.96598], [-122.05433, 36.96631], [-122.05468, 36.96683], [-122.05524, 36.96727], [-122.05549, 36.9676], [-122.05712, 36.96761], [-122.05683, 36.9678], [-122.0567, 36.96807], [-122.0567, 36.96844], [-122.0559, 36.96844], [-122.05607, 36.96895], [-122.05665, 36.96974], [-122.0567, 36.97012], [-122.05678, 36.97051], [-122.05668, 36.97087], [-122.05686, 36.97146], [-122.05763, 36.97149], [-122.05836, 36.97149]]], [[[-122.05651, 36.97376], [-122.05616, 36.97381], [-122.0562, 36.97406], [-122.05604, 36.97409], [-122.05638, 36.97478], [-122.05543, 36.97488], [-122.05609, 36.97322], [-122.05639, 36.97337], [-122.05633, 36.97339], [-122.05651, 36.97376]]]]} Open Access 1 16111 Arroyo Seco Canyon 15629 1320 Santa Cruz, City of 9 City 2 City Agency 2 http://www.cityofsantacruz.com/departments/parks-recreation City 2 1320 Santa Cruz, City of 9 City 2 City Agency 2   Santa Cruz 5 36.001 Arroyo Seco Canyon 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]);