units_with_maps

Table actions

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

1 row where MNG_AGENCY = 16 and SUID_NMA = 29554

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Angeles, County 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
16243 16243 16242 {"type": "MultiPolygon", "coordinates": [[[[-118.36323, 34.43458], [-118.36322, 34.43457], [-118.36055, 34.43457], [-118.36051, 34.43809], [-118.36055, 34.44182], [-118.35619, 34.44135], [-118.35629, 34.44514], [-118.35199, 34.44471], [-118.35227, 34.45054], [-118.35121, 34.45123], [-118.34996, 34.45259], [-118.34943, 34.4556], [-118.34819, 34.45706], [-118.34734, 34.45754], [-118.34664, 34.45788], [-118.3451, 34.45882], [-118.34452, 34.4592], [-118.34411, 34.45949], [-118.34382, 34.45973], [-118.3431, 34.46042], [-118.34271, 34.461], [-118.34243, 34.46151], [-118.3421, 34.46221], [-118.34198, 34.46265], [-118.34153, 34.46301], [-118.34126, 34.46327], [-118.34096, 34.46349], [-118.33781, 34.46547], [-118.33439, 34.46541], [-118.33449, 34.45261], [-118.34343, 34.45164], [-118.34291, 34.43993], [-118.33652, 34.44005], [-118.33649, 34.4381], [-118.3369, 34.43822], [-118.33718, 34.43826], [-118.33746, 34.43827], [-118.33775, 34.43826], [-118.33803, 34.43822], [-118.33831, 34.43815], [-118.3394, 34.43775], [-118.33977, 34.43754], [-118.33997, 34.43738], [-118.34015, 34.43721], [-118.34031, 34.43701], [-118.3407, 34.43641], [-118.34081, 34.43628], [-118.34103, 34.43612], [-118.34131, 34.436], [-118.34273, 34.43601], [-118.34717, 34.43652], [-118.34715, 34.43365], [-118.34813, 34.43301], [-118.36054, 34.43456], [-118.36056, 34.43364], [-118.36089, 34.4336], [-118.3618, 34.43334], [-118.36205, 34.43328], [-118.36223, 34.43328], [-118.36241, 34.43329], [-118.36262, 34.43336], [-118.36287, 34.4335], [-118.36299, 34.43361], [-118.36312, 34.43381], [-118.36318, 34.43401], [-118.36321, 34.43414], [-118.36323, 34.43458]]], [[[-118.3409, 34.436], [-118.34069, 34.43615], [-118.34057, 34.43627], [-118.34013, 34.43694], [-118.33998, 34.43712], [-118.3398, 34.43729], [-118.3396, 34.43744], [-118.33939, 34.43756], [-118.3386, 34.43787], [-118.33858, 34.43737], [-118.33899, 34.43721], [-118.33931, 34.43703], [-118.34058, 34.436], [-118.3409, 34.436]]], [[[-118.36127, 34.45283], [-118.36122, 34.45645], [-118.35676, 34.45623], [-118.35673, 34.45849], [-118.35673, 34.45992], [-118.35224, 34.45977], [-118.35219, 34.46359], [-118.34774, 34.46348], [-118.34779, 34.45962], [-118.34587, 34.45955], [-118.34862, 34.45799], [-118.34875, 34.45789], [-118.35028, 34.45631], [-118.35134, 34.45393], [-118.35263, 34.45225], [-118.36127, 34.45283]]], [[[-118.36511, 34.43459], [-118.36365, 34.43458], [-118.36348, 34.43384], [-118.36335, 34.43357], [-118.36309, 34.43329], [-118.36283, 34.43313], [-118.36253, 34.43304], [-118.36221, 34.433], [-118.36195, 34.43302], [-118.36098, 34.43329], [-118.36057, 34.43336], [-118.36058, 34.43254], [-118.36187, 34.43258], [-118.3638, 34.43301], [-118.36414, 34.43315], [-118.36505, 34.43362], [-118.36511, 34.43459]]], [[[-118.36502, 34.43312], [-118.36439, 34.43279], [-118.36405, 34.43265], [-118.36345, 34.4325], [-118.36195, 34.43217], [-118.36058, 34.43212], [-118.36059, 34.43104], [-118.36489, 34.43103], [-118.36502, 34.43312]]]]} Open Access 1 46243 Eastern Greenbelt Open Space 29554 1319 Santa Clarita, City of 325 City 2 City Agency 2 http://www.santa-clarita.com/index.aspx?page=186 City 2 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 1243.079 Eastern Greenbelt 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]);