superunits_with_maps

Table actions

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

7 rows where ACCESS_TYP = 1, MNG_AGENCY = 630 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 7 ✖

MNG_AGENCY 1

  • Desert Hot Springs, City of · 7 ✖

ACCESS_TYP 1

  • Open Access · 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
418 418 417 {"type": "Polygon", "coordinates": [[[-116.49934, 33.94046], [-116.49924, 33.94316], [-116.49819, 33.94316], [-116.49818, 33.94225], [-116.4971, 33.94225], [-116.49718, 33.94045], [-116.49934, 33.94046]]]} Open Access 1 Mission Springs Park   32032 1670 Desert Hot Springs, City of 630 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 12.335 Mission Springs Park  
4809 4809 4808 {"type": "Polygon", "coordinates": [[[-116.50995, 33.95761], [-116.50995, 33.95766], [-116.50944, 33.95766], [-116.50889, 33.95733], [-116.50866, 33.95711], [-116.50861, 33.95705], [-116.50853, 33.95649], [-116.5084, 33.95608], [-116.50835, 33.95599], [-116.50822, 33.95589], [-116.50752, 33.95552], [-116.5074, 33.95546], [-116.50685, 33.95529], [-116.50651, 33.95508], [-116.50645, 33.955], [-116.50642, 33.95476], [-116.50637, 33.95465], [-116.50631, 33.95458], [-116.50591, 33.95426], [-116.50655, 33.95426], [-116.50672, 33.95464], [-116.50719, 33.95512], [-116.50732, 33.95518], [-116.50797, 33.95534], [-116.50843, 33.95568], [-116.50849, 33.95574], [-116.50872, 33.95626], [-116.5088, 33.95669], [-116.50902, 33.95709], [-116.5092, 33.95726], [-116.50928, 33.95731], [-116.50995, 33.95761]]]} Open Access 1 Guy J. Tedesco Park   19576 1670 Desert Hot Springs, City of 630 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 3.923 Guy J. Tedesco Park  
10802 10802 10801 {"type": "Polygon", "coordinates": [[[-116.50189, 33.97559], [-116.50153, 33.97559], [-116.50153, 33.9753], [-116.50154, 33.97527], [-116.5016, 33.97524], [-116.50189, 33.97524], [-116.50189, 33.97559]]]} Open Access 1 Veteran's Memorial Park   27015 1670 Desert Hot Springs, City of 630 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 0.326 Veteran's Memorial Park  
11023 11023 11022 {"type": "Polygon", "coordinates": [[[-116.50858, 33.96881], [-116.50832, 33.96892], [-116.50803, 33.96908], [-116.50774, 33.96927], [-116.50749, 33.96948], [-116.50727, 33.96971], [-116.50708, 33.96995], [-116.50693, 33.9702], [-116.5068, 33.9705], [-116.50588, 33.9705], [-116.50588, 33.96882], [-116.50858, 33.96881]]]} Open Access 1 Wardman Park   27259 1670 Desert Hot Springs, City of 630 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 6.619 Wardman Park  
11779 11779 11778 {"type": "Polygon", "coordinates": [[[-116.51081, 33.96249], [-116.51064, 33.96265], [-116.51039, 33.96264], [-116.51037, 33.96261], [-116.51024, 33.96261], [-116.51024, 33.96232], [-116.51076, 33.96232], [-116.5108, 33.96236], [-116.51081, 33.96249]]]} Open Access 1 Frank Hodge Skate Park   28395 1670 Desert Hot Springs, City of 630 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 0.428 Frank Hodge Skate Park  
14050 14050 14049 {"type": "Polygon", "coordinates": [[[-116.46046, 33.95158], [-116.4604, 33.95167], [-116.45955, 33.95175], [-116.45948, 33.95163], [-116.45951, 33.95157], [-116.45952, 33.9515], [-116.4595, 33.95145], [-116.45946, 33.95142], [-116.45931, 33.95138], [-116.45924, 33.95117], [-116.45937, 33.95129], [-116.45982, 33.9515], [-116.46046, 33.95158]]]} Open Access 1 Rotary Dog Park   32625 1670 Desert Hot Springs, City of 630 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 0.555 Rotary Dog Park 2017
14051 14051 14050 {"type": "Polygon", "coordinates": [[[-116.50201, 33.96919], [-116.50197, 33.96923], [-116.50197, 33.96987], [-116.50151, 33.96987], [-116.50152, 33.96885], [-116.50158, 33.96882], [-116.50199, 33.96882], [-116.50199, 33.96915], [-116.50201, 33.96919]]]} Open Access 1 Hot Springs Park   32626 1670 Desert Hot Springs, City of 630 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 1.236 Hot Springs 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]);