units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 3, LABEL_NAME = "Gates King OS" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
16240 16240 16239 {"type": "MultiPolygon", "coordinates": [[[[-118.51958, 34.35827], [-118.51934, 34.3581], [-118.51913, 34.35798], [-118.51888, 34.35788], [-118.51855, 34.35777], [-118.51788, 34.3582], [-118.51785, 34.35799], [-118.51764, 34.35784], [-118.51749, 34.3578], [-118.51689, 34.35816], [-118.51424, 34.3558], [-118.51588, 34.35673], [-118.51598, 34.35625], [-118.51643, 34.3564], [-118.51686, 34.35585], [-118.51684, 34.35579], [-118.51674, 34.35575], [-118.51677, 34.35558], [-118.51669, 34.35547], [-118.51667, 34.35536], [-118.5167, 34.35525], [-118.51653, 34.35526], [-118.51616, 34.35548], [-118.51601, 34.35532], [-118.5158, 34.35537], [-118.51559, 34.35549], [-118.51547, 34.3555], [-118.51511, 34.35536], [-118.51512, 34.35496], [-118.51506, 34.35489], [-118.51499, 34.35488], [-118.51495, 34.35494], [-118.51469, 34.35506], [-118.51459, 34.35502], [-118.51486, 34.35488], [-118.51492, 34.35475], [-118.51464, 34.35452], [-118.51447, 34.35453], [-118.51419, 34.35446], [-118.51416, 34.35437], [-118.5139, 34.35413], [-118.51411, 34.35352], [-118.51376, 34.35318], [-118.51357, 34.35286], [-118.51363, 34.35259], [-118.51359, 34.3525], [-118.51341, 34.35236], [-118.5134, 34.35232], [-118.51362, 34.35211], [-118.5134, 34.35146], [-118.51256, 34.35156], [-118.51177, 34.3512], [-118.51044, 34.34852], [-118.50908, 34.34788], [-118.50997, 34.34661], [-118.51013, 34.34636], [-118.51028, 34.34603], [-118.51038, 34.34571], [-118.51043, 34.34544], [-118.51045, 34.34516], [-118.51091, 34.34518], [-118.51092, 34.34501], [-118.51088, 34.34496], [-118.51044, 34.34494], [-118.51044, 34.34488], [-118.51238, 34.34498], [-118.51418, 34.34859], [-118.5144, 34.34868], [-118.51654, 34.35297], [-118.51626, 34.35339], [-118.51656, 34.35398], [-118.51695, 34.35413], [-118.51766, 34.35573], [-118.5178, 34.35608], [-118.518, 34.35648], [-118.51817, 34.35672], [-118.51852, 34.35716], [-118.51958, 34.35827]]], [[[-118.52538, 34.35301], [-118.52281, 34.35457], [-118.51891, 34.35713], [-118.51865, 34.35685], [-118.51836, 34.35645], [-118.5182, 34.35618], [-118.51807, 34.35589], [-118.51763, 34.35452], [-118.51739, 34.35394], [-118.51486, 34.34886], [-118.51505, 34.34892], [-118.51311, 34.34502], [-118.51523, 34.34514], [-118.51511, 34.34688], [-118.51974, 34.34714], [-118.51972, 34.35078], [-118.52538, 34.35301]]]]} Open Access 1 46251 Gates King Open Space 29529 1319 Santa Clarita, City of 325 City 2 City Agency 2 http://www.santa-clarita.com/index.aspx?page=186 City 2 1319 Santa Clarita, City of 322 City 2 City Agency 2   Los Angeles 6 229.574 Gates King 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]);