superunits_with_maps

Table actions

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

11 rows where MNG_AGENCY = 295 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 11 ✖

MNG_AGENCY 1

  • Hawthorne, City of · 11 ✖
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
248 248 247 {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.337, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} Restricted Access 2 Zela Davis Elementary School Park   31892 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1.202 Zela Davis Elementary School Park  
4086 4086 4085 {"type": "Polygon", "coordinates": [[[-118.36116, 33.92156], [-118.36115, 33.92316], [-118.36068, 33.92316], [-118.36067, 33.92324], [-118.36019, 33.92324], [-118.36019, 33.92185], [-118.35962, 33.92184], [-118.36018, 33.92167], [-118.36019, 33.92155], [-118.36026, 33.92156], [-118.36116, 33.92156]]]} Open Access 1 Eucalyptus Park   18743 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 4.152 Eucalyptus Park  
4577 4577 4576 {"type": "MultiPolygon", "coordinates": [[[[-118.37134, 33.90479], [-118.37132, 33.90487], [-118.37114, 33.90521], [-118.37112, 33.90531], [-118.37113, 33.90658], [-118.37112, 33.90932], [-118.37107, 33.90936], [-118.37102, 33.90936], [-118.37085, 33.90562], [-118.37105, 33.90271], [-118.37112, 33.90271], [-118.37114, 33.90288], [-118.37121, 33.90304], [-118.3712, 33.90312], [-118.37115, 33.90321], [-118.37112, 33.90332], [-118.37112, 33.90397], [-118.37117, 33.90413], [-118.3713, 33.90434], [-118.37133, 33.90443], [-118.37134, 33.90479]]], [[[-118.37114, 33.91387], [-118.37112, 33.91385], [-118.37106, 33.91361], [-118.37103, 33.91288], [-118.37102, 33.90958], [-118.37105, 33.90957], [-118.37111, 33.9096], [-118.37113, 33.90964], [-118.37112, 33.9133], [-118.37114, 33.91387]]]]} Open Access 1 Glasgow Park   19308 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 4.641 Glasgow Park  
4976 4976 4975 {"type": "Polygon", "coordinates": [[[-118.34374, 33.91662], [-118.34374, 33.91782], [-118.33953, 33.91782], [-118.33953, 33.91656], [-118.34366, 33.91655], [-118.34372, 33.91658], [-118.34374, 33.91662]]]} Open Access 1 Hawthorne Memorial Park   19752 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 13.499 Hawthorne Memorial Park  
5214 5214 5213 {"type": "Polygon", "coordinates": [[[-118.37255, 33.90801], [-118.37254, 33.90865], [-118.3725, 33.90867], [-118.37203, 33.90867], [-118.37179, 33.9086], [-118.37171, 33.90862], [-118.37166, 33.90869], [-118.37165, 33.90853], [-118.37134, 33.90853], [-118.37134, 33.90798], [-118.37138, 33.90796], [-118.37253, 33.90797], [-118.37255, 33.90801]]]} Open Access 1 Holly Glen Park   20042 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1.997 Holly Glen Park  
5216 5216 5215 {"type": "Polygon", "coordinates": [[[-118.31765, 33.92178], [-118.31765, 33.92343], [-118.3166, 33.92343], [-118.31658, 33.92371], [-118.31301, 33.92371], [-118.31765, 33.92178]]]} Open Access 1 Holly Park   20044 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 10.565 Holly Park  
5533 5533 5532 {"type": "Polygon", "coordinates": [[[-118.34369, 33.90374], [-118.34368, 33.90549], [-118.34277, 33.90549], [-118.34276, 33.90514], [-118.34174, 33.90514], [-118.34174, 33.90338], [-118.34276, 33.90338], [-118.34277, 33.90355], [-118.34284, 33.90356], [-118.34286, 33.90373], [-118.34369, 33.90374]]]} Open Access 1 Jim Thorpe Park   20414 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 8.722 Jim Thorpe Park  
8498 8498 8497 {"type": "Polygon", "coordinates": [[[-118.35922, 33.90886], [-118.35842, 33.90886], [-118.35842, 33.90801], [-118.35921, 33.90801], [-118.35922, 33.90886]]]} Open Access 1 Ramona Park   24118 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1.709 Ramona Park  
11198 11198 11197 {"type": "Polygon", "coordinates": [[[-118.34102, 33.92741], [-118.34102, 33.92741], [-118.34058, 33.92712], [-118.34101, 33.92713], [-118.34102, 33.92741]]]} Open Access 1 118th Street Mini Park   29761 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 0.154 118th Street MP  
11506 11506 11505 {"type": "Polygon", "coordinates": [[[-118.33724, 33.911], [-118.33723, 33.91126], [-118.3372, 33.91128], [-118.33619, 33.91128], [-118.33619, 33.911], [-118.33724, 33.911]]]} Open Access 1 Zela Davis Park   27858 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 0.738 Zela Davis Park  
13098 13098 13097 {"type": "Polygon", "coordinates": [[[-118.33945, 33.91357], [-118.33843, 33.91357], [-118.33843, 33.91322], [-118.33945, 33.91321], [-118.33945, 33.91357]]]} Open Access 1 Bicentennial Park   33375 1130 Hawthorne, City of 295 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 0.91 Bicentennial Park 2017

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