superunits_with_maps

Table actions

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

8 rows where ACCESS_TYP = 2, MNG_AGENCY = 299 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 8 ✖

MNG_AGENCY 1

  • Arcadia, City of · 8 ✖

ACCESS_TYP 1

  • Restricted Access · 8 ✖
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
166 166 165 {"type": "Polygon", "coordinates": [[[-118.03633, 34.13066], [-118.03547, 34.13067], [-118.03546, 34.13071], [-118.03229, 34.13073], [-118.03226, 34.12947], [-118.03497, 34.12908], [-118.03499, 34.12944], [-118.03598, 34.12943], [-118.03599, 34.1298], [-118.0363, 34.12981], [-118.03633, 34.13066]]]} Restricted Access 2 Arcadia High School Park http://ahs.ausd.net/ 31846 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 13.82 Arcadia High School Park  
167 167 166 {"type": "Polygon", "coordinates": [[[-118.04812, 34.11743], [-118.0462, 34.11746], [-118.04618, 34.11714], [-118.04576, 34.11714], [-118.04575, 34.11667], [-118.04763, 34.11665], [-118.04764, 34.11711], [-118.04812, 34.11711], [-118.04812, 34.11743]]]} Restricted Access 2 Baldwin Stocker Elementary School Park http://bs.ausd.net/ 31847 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 3.8 Baldwin Stocker Elementary School Park  
239 239 238 {"type": "Polygon", "coordinates": [[[-118.03099, 34.1252], [-118.02957, 34.12521], [-118.02955, 34.12535], [-118.02912, 34.12535], [-118.0291, 34.12542], [-118.02813, 34.12543], [-118.02812, 34.12478], [-118.02925, 34.12479], [-118.02927, 34.12465], [-118.02978, 34.12463], [-118.0298, 34.12408], [-118.02984, 34.12407], [-118.02985, 34.12371], [-118.03014, 34.12371], [-118.03015, 34.12396], [-118.03097, 34.12395], [-118.03099, 34.1252]]]} Restricted Access 2 Dana Middle School Park http://da.ausd.net/ 31886 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 6.605 Dana Middle School Park  
240 240 239 {"type": "Polygon", "coordinates": [[[-118.0253, 34.15295], [-118.02529, 34.15431], [-118.02515, 34.15463], [-118.02234, 34.1547], [-118.0223, 34.1529], [-118.0231, 34.15289], [-118.02313, 34.15299], [-118.0253, 34.15295]]]} Restricted Access 2 Highland Oaks Middle School Park   31887 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 12.835 Highland Oaks Middle School Park  
241 241 240 {"type": "Polygon", "coordinates": [[[-118.04253, 34.10858], [-118.04125, 34.10859], [-118.04124, 34.10783], [-118.0413, 34.1078], [-118.04245, 34.10778], [-118.04249, 34.10779], [-118.04251, 34.10784], [-118.04253, 34.10858]]]} Restricted Access 2 Longley Way Elementary School Park http://lw.ausd.net/ 31888 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 2.551 Longley Way Elementary School Park  
242 242 241 {"type": "Polygon", "coordinates": [[[-118.06394, 34.13718], [-118.06273, 34.13744], [-118.06271, 34.13685], [-118.06273, 34.13669], [-118.06278, 34.1366], [-118.06286, 34.13651], [-118.06329, 34.13619], [-118.06337, 34.13619], [-118.0634, 34.13621], [-118.06394, 34.13718]]]} Restricted Access 2 Hugo Reid Elementary School Park http://hr.ausd.net/ 31889 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 2.432 Hugo Reid Elementary School Park  
260 260 259 {"type": "Polygon", "coordinates": [[[-118.03121, 34.13667], [-118.0302, 34.13668], [-118.03018, 34.13643], [-118.02964, 34.13643], [-118.02962, 34.13597], [-118.03019, 34.13596], [-118.0302, 34.13575], [-118.03119, 34.13574], [-118.03121, 34.13667]]]} Restricted Access 2 First Avenue Middle School Park http://fa.ausd.net/ 31905 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 3.021 First Avenue Middle School Park  
5806 5806 5805 {"type": "MultiPolygon", "coordinates": [[[[-118.02002, 34.10015], [-118.01922, 34.10279], [-118.01789, 34.10253], [-118.0166, 34.10528], [-118.01621, 34.10549], [-118.01575, 34.10339], [-118.01574, 34.10313], [-118.01578, 34.1029], [-118.0159, 34.10259], [-118.01597, 34.10246], [-118.01711, 34.10129], [-118.01857, 34.10015], [-118.01908, 34.09991], [-118.02002, 34.10015]]], [[[-118.01617, 34.10551], [-118.01607, 34.10557], [-118.01603, 34.10544], [-118.01577, 34.10423], [-118.01587, 34.10418], [-118.01617, 34.10551]]]]} Restricted Access 2 Arcadia Par-3 Golf Course   33024 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 25.887 Arcadia Par-3 GC  

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