units_with_maps

Table actions

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

1 row where AGNCY_LEV = 2, AGNCY_NAME = 24 and DES_TP = 573

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
7014 7014 7013 {"type": "MultiPolygon", "coordinates": [[[[-118.28693, 33.71159], [-118.2861, 33.71162], [-118.28607, 33.71185], [-118.28547, 33.71297], [-118.2858, 33.71362], [-118.28576, 33.71399], [-118.28593, 33.7142], [-118.28592, 33.71434], [-118.2845, 33.71434], [-118.28448, 33.71354], [-118.28427, 33.71353], [-118.28393, 33.71356], [-118.28384, 33.71359], [-118.28376, 33.71365], [-118.28375, 33.71371], [-118.28369, 33.71369], [-118.28368, 33.71364], [-118.28374, 33.71357], [-118.2839, 33.7135], [-118.2839, 33.71329], [-118.28383, 33.71326], [-118.28292, 33.71304], [-118.28287, 33.71306], [-118.28287, 33.71354], [-118.28283, 33.71357], [-118.28279, 33.71355], [-118.28278, 33.71303], [-118.28276, 33.71299], [-118.28245, 33.71291], [-118.28202, 33.71285], [-118.28199, 33.71281], [-118.28207, 33.71279], [-118.28276, 33.7129], [-118.28287, 33.71277], [-118.28297, 33.71259], [-118.28301, 33.71245], [-118.28304, 33.71221], [-118.28303, 33.71189], [-118.28296, 33.71127], [-118.28282, 33.71048], [-118.28271, 33.71009], [-118.28264, 33.71001], [-118.28247, 33.71], [-118.28239, 33.70996], [-118.28208, 33.70988], [-118.28192, 33.70989], [-118.28182, 33.70988], [-118.28176, 33.70985], [-118.28156, 33.70987], [-118.28146, 33.70992], [-118.28137, 33.70994], [-118.2813, 33.70995], [-118.28119, 33.70992], [-118.28073, 33.70968], [-118.28043, 33.70969], [-118.28016, 33.70962], [-118.27977, 33.70945], [-118.27942, 33.70926], [-118.27866, 33.70895], [-118.27818, 33.70878], [-118.27806, 33.70877], [-118.2779, 33.70871], [-118.27768, 33.7086], [-118.27759, 33.7085], [-118.27751, 33.70844], [-118.27743, 33.70842], [-118.27724, 33.70842], [-118.27721, 33.70845], [-118.27566, 33.70762], [-118.27559, 33.7077], [-118.2753, 33.70755], [-118.27534, 33.70746], [-118.27388, 33.70668], [-118.27395, 33.70659], [-118.27404, 33.70663], [-118.27402, 33.70667], [-118.27701, 33.70827], [-118.27859, 33.70622], [-118.2787, 33.70629], [-118.27774, 33.70754], [-118.27784, 33.70758], [-118.27799, 33.70771], [-118.27817, 33.70781], [-118.27829, 33.70794], [-118.27863, 33.70814], [-118.27868, 33.70814], [-118.27889, 33.70821], [-118.27892, 33.70824], [-118.27984, 33.70855], [-118.28018, 33.70857], [-118.28081, 33.70872], [-118.28084, 33.70874], [-118.2811, 33.70882], [-118.2816, 33.7089], [-118.28173, 33.70893], [-118.28231, 33.70894], [-118.28262, 33.70899], [-118.28312, 33.709], [-118.28318, 33.70894], [-118.28372, 33.70894], [-118.28396, 33.70885], [-118.28415, 33.70885], [-118.28433, 33.70882], [-118.28467, 33.70866], [-118.28479, 33.70862], [-118.28516, 33.70787], [-118.2856, 33.70787], [-118.28554, 33.7081], [-118.28497, 33.70844], [-118.2854, 33.70893], [-118.28543, 33.70901], [-118.28557, 33.71014], [-118.28548, 33.71022], [-118.28534, 33.71022], [-118.2845, 33.70991], [-118.28437, 33.70988], [-118.28424, 33.70987], [-118.28398, 33.7099], [-118.28388, 33.70994], [-118.28377, 33.71007], [-118.28375, 33.71014], [-118.28378, 33.71023], [-118.28386, 33.71032], [-118.28411, 33.71042], [-118.28421, 33.71051], [-118.2843, 33.71048], [-118.28429, 33.71043], [-118.28431, 33.71034], [-118.28439, 33.71022], [-118.28453, 33.71016], [-118.2847, 33.71015], [-118.28595, 33.71061], [-118.28657, 33.7114], [-118.28667, 33.71148], [-118.2868, 33.71155], [-118.28693, 33.71159]]], [[[-118.28443, 33.71005], [-118.28429, 33.71012], [-118.28422, 33.7102], [-118.28413, 33.71027], [-118.28402, 33.71027], [-118.28397, 33.71025], [-118.28392, 33.71021], [-118.28391, 33.71016], [-118.28392, 33.71008], [-118.28394, 33.71005], [-118.28399, 33.71001], [-118.28417, 33.70998], [-118.28434, 33.71], [-118.28442, 33.71002], [-118.28443, 33.71005]]]]} Open Access 1 5953 Cabrillo Beach & Marine Aquarium 16634 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 51.192 Cabrillo Beach & Marine Aquarium   None 573  

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