superunits_with_maps

Table actions

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

7 rows where MNG_AGENCY = 83 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 7 ✖

MNG_AGENCY 1

  • Huntington Park, City of · 7 ✖
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
4395 4395 4394 {"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 Freedom Park   19085 1142 Huntington Park, City of 83 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 0.79 Freedom Park  
8826 8826 8825 {"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 Robert Keller Park   24488 1142 Huntington Park, City of 83 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 2.624 Robert Keller Park  
9135 9135 9134 {"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.97501], [-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.97431], [-118.20791, 33.97439], [-118.20798, 33.9745], [-118.20853, 33.97492], [-118.20857, 33.975], [-118.20859, 33.97506], [-118.20861, 33.97592]]]]} Open Access 1 Salt Lake Park   24810 1142 Huntington Park, City of 83 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 30.108 Salt Lake Park  
12311 12311 12310 {"type": "Polygon", "coordinates": [[[-118.2367, 33.98596], [-118.23538, 33.98596], [-118.23537, 33.98563], [-118.23509, 33.98563], [-118.23513, 33.98503], [-118.23491, 33.98501], [-118.23495, 33.98474], [-118.23554, 33.98474], [-118.23576, 33.98471], [-118.23643, 33.98471], [-118.2367, 33.98596]]]} Open Access 1 Raul R. Perez Memorial Park http://ca-huntingtonpark2.civicplus.com/index.aspx?NID=35 29335 1142 Huntington Park, City of 83 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 4.479 Raul R. Perez Memorial Park  
12312 12312 12311 {"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.23272, 33.97971]]]} Open Access 1 Chesley Circle Park   29336 1142 Huntington Park, City of 83 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 0.174 Chesley Circle Park  
12314 12314 12313 {"type": "Polygon", "coordinates": [[[-118.19697, 33.98506], [-118.19692, 33.98539], [-118.196, 33.9853], [-118.19606, 33.98497], [-118.19697, 33.98506]]]} Restricted Access 2 Freedom Park Athletic Field   29338 1142 Huntington Park, City of 83 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 0.778 Freedom Park Athletic Field  
13671 13671 13670 {"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 11th Street Beach Park http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/11th-street-beach-park.cfm 31159 1142 Huntington Park, City of 83 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 0.322 11th Street Beach Park  

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