units_with_maps

Table actions

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

6 rows where AGNCY_NAME = 85 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: COUNTY

MNG_AG_TYP 1

  • City Agency · 6 ✖

MNG_AGENCY 1

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
207 207 206 {"type": "Polygon", "coordinates": [[[-118.19702, 33.98473], [-118.19697, 33.98506], [-118.19606, 33.98497], [-118.19611, 33.98464], [-118.19702, 33.98473]]]} Open Access 1 652 Freedom Park 19085 1142 Huntington Park, City of 85 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 1142 Huntington Park, City of 83 City 2 City Agency 2   Los Angeles 6 0.791 Freedom Park 0 Local Park 2 4
869 869 868 {"type": "Polygon", "coordinates": [[[-118.21896, 33.9795], [-118.2179, 33.97955], [-118.21788, 33.97973], [-118.21726, 33.97974], [-118.21724, 33.97902], [-118.21895, 33.97897], [-118.21896, 33.9795]]]} Open Access 1 5618 Robert Keller Park 24488 1142 Huntington Park, City of 85 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 1142 Huntington Park, City of 83 City 2 City Agency 2   Los Angeles 6 2.623 Robert Keller Park 0 Local Park 2 4
4218 4218 4217 {"type": "Polygon", "coordinates": [[[-118.2367, 33.98596], [-118.23538, 33.98596], [-118.23538, 33.98563], [-118.23509, 33.98563], [-118.23513, 33.98502], [-118.23491, 33.98501], [-118.23495, 33.98473], [-118.23554, 33.98474], [-118.23576, 33.98471], [-118.23643, 33.98471], [-118.2367, 33.98596]]]} Open Access 1 44972 Raul R. Perez Memorial Park 29335 1142 Huntington Park, City of 85 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 1142 Huntington Park, City of 83 City 2 City Agency 2 http://ca-huntingtonpark2.civicplus.com/index.aspx?NID=35 Los Angeles 6 4.475 Raul R. Perez Memorial Park 0 Local Park 2 4
6336 6336 6335 {"type": "Polygon", "coordinates": [[[-118.0693, 33.71722], [-118.06917, 33.71732], [-118.06861, 33.71687], [-118.06878, 33.71676], [-118.0693, 33.71722]]]} Open Access 1 47442 11th Street Beach Park 31159 1142 Huntington Park, City of 85 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 1142 Huntington Park, City of 83 City 2 City Agency 2 http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/11th-street-beach-park.cfm Orange 3 0.322 11th Street Beach Park 0 Local Park 2 4
7937 7937 7936 {"type": "MultiPolygon", "coordinates": [[[[-118.20552, 33.97466], [-118.20394, 33.97444], [-118.20383, 33.97398], [-118.20368, 33.97343], [-118.20343, 33.97267], [-118.2035, 33.97207], [-118.20511, 33.97224], [-118.20493, 33.97349], [-118.20515, 33.97352], [-118.20518, 33.97355], [-118.20552, 33.97466]]], [[[-118.20861, 33.97592], [-118.20856, 33.97598], [-118.20835, 33.97602], [-118.20809, 33.97616], [-118.20794, 33.97619], [-118.20614, 33.97597], [-118.20602, 33.97564], [-118.20582, 33.975], [-118.20562, 33.97468], [-118.20527, 33.97353], [-118.20523, 33.97347], [-118.2051, 33.97343], [-118.20508, 33.9734], [-118.20525, 33.97226], [-118.20716, 33.97246], [-118.20721, 33.97432], [-118.20791, 33.97439], [-118.20798, 33.9745], [-118.20853, 33.97492], [-118.20857, 33.975], [-118.20858, 33.97506], [-118.20861, 33.97592]]]]} Open Access 1 10758 Salt Lake Park 24810 1142 Huntington Park, City of 85 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 1142 Huntington Park, City of 83 City 2 City Agency 2   Los Angeles 6 30.099 Salt Lake Park 0 Local Park 2 4
11909 11909 11908 {"type": "Polygon", "coordinates": [[[-118.23272, 33.97971], [-118.23271, 33.97976], [-118.23269, 33.97981], [-118.23264, 33.97984], [-118.23257, 33.97986], [-118.23251, 33.97985], [-118.23245, 33.97983], [-118.23241, 33.97978], [-118.23239, 33.97973], [-118.2324, 33.97968], [-118.23244, 33.97963], [-118.23254, 33.97959], [-118.23261, 33.97959], [-118.23267, 33.97962], [-118.23271, 33.97966], [-118.23272, 33.97971]]]} Open Access 1 24509 Chesley Circle Park 29336 1142 Huntington Park, City of 85 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 1142 Huntington Park, City of 83 City 2 City Agency 2   Los Angeles 6 0.175 Chesley Circle 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]);