units_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1, DES_TP = 14 and MNG_AGENCY = 24

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Angeles, City of · 10 ✖

DES_TP 1

  • Local Other or Unknown · 10 ✖

ACCESS_TYP 1

  • Open Access · 10 ✖
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
4360 4360 4359 {"type": "Polygon", "coordinates": [[[-118.22281, 34.0523], [-118.22263, 34.05242], [-118.22258, 34.05226], [-118.22258, 34.05226], [-118.22281, 34.0523]]]} Open Access 1 45741 Aliso Triangle 28745 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 0.043 Aliso Triangle 0 Local Other or Unknown 14 4
4366 4366 4365 {"type": "Polygon", "coordinates": [[[-118.46024, 33.99143], [-118.46013, 33.99159], [-118.46, 33.99153], [-118.46009, 33.99151], [-118.46013, 33.99147], [-118.46024, 33.99143]]]} Open Access 1 45810 Marco Triangle 28830 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 0.034 Marco Triangle 0 Local Other or Unknown 14 4
4660 4660 4659 {"type": "Polygon", "coordinates": [[[-118.445, 34.26558], [-118.44458, 34.26545], [-118.44422, 34.26529], [-118.4438, 34.26504], [-118.44347, 34.26478], [-118.44336, 34.26486], [-118.44333, 34.26484], [-118.44307, 34.26456], [-118.44309, 34.26422], [-118.44317, 34.26385], [-118.445, 34.26558]]]} Open Access 1 36591 Unnamed site - Los Angeles, City of 28718 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 2.286   0 Local Other or Unknown 14 4
4693 4693 4692 {"type": "Polygon", "coordinates": [[[-118.42279, 34.08006], [-118.42271, 34.08009], [-118.4227, 34.0798], [-118.42279, 34.07993], [-118.42279, 34.08006]]]} Open Access 1 45802 Gateway Triangle 28822 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 0.044 Gateway Triangle 0 Local Other or Unknown 14 4
5704 5704 5703 {"type": "Polygon", "coordinates": [[[-118.27079, 34.05157], [-118.27054, 34.05146], [-118.27065, 34.05131], [-118.27066, 34.05133], [-118.27079, 34.05157]]]} Open Access 1 45766 Valencia Triangle 28772 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 0.063 Valencia Triangle 0 Local Other or Unknown 14 4
5711 5711 5710 {"type": "Polygon", "coordinates": [[[-118.46109, 33.99128], [-118.46109, 33.99132], [-118.46107, 33.99134], [-118.46103, 33.99134], [-118.461, 33.99132], [-118.461, 33.99129], [-118.46103, 33.99127], [-118.46106, 33.99127], [-118.46109, 33.99128]]]} Open Access 1 45791 Crescent Place Triangle 28810 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 0.015 Crescent Place Triangle 0 Local Other or Unknown 14 4
15001 15001 15000 {"type": "Polygon", "coordinates": [[[-118.45909, 33.99185], [-118.45903, 33.99195], [-118.45894, 33.99191], [-118.45901, 33.99181], [-118.45909, 33.99185]]]} Open Access 1 45786 Amoroso Triangle 28805 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 0.027 Amoroso Triangle 0 Local Other or Unknown 14 4
15056 15056 15055 {"type": "Polygon", "coordinates": [[[-118.46102, 33.99278], [-118.46095, 33.99287], [-118.46087, 33.99283], [-118.46093, 33.99274], [-118.46102, 33.99278]]]} Open Access 1 45814 Nowita Triangle 28834 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 0.027 Nowita Triangle 0 Local Other or Unknown 14 4
15059 15059 15058 {"type": "Polygon", "coordinates": [[[-118.20626, 34.09845], [-118.20591, 34.09868], [-118.20587, 34.09831], [-118.20587, 34.09831], [-118.20626, 34.09845]]]} Open Access 1 45839 Woodside Triangle 28859 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 0.175 Woodside Triangle 0 Local Other or Unknown 14 4
15070 15070 15069 {"type": "Polygon", "coordinates": [[[-118.56874, 34.13168], [-118.56573, 34.13332], [-118.56505, 34.13189], [-118.56459, 34.13122], [-118.56485, 34.13122], [-118.56541, 34.13042], [-118.56551, 34.13046], [-118.56558, 34.13034], [-118.56594, 34.13048], [-118.56589, 34.1306], [-118.56874, 34.13168]]]} Open Access 1 45842 Pilson Property 28862 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 14.653 Pilson Property 0 Local Other or Unknown 14 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]);