superunits_with_maps

Table actions

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

8 rows where ACCESS_TYP = 1, LABEL_NAME = "Freedom Park" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 8 ✖

ACCESS_TYP 1

  • Open Access · 8 ✖
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
654 654 653 {"type": "Polygon", "coordinates": [[[-117.67437, 35.61964], [-117.67437, 35.62149], [-117.6735, 35.6215], [-117.67322, 35.62129], [-117.67301, 35.62106], [-117.67293, 35.62092], [-117.67291, 35.62083], [-117.67291, 35.62061], [-117.67297, 35.62049], [-117.6731, 35.62028], [-117.67392, 35.61961], [-117.67437, 35.61964]]]} Open Access 1 Freedom Park   33536 1275 Ridgecrest, City of 744 City 2 City Agency 2 http://ridgecrest-ca.gov/recreation City 2 5.384 Freedom Park  
4393 4393 4392 {"type": "Polygon", "coordinates": [[[-118.61397, 34.14366], [-118.61376, 34.14394], [-118.6135, 34.14391], [-118.61317, 34.14406], [-118.61301, 34.14401], [-118.61292, 34.14407], [-118.61288, 34.14419], [-118.6128, 34.14428], [-118.61258, 34.14418], [-118.6127, 34.14403], [-118.61271, 34.14367], [-118.61341, 34.14365], [-118.61397, 34.14366]]]} Open Access 1 Freedom Park   19083 1040 Calabasas, City of 310 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation.html City 2 1.111 Freedom Park  
4394 4394 4393 {"type": "Polygon", "coordinates": [[[-118.39887, 33.92355], [-118.39842, 33.92355], [-118.39841, 33.92095], [-118.39885, 33.92094], [-118.39887, 33.92355]]]} Open Access 1 Freedom Park   19084 1096 El Segundo, City of 296 City 2 City Agency 2 http://www.elsegundo.org/depts/recreation/default.asp City 2 3.002 Freedom Park  
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  
4396 4396 4395 {"type": "Polygon", "coordinates": [[[-120.93047, 37.67448], [-120.92816, 37.6745], [-120.92813, 37.67234], [-120.93044, 37.67232], [-120.93047, 37.67448]]]} Open Access 1 Freedom Park   19086 1208 Modesto, City of 510 City 2 City Agency 2 http://www.modestogov.com/prnd/ City 2 12.076 Freedom Park  
4397 4397 4396 {"type": "Polygon", "coordinates": [[[-116.31697, 33.7584], [-116.31696, 33.75867], [-116.3169, 33.75897], [-116.31677, 33.75925], [-116.31661, 33.75948], [-116.31646, 33.75965], [-116.31625, 33.75982], [-116.31618, 33.75976], [-116.31594, 33.7599], [-116.31584, 33.7599], [-116.31576, 33.75993], [-116.31572, 33.75997], [-116.31569, 33.76004], [-116.31543, 33.76019], [-116.31526, 33.76033], [-116.31514, 33.76047], [-116.31504, 33.76066], [-116.31499, 33.76081], [-116.31496, 33.76097], [-116.31495, 33.76169], [-116.31492, 33.76185], [-116.31493, 33.7619], [-116.31496, 33.76196], [-116.31496, 33.76313], [-116.31247, 33.76238], [-116.31251, 33.75837], [-116.31697, 33.7584]], [[-116.3159, 33.75965], [-116.31606, 33.75981], [-116.31629, 33.75964], [-116.3165, 33.75943], [-116.31664, 33.75924], [-116.31675, 33.75903], [-116.31683, 33.75876], [-116.31684, 33.75852], [-116.31675, 33.75846], [-116.31625, 33.75846], [-116.31595, 33.75843], [-116.31336, 33.75842], [-116.31336, 33.75986], [-116.31457, 33.75987], [-116.31459, 33.75993], [-116.3149, 33.75994], [-116.31496, 33.75999], [-116.31497, 33.76008], [-116.315, 33.76013], [-116.31505, 33.76015], [-116.31518, 33.76015], [-116.31554, 33.75988], [-116.3159, 33.75965]]]} Open Access 1 Freedom Park   19087 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 22.97 Freedom Park  
11770 11770 11769 {"type": "Polygon", "coordinates": [[[-119.62794, 36.3463], [-119.62793, 36.34809], [-119.62474, 36.34808], [-119.62456, 36.34739], [-119.6245, 36.3474], [-119.62448, 36.3473], [-119.62444, 36.34726], [-119.62439, 36.34723], [-119.62423, 36.34725], [-119.62396, 36.34627], [-119.62794, 36.3463]]]} Open Access 1 Freedom Park http://www.ci.hanford.ca.us/depts/rec/parks/default.asp 28385 1129 Hanford, City of 346 City 2 City Agency 2 http://www.ci.hanford.ca.us/depts/rec/default.asp City 2 15.946 Freedom Park  
12424 12424 12423 {"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 Freedom Park   29438 1298 San Dimas, City of 233 City 2 City Agency 2 http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 City 2 0.484 Freedom 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]);