units_with_maps

Table actions

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

1 row where DES_TP = 1359 and LAYER = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 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
15387 15387 15386 {"type": "MultiPolygon", "coordinates": [[[[-118.20232, 33.76745], [-118.20223, 33.76752], [-118.20217, 33.76759], [-118.20213, 33.76768], [-118.20212, 33.7678], [-118.20212, 33.76788], [-118.20216, 33.76799], [-118.20223, 33.7681], [-118.2023, 33.76819], [-118.20215, 33.7681], [-118.20201, 33.76792], [-118.20196, 33.76778], [-118.20196, 33.76749], [-118.20199, 33.76745], [-118.20232, 33.76745]]], [[[-118.20372, 33.76743], [-118.20369, 33.76768], [-118.20363, 33.76785], [-118.20357, 33.76796], [-118.20341, 33.76813], [-118.2033, 33.7682], [-118.20316, 33.76827], [-118.20298, 33.76831], [-118.20287, 33.76832], [-118.20272, 33.76831], [-118.20261, 33.76829], [-118.20251, 33.76825], [-118.20238, 33.76817], [-118.2023, 33.76809], [-118.20223, 33.76797], [-118.20219, 33.76783], [-118.2022, 33.7677], [-118.20227, 33.76758], [-118.20241, 33.76748], [-118.20257, 33.76745], [-118.20258, 33.76746], [-118.20293, 33.76745], [-118.20372, 33.76743]]], [[[-118.20277, 33.76928], [-118.20246, 33.7692], [-118.20256, 33.76906], [-118.20259, 33.76898], [-118.2026, 33.7689], [-118.20271, 33.76908], [-118.20277, 33.76928]]], [[[-118.20408, 33.76924], [-118.20405, 33.76929], [-118.20394, 33.7693], [-118.20379, 33.76928], [-118.20364, 33.76921], [-118.20355, 33.76914], [-118.20347, 33.76905], [-118.20341, 33.76887], [-118.20342, 33.76875], [-118.20346, 33.76863], [-118.20382, 33.76795], [-118.20391, 33.76765], [-118.20394, 33.76742], [-118.20402, 33.76742], [-118.20408, 33.76924]]], [[[-118.20355, 33.7681], [-118.2035, 33.76819], [-118.20307, 33.7688], [-118.20299, 33.76894], [-118.2029, 33.76919], [-118.20289, 33.76932], [-118.20289, 33.76963], [-118.20287, 33.7694], [-118.20285, 33.76928], [-118.20272, 33.76894], [-118.2026, 33.76872], [-118.20242, 33.76849], [-118.20216, 33.76823], [-118.20211, 33.76816], [-118.20231, 33.76828], [-118.20251, 33.76835], [-118.20267, 33.76838], [-118.20289, 33.76839], [-118.20309, 33.76835], [-118.20329, 33.76828], [-118.20342, 33.76821], [-118.20355, 33.7681]]], [[[-118.20406, 33.76999], [-118.20399, 33.7698], [-118.20394, 33.76973], [-118.20385, 33.76962], [-118.20371, 33.76952], [-118.20349, 33.76942], [-118.20305, 33.76934], [-118.20313, 33.76903], [-118.20328, 33.76879], [-118.2033, 33.7688], [-118.2033, 33.76894], [-118.20335, 33.76908], [-118.2034, 33.76916], [-118.2035, 33.76926], [-118.20363, 33.76934], [-118.20375, 33.76938], [-118.20388, 33.7694], [-118.20406, 33.76941], [-118.20408, 33.76943], [-118.20408, 33.76967], [-118.20406, 33.76999]]], [[[-118.20398, 33.77217], [-118.20393, 33.77217], [-118.20381, 33.77206], [-118.20348, 33.77228], [-118.20319, 33.77243], [-118.20319, 33.77247], [-118.2031, 33.77247], [-118.20306, 33.77249], [-118.20305, 33.77135], [-118.20306, 33.77073], [-118.20305, 33.76945], [-118.20334, 33.76948], [-118.2036, 33.76957], [-118.2038, 33.76972], [-118.20389, 33.76984], [-118.20394, 33.76994], [-118.20397, 33.77013], [-118.20394, 33.77077], [-118.20398, 33.77125], [-118.20398, 33.77217]]], [[[-118.20396, 33.77281], [-118.20389, 33.77304], [-118.20338, 33.77408], [-118.2033, 33.77437], [-118.20328, 33.77438], [-118.20327, 33.77471], [-118.20325, 33.77471], [-118.2031, 33.77343], [-118.20307, 33.77281], [-118.20396, 33.77281]]]]} Open Access 1 46606 Cesar E. Chavez Park Terminus 29914 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 15.111 Cesar E. Chavez Park Terminus 0 None 1359  

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]);