units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1, DES_TP = 3, MNG_AGENCY = 885 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 4 ✖

MNG_AGENCY 1

  • Miraleste Recreation and Park District · 4 ✖

DES_TP 1

  • Local Recreation Area · 4 ✖

ACCESS_TYP 1

  • Open Access · 4 ✖
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
9412 9412 9411 {"type": "MultiPolygon", "coordinates": [[[[-118.325, 33.74497], [-118.32496, 33.74508], [-118.32486, 33.74519], [-118.32456, 33.74533], [-118.32442, 33.74537], [-118.32395, 33.74544], [-118.32322, 33.74543], [-118.3231, 33.74545], [-118.32306, 33.74525], [-118.32227, 33.74479], [-118.32072, 33.74441], [-118.32074, 33.74435], [-118.32074, 33.74405], [-118.32121, 33.74405], [-118.32221, 33.74426], [-118.32253, 33.74419], [-118.32309, 33.74458], [-118.32347, 33.74443], [-118.32349, 33.74426], [-118.32378, 33.74428], [-118.32388, 33.74432], [-118.32395, 33.74437], [-118.32399, 33.74443], [-118.32399, 33.74446], [-118.32372, 33.74453], [-118.32355, 33.7448], [-118.32364, 33.745], [-118.32437, 33.7452], [-118.3247, 33.74515], [-118.3249, 33.74496], [-118.32482, 33.74477], [-118.32486, 33.74475], [-118.32491, 33.74475], [-118.32498, 33.74479], [-118.325, 33.74486], [-118.325, 33.74497]]], [[[-118.32439, 33.74432], [-118.32422, 33.74439], [-118.3242, 33.7443], [-118.32416, 33.74425], [-118.32407, 33.74417], [-118.32392, 33.74413], [-118.32376, 33.74413], [-118.3239, 33.74396], [-118.32439, 33.74432]]]]} Open Access 1 47834 Frascati Trail 31776 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 5.92 Frascati Trail 0 Local Recreation Area 3 4
9521 9521 9520 {"type": "Polygon", "coordinates": [[[-118.32587, 33.74145], [-118.32586, 33.74173], [-118.32563, 33.74185], [-118.32541, 33.7416], [-118.32474, 33.74161], [-118.32422, 33.74153], [-118.32393, 33.74164], [-118.32391, 33.74158], [-118.32401, 33.74154], [-118.32401, 33.74153], [-118.32329, 33.74095], [-118.32212, 33.74084], [-118.3217, 33.74095], [-118.32093, 33.74221], [-118.32075, 33.74221], [-118.32176, 33.74053], [-118.32318, 33.74066], [-118.32402, 33.74133], [-118.32477, 33.74147], [-118.32587, 33.74145]]]} Open Access 1 47832 Colinita Trail 31775 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 3.136 Colinita Trail 0 Local Recreation Area 3 4
9534 9534 9533 {"type": "MultiPolygon", "coordinates": [[[[-118.32508, 33.74836], [-118.32478, 33.74839], [-118.32442, 33.74859], [-118.3242, 33.74879], [-118.32384, 33.74839], [-118.32179, 33.74742], [-118.32161, 33.74723], [-118.32105, 33.74759], [-118.32094, 33.74748], [-118.3215, 33.74711], [-118.32094, 33.7465], [-118.32031, 33.74623], [-118.3199, 33.74579], [-118.31989, 33.7457], [-118.32, 33.74568], [-118.3201, 33.74562], [-118.32024, 33.74572], [-118.32031, 33.74572], [-118.32037, 33.74575], [-118.32054, 33.74589], [-118.32066, 33.74602], [-118.32075, 33.74605], [-118.32085, 33.74605], [-118.32097, 33.74599], [-118.32102, 33.7459], [-118.32101, 33.74581], [-118.32091, 33.74564], [-118.32093, 33.74564], [-118.32142, 33.74604], [-118.32229, 33.74651], [-118.32269, 33.74631], [-118.32274, 33.74637], [-118.32235, 33.74655], [-118.32235, 33.74656], [-118.32345, 33.74762], [-118.32367, 33.74772], [-118.32395, 33.74742], [-118.32419, 33.74758], [-118.32394, 33.74788], [-118.32439, 33.74816], [-118.32474, 33.74814], [-118.32486, 33.74801], [-118.32498, 33.74812], [-118.32504, 33.74824], [-118.32508, 33.74836]]], [[[-118.32085, 33.74589], [-118.32081, 33.74592], [-118.32078, 33.74592], [-118.32066, 33.74579], [-118.32054, 33.74569], [-118.32074, 33.74566], [-118.32085, 33.74585], [-118.32085, 33.74589]]]]} Open Access 1 47835 Sienna Loop Trail 31777 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 9.915 Sienna Loop Trail 0 Local Recreation Area 3 4
9548 9548 9547 {"type": "Polygon", "coordinates": [[[-118.31871, 33.75148], [-118.3186, 33.75159], [-118.3186, 33.7517], [-118.31842, 33.75196], [-118.31843, 33.74806], [-118.31846, 33.74607], [-118.31864, 33.74623], [-118.31866, 33.74651], [-118.31866, 33.7466], [-118.31862, 33.74662], [-118.31859, 33.75138], [-118.31871, 33.75148]]]} Open Access 1 47839 Lorraine Trail 31782 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 2.557 Lorraine Trail 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]);