units_with_maps

Table actions

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

2 rows where DES_TP = 2, LABEL_NAME = "Runyon Canyon Park" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

DES_TP 1

  • Local Park · 2 ✖

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
7440 7440 7439 {"type": "MultiPolygon", "coordinates": [[[[-118.35299, 34.11466], [-118.35071, 34.11842], [-118.34991, 34.11763], [-118.35027, 34.1174], [-118.35094, 34.1174], [-118.35104, 34.11741], [-118.35108, 34.11728], [-118.35119, 34.11712], [-118.35128, 34.11701], [-118.35148, 34.11685], [-118.35147, 34.11684], [-118.35107, 34.11681], [-118.35144, 34.11664], [-118.35137, 34.11639], [-118.35079, 34.11593], [-118.35052, 34.11583], [-118.34998, 34.1148], [-118.34941, 34.11448], [-118.3491, 34.1147], [-118.34854, 34.11439], [-118.34853, 34.11228], [-118.34724, 34.11227], [-118.34724, 34.11179], [-118.34768, 34.11179], [-118.34768, 34.11005], [-118.34752, 34.11004], [-118.34751, 34.10832], [-118.34792, 34.10871], [-118.34793, 34.10871], [-118.34826, 34.10775], [-118.3485, 34.10774], [-118.34851, 34.10739], [-118.34882, 34.10631], [-118.3485, 34.10568], [-118.34851, 34.10524], [-118.35194, 34.10527], [-118.35194, 34.10535], [-118.3516, 34.10535], [-118.35167, 34.10581], [-118.35132, 34.10694], [-118.35231, 34.10869], [-118.35287, 34.10885], [-118.35297, 34.11244], [-118.35299, 34.11466]], [[-118.35151, 34.1126], [-118.35147, 34.11256], [-118.3514, 34.11251], [-118.35124, 34.11245], [-118.3511, 34.11246], [-118.35096, 34.1125], [-118.35079, 34.1125], [-118.35053, 34.11242], [-118.35034, 34.1124], [-118.35031, 34.11246], [-118.35028, 34.11247], [-118.35021, 34.11251], [-118.35018, 34.11262], [-118.3502, 34.11268], [-118.35025, 34.11277], [-118.35021, 34.11282], [-118.35041, 34.11305], [-118.35047, 34.11318], [-118.35049, 34.11326], [-118.35043, 34.11343], [-118.35045, 34.11354], [-118.35052, 34.11364], [-118.35073, 34.11379], [-118.35078, 34.11386], [-118.35095, 34.11443], [-118.35146, 34.11432], [-118.35146, 34.11265], [-118.35151, 34.11262], [-118.35151, 34.1126]]], [[[-118.35518, 34.1186], [-118.35517, 34.11879], [-118.35447, 34.11869], [-118.35454, 34.11833], [-118.35421, 34.11838], [-118.35421, 34.11839], [-118.35425, 34.11848], [-118.35417, 34.11852], [-118.35418, 34.11861], [-118.35417, 34.11864], [-118.3541, 34.11877], [-118.35401, 34.11886], [-118.35341, 34.11925], [-118.35332, 34.11933], [-118.35325, 34.11943], [-118.35317, 34.11944], [-118.35307, 34.11941], [-118.35293, 34.11941], [-118.35292, 34.11929], [-118.3529, 34.11924], [-118.35264, 34.11887], [-118.35262, 34.11852], [-118.35256, 34.11842], [-118.35247, 34.11836], [-118.35238, 34.11833], [-118.35226, 34.11833], [-118.35211, 34.11837], [-118.35196, 34.11837], [-118.35187, 34.11835], [-118.35175, 34.1183], [-118.35136, 34.11795], [-118.35299, 34.11527], [-118.35301, 34.11606], [-118.35515, 34.11606], [-118.35516, 34.11769], [-118.3551, 34.11763], [-118.35502, 34.11762], [-118.35495, 34.11764], [-118.35491, 34.11768], [-118.35488, 34.11772], [-118.35491, 34.11781], [-118.35495, 34.11786], [-118.35503, 34.1179], [-118.3551, 34.11792], [-118.35514, 34.11795], [-118.35514, 34.11799], [-118.35511, 34.11802], [-118.35492, 34.11811], [-118.35488, 34.11818], [-118.35488, 34.11823], [-118.35494, 34.11828], [-118.35507, 34.1183], [-118.35513, 34.11835], [-118.35514, 34.11842], [-118.35513, 34.11852], [-118.35518, 34.1186]]]]} Open Access 1 6909 Runyon Canyon Park 24731 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 133.151 Runyon Canyon Park 0 Local Park 2 4
9483 9483 9482 {"type": "MultiPolygon", "coordinates": [[[[-118.35436, 34.11245], [-118.35429, 34.11252], [-118.35299, 34.11466], [-118.35297, 34.11244], [-118.35436, 34.11245]]], [[[-118.35377, 34.11413], [-118.35376, 34.1142], [-118.35361, 34.11442], [-118.35356, 34.11455], [-118.35354, 34.11476], [-118.35355, 34.11511], [-118.3535, 34.11524], [-118.35333, 34.11552], [-118.35348, 34.11564], [-118.353, 34.11529], [-118.35299, 34.11526], [-118.35373, 34.11404], [-118.35377, 34.11413]]]]} Open Access 1 47826 Runyon Canyon Park 31769 1716 Los Angeles Department of Recreation and Parks, City of 660 City 2 City Agency 2 http://www.laparks.org/ City 2 1716 Los Angeles Department of Recreation and Parks, City of 647 City 2 City Agency 2   Los Angeles 6 4.702 Runyon Canyon Park 0 Local Park 2 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]);