units_with_maps

Table actions

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

11 rows where ACCESS_TYP = 1, COUNTY = 6 and MNG_AGENCY = 236

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 11 ✖
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
690 690 689 {"type": "Polygon", "coordinates": [[[-118.02084, 34.08493], [-118.02045, 34.08668], [-118.01823, 34.08646], [-118.01896, 34.08494], [-118.01904, 34.08466], [-118.02084, 34.08493]]]} Open Access 1 3537 Lambert Park 20992 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 9.286 Lambert Park 0 Local Park 2 4
2647 2647 2646 {"type": "Polygon", "coordinates": [[[-118.03613, 34.06478], [-118.03686, 34.06474], [-118.03691, 34.06477], [-118.0369, 34.06637], [-118.03687, 34.06641], [-118.03654, 34.06638], [-118.03614, 34.06638], [-118.0361, 34.06635], [-118.0361, 34.0657], [-118.03603, 34.065], [-118.03613, 34.06478]]]} Open Access 1 18108 Arceo Park 15573 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 3.374 Arceo Park 0 Local Park 2 4
3033 3033 3032 {"type": "Polygon", "coordinates": [[[-118.03917, 34.08228], [-118.03852, 34.0832], [-118.03847, 34.08344], [-118.0383, 34.08335], [-118.0383, 34.08331], [-118.03828, 34.08327], [-118.03824, 34.08325], [-118.03818, 34.08325], [-118.03813, 34.08328], [-118.03781, 34.08313], [-118.03833, 34.08216], [-118.03864, 34.0822], [-118.03869, 34.08229], [-118.03873, 34.08232], [-118.03881, 34.08232], [-118.03885, 34.08231], [-118.03892, 34.08225], [-118.03917, 34.08228]]]} Open Access 1 20578 Rio Vista PArk 24391 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 2.143 Rio Vista PArk   None 248  
3062 3062 3061 {"type": "Polygon", "coordinates": [[[-118.04858, 34.07115], [-118.04761, 34.07159], [-118.04685, 34.07197], [-118.04685, 34.07037], [-118.04858, 34.07115]]]} Open Access 1 20580 Fletcher Park 18948 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 3.459 Fletcher Park 0 Local Park 2 4
3948 3948 3947 {"type": "Polygon", "coordinates": [[[-118.04159, 34.07653], [-118.04136, 34.07675], [-118.04136, 34.07672], [-118.04131, 34.07675], [-118.0408, 34.07723], [-118.04095, 34.07699], [-118.04114, 34.0766], [-118.0414, 34.07651], [-118.04159, 34.07653]]]} Open Access 1 46363 Gateway/Veterans Park 29641 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 0.32 Gateway/Veterans Park 0 Local Park 2 4
4014 4014 4013 {"type": "Polygon", "coordinates": [[[-118.01207, 34.07165], [-118.01152, 34.07275], [-118.01061, 34.07243], [-118.01092, 34.07179], [-118.01001, 34.07147], [-118.01024, 34.071], [-118.01027, 34.07098], [-118.01031, 34.07098], [-118.01204, 34.07159], [-118.01207, 34.07161], [-118.01207, 34.07165]]]} Open Access 1 20679 Zamora Park 27852 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 4.486 Zamora Park 0 Local Park 2 4
5039 5039 5038 {"type": "Polygon", "coordinates": [[[-118.05352, 34.07636], [-118.05344, 34.07676], [-118.05258, 34.07641], [-118.05258, 34.07637], [-118.05352, 34.07636]]]} Open Access 1 20579 Baldwin Mini Park 15778 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 0.528 Baldwin MP 0 Local Park 2 4
6091 6091 6090 {"type": "Polygon", "coordinates": [[[-118.02351, 34.05601], [-118.02203, 34.05722], [-118.02146, 34.05675], [-118.02129, 34.05687], [-118.02041, 34.05611], [-118.02205, 34.05478], [-118.02209, 34.0548], [-118.02351, 34.05601]]]} Open Access 1 5545 Mountain View Park 22553 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 9.751 Mtn. View Park 0 Local Park 2 4
14941 14941 14940 {"type": "Polygon", "coordinates": [[[-118.04947, 34.08112], [-118.04899, 34.0824], [-118.04774, 34.08199], [-118.04798, 34.0809], [-118.04947, 34.08112]]]} Open Access 1 45540 Gibson Mariposa Neighborhood Park 28369 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2 http://www.ci.el-monte.ca.us/Government/ParksRecCommunitySrvs.aspx Los Angeles 6 4.413 Gibson Mariposa Neighborhood Park 0 Local Park 2 4
15252 15252 15251 {"type": "Polygon", "coordinates": [[[-118.03987, 34.07959], [-118.03911, 34.08069], [-118.03782, 34.08312], [-118.03785, 34.08315], [-118.03742, 34.08386], [-118.03733, 34.08382], [-118.03894, 34.0808], [-118.03944, 34.08002], [-118.03981, 34.07956], [-118.03987, 34.07959]]]} Open Access 1 46368 Rio Hondo River Trail 29645 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 1.227 Rio Hondo River Trail 0 Local Recreation Area 3 4
15275 15275 15274 {"type": "Polygon", "coordinates": [[[-118.06605, 34.064], [-118.06572, 34.06421], [-118.06559, 34.06431], [-118.06518, 34.06471], [-118.06469, 34.06509], [-118.06328, 34.06608], [-118.06323, 34.06603], [-118.06325, 34.06602], [-118.06324, 34.06547], [-118.0637, 34.06546], [-118.06591, 34.06386], [-118.06605, 34.064]]]} Open Access 1 46367 Lashbrook Park 29644 1095 El Monte, City of 240 City 2 City Agency 2 http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx City 2 1095 El Monte, City of 236 City 2 City Agency 2   Los Angeles 6 2.288 Lashbrook 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]);