units_with_maps

Table actions

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

12 rows where MNG_AGENCY = 295

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Hawthorne, City of · 12 ✖

DES_TP 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
983 983 982 {"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.90356], [-118.34284, 33.90356], [-118.34285, 33.90373], [-118.34369, 33.90374]]]} Open Access 1 6177 Jim Thorpe Park 20414 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 8.716 Jim Thorpe Park 0 Local Park 2 4
2117 2117 2116 {"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 6170 Holly Park 20044 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 10.563 Holly Park 0 Local Park 2 4
2118 2118 2117 {"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.90727], [-118.37093, 33.90728], [-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 6171 Glasgow Park 19308 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 3.841 Glasgow Park 0 Local Park 2 4
2137 2137 2136 {"type": "Polygon", "coordinates": [[[-118.37166, 33.90796], [-118.37253, 33.90797], [-118.37255, 33.90801], [-118.37254, 33.90865], [-118.3725, 33.90867], [-118.37203, 33.90867], [-118.37178, 33.9086], [-118.37171, 33.90862], [-118.37166, 33.90869], [-118.37166, 33.90853], [-118.37134, 33.90853], [-118.37134, 33.90798], [-118.37138, 33.90796], [-118.37166, 33.90796]]]} Open Access 1 6175 Holly Glen Park 20042 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 1.999 Holly Glen Park 0 Local Park 2 4
2138 2138 2137 {"type": "Polygon", "coordinates": [[[-118.37112, 33.90932], [-118.37107, 33.90936], [-118.37102, 33.90936], [-118.37093, 33.90728], [-118.37112, 33.90727], [-118.37112, 33.90932]]]} Open Access 1 6176 Glasgow Park 19308 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 0.764 Glasgow Park 0 Local Park 2 4
2139 2139 2138 {"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 6179 Hawthorne Memorial Park 19752 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 13.5 Hawthorne Memorial Park 0 Local Park 2 4
2140 2140 2139 {"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 6180 Bicentennial Park 33375 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 0.911 Bicentennial Park 2017 Local Park 2 4
2141 2141 2140 {"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 6181 Ramona Park 24118 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 1.71 Ramona Park 0 Local Park 2 4
2142 2142 2141 {"type": "Polygon", "coordinates": [[[-118.36116, 33.92156], [-118.36115, 33.92316], [-118.36067, 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 6182 Eucalyptus Park 18743 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 4.145 Eucalyptus Park 0 Local Park 2 4
5465 5465 5464 {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.33699, 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 6273 Zela Davis Elementary School Park 31892 2044 Hawthorne School District 808 Special District 4 School District 14 http://www.hawthorne.k12.ca.us/ Special District 4 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 1.201 Zela Davis Elementary School Park 0 Local Park 2 4
7085 7085 7084 {"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 6178 Zela Davis Park 27858 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 0.738 Zela Davis Park 0 Local Park 2 4
8163 8163 8162 {"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 46481 118th Street Mini Park 29761 1130 Hawthorne, City of 299 City 2 City Agency 2 http://www.cityofhawthorne.com/ City 2 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 0.154 118th Street MP 0 Local Park 2 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]);