units_with_maps

Table actions

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

5 rows where DES_TP = 19, MNG_AGENCY = 393 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 5 ✖

MNG_AGENCY 1

  • Kern, County of · 5 ✖

DES_TP 1

  • Local Historic or Cultural Area · 5 ✖

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
1638 1638 1637 {"type": "Polygon", "coordinates": [[[-119.43775, 35.1571], [-119.43547, 35.15711], [-119.43547, 35.15585], [-119.43514, 35.15584], [-119.43497, 35.15576], [-119.43496, 35.15468], [-119.43774, 35.15467], [-119.43775, 35.1571]]]} Open Access 1 14097 Westside Cemetery 27421 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 15.293 Westside Cemetery 0 Local Historic or Cultural Area 19 4
1839 1839 1838 {"type": "Polygon", "coordinates": [[[-118.46441, 35.13789], [-118.4644, 35.13906], [-118.46227, 35.13906], [-118.46228, 35.13789], [-118.46441, 35.13789]]]} Open Access 1 14074 Tehachapi West Side Cemetery 26219 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 6.23 Tehachapi West Side Cemetery 0 Local Historic or Cultural Area 19 4
3718 3718 3717 {"type": "Polygon", "coordinates": [[[-118.71748, 35.7406], [-118.71739, 35.74167], [-118.71616, 35.74208], [-118.71604, 35.74172], [-118.71606, 35.74166], [-118.71616, 35.74142], [-118.7163, 35.74117], [-118.71656, 35.74078], [-118.71668, 35.74063], [-118.71748, 35.7406]]]} Open Access 1 14029 Oak Grove Cemetery 22970 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 3.555 Oak Grove Cemetery 0 Local Historic or Cultural Area 19 4
8676 8676 8675 {"type": "Polygon", "coordinates": [[[-119.25839, 35.76429], [-119.25672, 35.76457], [-119.25645, 35.76341], [-119.25645, 35.76146], [-119.25834, 35.76146], [-119.25837, 35.7623], [-119.25839, 35.76429]]]} Open Access 1 14006 North Kern Cemetery 22826 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 13.858 North Kern Cemetery 0 Local Historic or Cultural Area 19 4
8688 8688 8687 {"type": "Polygon", "coordinates": [[[-118.47884, 35.13979], [-118.4787, 35.14035], [-118.47877, 35.14051], [-118.47839, 35.14065], [-118.47798, 35.13995], [-118.4781, 35.13977], [-118.47884, 35.13979]]]} Open Access 1 14050 Old Tehachapi Cemetery 23105 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 1.254 Old Tehachapi Cemetery 0 Local Historic or Cultural Area 19 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]);