units_with_maps

Table actions

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

7 rows where AGNCY_LEV = 4, COUNTY = 6, MNG_AGENCY = 299 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 7 ✖

MNG_AGENCY 1

  • Arcadia, City of · 7 ✖

DES_TP 1

ACCESS_TYP 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
4439 4439 4438 {"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.03498, 34.12944], [-118.03598, 34.12943], [-118.03599, 34.12981], [-118.0363, 34.12981], [-118.03633, 34.13066]]]} Restricted Access 2 46490 Arcadia High School Park 31846 2315 Arcadia Unified School District 762 Special District 4 School District 14 http://site.ausd.net/ Special District 4 1009 Arcadia, City of 299 City 2 City Agency 2 http://ahs.ausd.net/ Los Angeles 6 13.815 Arcadia High School Park 0 Local Park 2 4
15311 15311 15310 {"type": "Polygon", "coordinates": [[[-118.03099, 34.1252], [-118.02956, 34.12521], [-118.02955, 34.12535], [-118.02911, 34.12535], [-118.0291, 34.12542], [-118.02813, 34.12543], [-118.02812, 34.12478], [-118.02926, 34.12479], [-118.02927, 34.12465], [-118.02979, 34.12463], [-118.0298, 34.12408], [-118.02984, 34.12408], [-118.02985, 34.12371], [-118.03014, 34.12371], [-118.03015, 34.12396], [-118.03097, 34.12395], [-118.03099, 34.1252]]]} Restricted Access 2 46489 Dana Middle School Park 31886 2315 Arcadia Unified School District 762 Special District 4 School District 14 http://site.ausd.net/ Special District 4 1009 Arcadia, City of 299 City 2 City Agency 2 http://da.ausd.net/ Los Angeles 6 6.595 Dana Middle School Park 0 Local Park 2 4
15312 15312 15311 {"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.02312, 34.15299], [-118.0253, 34.15295]]]} Restricted Access 2 46491 Highland Oaks Middle School Park 31887 2315 Arcadia Unified School District 762 Special District 4 School District 14 http://site.ausd.net/ Special District 4 1009 Arcadia, City of 299 City 2 City Agency 2   Los Angeles 6 12.835 Highland Oaks Middle School Park 0 Local Park 2 4
15313 15313 15312 {"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.0633, 34.13619], [-118.06337, 34.13619], [-118.06339, 34.13621], [-118.06394, 34.13718]]]} Restricted Access 2 46493 Hugo Reid Elementary School Park 31889 2315 Arcadia Unified School District 762 Special District 4 School District 14 http://site.ausd.net/ Special District 4 1009 Arcadia, City of 299 City 2 City Agency 2 http://hr.ausd.net/ Los Angeles 6 2.433 Hugo Reid Elementary School Park 0 Local Park 2 4
15323 15323 15322 {"type": "Polygon", "coordinates": [[[-118.03121, 34.13667], [-118.0302, 34.13668], [-118.03018, 34.13643], [-118.02964, 34.13643], [-118.02962, 34.13597], [-118.0302, 34.13596], [-118.0302, 34.13575], [-118.03119, 34.13574], [-118.03121, 34.13667]]]} Restricted Access 2 46487 First Avenue Middle School Park 31905 2315 Arcadia Unified School District 762 Special District 4 School District 14 http://site.ausd.net/ Special District 4 1009 Arcadia, City of 299 City 2 City Agency 2 http://fa.ausd.net/ Los Angeles 6 3.017 First Avenue Middle School Park 0 Local Park 2 4
15324 15324 15323 {"type": "Polygon", "coordinates": [[[-118.04812, 34.11743], [-118.0462, 34.11746], [-118.04619, 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 46488 Baldwin Stocker Elementary School Park 31847 2315 Arcadia Unified School District 762 Special District 4 School District 14 http://site.ausd.net/ Special District 4 1009 Arcadia, City of 299 City 2 City Agency 2 http://bs.ausd.net/ Los Angeles 6 3.796 Baldwin Stocker Elementary School Park 0 Local Park 2 4
15326 15326 15325 {"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 46492 Longley Way Elementary School Park 31888 2315 Arcadia Unified School District 762 Special District 4 School District 14 http://site.ausd.net/ Special District 4 1009 Arcadia, City of 299 City 2 City Agency 2 http://lw.ausd.net/ Los Angeles 6 2.552 Longley Way Elementary School Park 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]);