units_with_maps

Table actions

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

11 rows where AGNCY_NAME = 237 and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 11 ✖

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
673 673 672 {"type": "Polygon", "coordinates": [[[-117.80058, 34.11037], [-117.80058, 34.1121], [-117.79849, 34.11211], [-117.7985, 34.11037], [-117.80058, 34.11037]]]} Open Access 1 5105 Marchant Park 21793 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 9.157 Marchant Park 0 Local Park 2 4
3543 3543 3542 {"type": "Polygon", "coordinates": [[[-117.8109, 34.10652], [-117.8094, 34.10658], [-117.80939, 34.10618], [-117.80939, 34.10618], [-117.8109, 34.10652]]]} Open Access 1 20605 Rhoads Park 24312 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 0.766 Rhoads Park 0 Local Park 2 4
6635 6635 6634 {"type": "Polygon", "coordinates": [[[-117.83535, 34.11211], [-117.83328, 34.11211], [-117.83328, 34.11038], [-117.83531, 34.11038], [-117.83534, 34.11039], [-117.83535, 34.11042], [-117.83535, 34.11211]]]} Open Access 1 4633 Lone Hill Park 21437 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 9.046 Lone Hill Park 0 Local Park 2 4
7379 7379 7378 {"type": "Polygon", "coordinates": [[[-117.803, 34.12535], [-117.80291, 34.1325], [-117.7979, 34.13246], [-117.79731, 34.13129], [-117.79625, 34.12972], [-117.79506, 34.12823], [-117.79599, 34.12805], [-117.79616, 34.12823], [-117.79689, 34.12775], [-117.7969, 34.12634], [-117.79722, 34.12589], [-117.7992, 34.12536], [-117.80015, 34.12536], [-117.80012, 34.12522], [-117.80033, 34.12523], [-117.80037, 34.12536], [-117.803, 34.12535]]]} Open Access 1 6786 Horsethief Canyon Park 20100 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 110.945 Horsethief Canyon Park 0 Local Park 2 4
10821 10821 10820 {"type": "Polygon", "coordinates": [[[-117.82768, 34.07979], [-117.82638, 34.07989], [-117.82625, 34.07894], [-117.82741, 34.07885], [-117.82732, 34.07934], [-117.82758, 34.07955], [-117.82768, 34.07979]]]} Open Access 1 20553 Ladera Serra Park 20824 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 2.785 Ladera Serra Park 0 Local Park 2 4
10822 10822 10821 {"type": "Polygon", "coordinates": [[[-117.83259, 34.08738], [-117.83168, 34.08763], [-117.83159, 34.08714], [-117.8321, 34.08708], [-117.8324, 34.087], [-117.83259, 34.08738]]]} Open Access 1 20554 Loma Vista Park 21411 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 0.996 Loma Vista Park 0 Local Park 2 4
10824 10824 10823 {"type": "Polygon", "coordinates": [[[-117.82831, 34.07433], [-117.82597, 34.07577], [-117.82486, 34.07421], [-117.82535, 34.0744], [-117.82582, 34.07444], [-117.82586, 34.07408], [-117.82693, 34.0739], [-117.82731, 34.07382], [-117.82781, 34.07396], [-117.82831, 34.07433]]]} Open Access 1 20556 Via Verde Park 27068 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 8.214 Via Verde Park 0 Local Park 2 4
13651 13651 13650 {"type": "Polygon", "coordinates": [[[-117.81356, 34.10464], [-117.81356, 34.10562], [-117.81158, 34.10562], [-117.81158, 34.10464], [-117.81356, 34.10464]]]} Open Access 1 46089 Pioneer Park 23731 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 4.913 Pioneer Park 0 Local Park 2 4
15183 15183 15182 {"type": "Polygon", "coordinates": [[[-117.8077, 34.10472], [-117.8077, 34.10513], [-117.80724, 34.10513], [-117.80724, 34.10472], [-117.8077, 34.10472]]]} Open Access 1 46157 Freedom Park 29438 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 0.484 Freedom Park 0 Local Park 2 4
15208 15208 15207 {"type": "Polygon", "coordinates": [[[-117.80379, 34.10629], [-117.80379, 34.10653], [-117.80311, 34.10653], [-117.80311, 34.10629], [-117.80379, 34.10629]]]} Open Access 1 46096 Settler's Court 29445 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 0.409 Settler's Court 0 Local Park 2 4
15211 15211 15210 {"type": "Polygon", "coordinates": [[[-117.78472, 34.13346], [-117.7846, 34.13358], [-117.78439, 34.13369], [-117.78404, 34.13347], [-117.78434, 34.13333], [-117.7844, 34.13327], [-117.78472, 34.13346]]]} Open Access 1 46105 Terrebonne Park 29451 1298 San Dimas, City of 237 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 1298 San Dimas, City of 233 City 2 City Agency 2   Los Angeles 6 0.365 Terrebonne 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]);