superunits_with_maps

Table actions

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

465 rows where LAYER = 2 and MNG_AGENCY = 24 sorted by ACRES

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Angeles, City of · 465 ✖

LAYER 1 ✖

  • City · 465 ✖
Link rowid id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES ▼ LABEL_NAME YR_EST
11973 11973 11972 {"type": "Polygon", "coordinates": [[[-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], [-118.46109, 33.99132]]]} Open Access 1 Crescent Place Triangle   28810 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.015 Crescent Place Triangle  
11970 11970 11969 {"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 Amoroso Triangle   28805 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.027 Amoroso Triangle  
11988 11988 11987 {"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 Nowita Triangle   28834 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.027 Nowita Triangle  
11985 11985 11984 {"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 Marco Triangle   28830 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.034 Marco Triangle  
11942 11942 11941 {"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 Aliso Triangle   28745 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.043 Aliso Triangle  
7549 7549 7548 {"type": "Polygon", "coordinates": [[[-118.446, 34.13918], [-118.44599, 34.13919], [-118.44597, 34.13919], [-118.44542, 34.13894], [-118.44542, 34.13891], [-118.446, 34.13918]]]} Open Access 1 Oak Forest West Access   22965 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.044 Oak Forest West Access  
11981 11981 11980 {"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 Gateway Triangle   28822 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.044 Gateway Triangle  
5128 5128 5127 {"type": "Polygon", "coordinates": [[[-118.18446, 34.11514], [-118.1843, 34.11529], [-118.18412, 34.11522], [-118.1843, 34.11518], [-118.18446, 34.11514]]]} Open Access 1 Highland Park   19932 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.045 Highland Park  
13714 13714 13713 {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} No Public Access 3 Chautauqua Blvd Access to Will Rogers State Historic Preserve   31212 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.053 Chautauqua Blvd Access to Will Rogers SHPr  
12162 12162 12161 {"type": "Polygon", "coordinates": [[[-118.31252, 34.03389], [-118.31238, 34.03402], [-118.31236, 34.03402], [-118.31233, 34.03401], [-118.31231, 34.03394], [-118.31235, 34.03388], [-118.31242, 34.03384], [-118.31252, 34.03386], [-118.31252, 34.03389]]]} Open Access 1 Gramercy Park   29322 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.056 Gramercy Park  
12777 12777 12776 {"type": "Polygon", "coordinates": [[[-118.36138, 34.08051], [-118.36127, 34.08051], [-118.36128, 34.08027], [-118.36137, 34.08028], [-118.36138, 34.08051]]]} Open Access 1 Rosewood Gardens Park   29970 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.06 Rosewood Gardens Park  
11951 11951 11950 {"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 Valencia Triangle   28772 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.063 Valencia Triangle  
4940 4940 4939 {"type": "Polygon", "coordinates": [[[-118.43109, 34.19476], [-118.43107, 34.19479], [-118.43103, 34.19481], [-118.4306, 34.19481], [-118.4306, 34.19476], [-118.43109, 34.19476]]]} Open Access 1 Hartland Mini Park   19710 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.065 Hartland MP  
11751 11751 11750 {"type": "Polygon", "coordinates": [[[-118.53693, 34.27607], [-118.53692, 34.27621], [-118.53659, 34.27619], [-118.5366, 34.27615], [-118.53663, 34.27613], [-118.53693, 34.27607]]]} Open Access 1 Rinaldi Park   28359 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.082 Rinaldi Park  
11936 11936 11935 {"type": "Polygon", "coordinates": [[[-118.31504, 34.05232], [-118.31497, 34.05239], [-118.31494, 34.05241], [-118.31469, 34.05242], [-118.31465, 34.0524], [-118.31463, 34.05237], [-118.31463, 34.05232], [-118.31504, 34.05232]]]} Open Access 1 Wilton Place Park   28736 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.082 Wilton Place Park  
11934 11934 11933 {"type": "Polygon", "coordinates": [[[-118.21233, 34.04451], [-118.21222, 34.04468], [-118.2119, 34.04453], [-118.2119, 34.04453], [-118.21233, 34.04451]]]} Open Access 1 Ross Valencia Community Park http://www.laparks.org/dos/parks/facility/laniVestPocketPk.htm 28733 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.088 Ross Valencia Community Park  
13984 13984 13983 {"type": "Polygon", "coordinates": [[[-118.30056, 34.0395], [-118.30046, 34.0395], [-118.30046, 34.03918], [-118.30049, 34.03915], [-118.30055, 34.03915], [-118.30056, 34.0395]]]} Open Access 1 West Adams Heights Park https://www.laparks.org/park/west-adams-heights-park 32572 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.088 West Adams Heights Park 2014
4660 4660 4659 {"type": "Polygon", "coordinates": [[[-118.42634, 34.19022], [-118.42593, 34.19022], [-118.4259, 34.19019], [-118.42589, 34.19014], [-118.42634, 34.19014], [-118.42634, 34.19022]]]} Open Access 1 Kittridge Mini Park   20680 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.09 Kittridge MP  
8968 8968 8967 {"type": "Polygon", "coordinates": [[[-118.45654, 33.98752], [-118.45652, 33.98755], [-118.4562, 33.98757], [-118.45619, 33.98741], [-118.45652, 33.98749], [-118.45654, 33.98752]]]} Open Access 1 Triangle Park http://www.laparks.org/dos/parks/facility/trianglePk.htm 26531 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.09 Triangle Park  
9897 9897 9896 {"type": "Polygon", "coordinates": [[[-118.2713, 33.93401], [-118.2713, 33.93437], [-118.2712, 33.93437], [-118.2712, 33.93401], [-118.2713, 33.93401]]]} Open Access 1 111th Place Neighborhood Park http://www.laparks.org/environmental/pdf/111thPark.pdf 27920 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 0.09 111th Place Neighborhood Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);