superunits_with_maps

Table actions

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

11 rows where MNG_AGENCY = 546 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 11 ✖

MNG_AGENCY 1

  • Palm Springs, City of · 11 ✖

ACCESS_TYP 1

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
1761 1761 1760 {"type": "Polygon", "coordinates": [[[-116.54353, 33.81885], [-116.54196, 33.81885], [-116.54196, 33.81846], [-116.54228, 33.8185], [-116.54264, 33.81853], [-116.54293, 33.81858], [-116.54323, 33.81868], [-116.54341, 33.81877], [-116.54353, 33.81885]]]} Open Access 1 Baristo Park   15814 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1.082 Baristo Park  
3472 3472 3471 {"type": "Polygon", "coordinates": [[[-116.54667, 33.83086], [-116.54574, 33.83085], [-116.54574, 33.83044], [-116.54667, 33.83044], [-116.54667, 33.83086]]]} Open Access 1 Frances Stevens Park   19041 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 0.974 Frances Stevens Park  
3557 3557 3556 {"type": "Polygon", "coordinates": [[[-116.50843, 33.80945], [-116.50823, 33.80934], [-116.5073, 33.81041], [-116.50623, 33.80975], [-116.50622, 33.80959], [-116.50489, 33.80877], [-116.50453, 33.8086], [-116.49734, 33.8086], [-116.49734, 33.80757], [-116.49883, 33.8075], [-116.49907, 33.80725], [-116.50077, 33.8072], [-116.50083, 33.80672], [-116.50179, 33.80632], [-116.50396, 33.80652], [-116.5042, 33.8067], [-116.50473, 33.80698], [-116.50497, 33.80723], [-116.50544, 33.80748], [-116.50598, 33.80782], [-116.50597, 33.8086], [-116.50843, 33.80861], [-116.50843, 33.80945]]]} Open Access 1 Demuth Park   18082 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 44.822 Demuth Park  
3583 3583 3582 {"type": "Polygon", "coordinates": [[[-116.55421, 33.86682], [-116.5542, 33.8687], [-116.5504, 33.86865], [-116.55038, 33.86679], [-116.55421, 33.86682]]]} Open Access 1 Desert Highland Park   18112 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 18.075 Desert Highland Park  
3636 3636 3635 {"type": "Polygon", "coordinates": [[[-116.51241, 33.82482], [-116.5124, 33.8249], [-116.51242, 33.82512], [-116.51239, 33.82523], [-116.51123, 33.82523], [-116.51122, 33.82501], [-116.51127, 33.82481], [-116.5117, 33.82478], [-116.51219, 33.82478], [-116.51236, 33.82479], [-116.51241, 33.82482]]]} Open Access 1 Dog Park   18182 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1.309 Dog Park  
9082 9082 9081 {"type": "Polygon", "coordinates": [[[-116.54124, 33.83396], [-116.54123, 33.83592], [-116.5369, 33.83593], [-116.5369, 33.83396], [-116.54124, 33.83396]]]} Open Access 1 Ruth Hardy Park   24752 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 21.699 Ruth Hardy Park  
9505 9505 9504 {"type": "Polygon", "coordinates": [[[-116.54109, 33.83601], [-116.54109, 33.83746], [-116.54103, 33.83749], [-116.53979, 33.83749], [-116.53979, 33.83601], [-116.54109, 33.83601]]]} Open Access 1 Wellness Park   27343 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 4.891 Wellness Park  
10107 10107 10106 {"type": "Polygon", "coordinates": [[[-116.52802, 33.81832], [-116.52702, 33.81801], [-116.52692, 33.81803], [-116.52676, 33.81824], [-116.52672, 33.81843], [-116.52662, 33.81856], [-116.5266, 33.8194], [-116.52399, 33.81942], [-116.52396, 33.81941], [-116.52392, 33.81936], [-116.52393, 33.81611], [-116.52397, 33.81608], [-116.52731, 33.81608], [-116.52732, 33.81712], [-116.52758, 33.81726], [-116.52802, 33.81727], [-116.52802, 33.81832]]]} Open Access 1 Sunrise Park   26024 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 28.159 Sunrise Park  
10184 10184 10183 {"type": "Polygon", "coordinates": [[[-116.52668, 33.80982], [-116.52625, 33.81149], [-116.52559, 33.81271], [-116.51999, 33.81312], [-116.51823, 33.81132], [-116.51825, 33.80975], [-116.52091, 33.80937], [-116.52107, 33.81008], [-116.5219, 33.8101], [-116.52353, 33.81046], [-116.52668, 33.80982]]]} Open Access 1 Tahquitz Wash   26169 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 56.108 Tahquitz Wash  
10863 10863 10862 {"type": "Polygon", "coordinates": [[[-116.5407, 33.85235], [-116.54067, 33.85399], [-116.539, 33.85399], [-116.53899, 33.85225], [-116.54069, 33.85224], [-116.54068, 33.85233], [-116.5407, 33.85235]]]} Open Access 1 Victoria Park   27080 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 7.486 Victoria Park  
15584 15584 15583 {"type": "MultiPolygon", "coordinates": [[[[-116.45598, 33.64882], [-116.44832, 33.64885], [-116.44301, 33.64885], [-116.44283, 33.64527], [-116.44726, 33.64525], [-116.44728, 33.6416], [-116.45169, 33.6416], [-116.45169, 33.64523], [-116.45597, 33.64524], [-116.45598, 33.64882]]], [[[-116.56323, 33.80153], [-116.55962, 33.80147], [-116.55074, 33.80137], [-116.55057, 33.80085], [-116.55113, 33.80049], [-116.55137, 33.80031], [-116.55159, 33.79937], [-116.55164, 33.79875], [-116.55161, 33.79843], [-116.55161, 33.79838], [-116.55155, 33.79832], [-116.55155, 33.79819], [-116.5516, 33.79775], [-116.55157, 33.79771], [-116.55148, 33.79766], [-116.55125, 33.79764], [-116.55184, 33.79763], [-116.55197, 33.79718], [-116.55157, 33.79687], [-116.55132, 33.79629], [-116.55046, 33.79594], [-116.55005, 33.79555], [-116.54939, 33.79511], [-116.54909, 33.79478], [-116.55181, 33.79477], [-116.55184, 33.79265], [-116.54945, 33.79262], [-116.54897, 33.79248], [-116.5486, 33.79157], [-116.54859, 33.79105], [-116.54789, 33.79103], [-116.54778, 33.79158], [-116.54768, 33.79158], [-116.54769, 33.79062], [-116.54751, 33.7906], [-116.5475, 33.78922], [-116.54744, 33.78921], [-116.54775, 33.78855], [-116.54807, 33.78802], [-116.54815, 33.78745], [-116.54809, 33.78704], [-116.54819, 33.78685], [-116.56316, 33.78691], [-116.56323, 33.80153]]], [[[-116.5631, 33.81604], [-116.56304, 33.82941], [-116.56085, 33.83032], [-116.55565, 33.83032], [-116.5543, 33.83027], [-116.55428, 33.8304], [-116.55352, 33.8304], [-116.55373, 33.83006], [-116.55403, 33.82972], [-116.55405, 33.82962], [-116.55405, 33.82957], [-116.554, 33.8295], [-116.55367, 33.82924], [-116.55362, 33.82908], [-116.5536, 33.82891], [-116.55357, 33.82887], [-116.55353, 33.82882], [-116.55321, 33.82864], [-116.55298, 33.82848], [-116.55284, 33.82824], [-116.55275, 33.82802], [-116.55268, 33.82796], [-116.55261, 33.82792], [-116.55248, 33.82789], [-116.55167, 33.8279], [-116.55101, 33.82809], [-116.5506, 33.82814], [-116.55043, 33.82823], [-116.55079, 33.82852], [-116.55129, 33.82881], [-116.55146, 33.82935], [-116.55175, 33.82934], [-116.55216, 33.82942], [-116.55266, 33.82935], [-116.55285, 33.82943], [-116.55302, 33.8296], [-116.55363, 33.82957], [-116.55366, 33.82993], [-116.55346, 33.8304], [-116.5481, 33.83015], [-116.54807, 33.82561], [-116.54829, 33.82541], [-116.55427, 33.8254], [-116.55424, 33.81778], [-116.55466, 33.81777], [-116.55465, 33.81673], [-116.55501, 33.81671], [-116.55501, 33.81628], [-116.55491, 33.81626], [-116.55491, 33.81593], [-116.5631, 33.81604]]], [[[-116.5806, 33.84508], [-116.56296, 33.84488], [-116.56305, 33.84079], [-116.56314, 33.84063], [-116.56318, 33.84051], [-116.56327, 33.84038], [-116.56332, 33.84017], [-116.56342, 33.83998], [-116.56347, 33.8399], [-116.56353, 33.83987], [-116.56355, 33.83979], [-116.56353, 33.83969], [-116.56354, 33.83957], [-116.56361, 33.83945], [-116.56354, 33.83933], [-116.56351, 33.83923], [-116.56349, 33.83906], [-116.56362, 33.83863], [-116.56357, 33.83849], [-116.56349, 33.83818], [-116.56351, 33.83804], [-116.56335, 33.83774], [-116.56331, 33.83758], [-116.5633, 33.83714], [-116.56335, 33.83681], [-116.56325, 33.83669], [-116.5646, 33.83668], [-116.56462, 33.83609], [-116.56444, 33.83583], [-116.56442, 33.83572], [-116.56451, 33.83549], [-116.56461, 33.8354], [-116.56478, 33.83534], [-116.56524, 33.8351], [-116.56549, 33.83501], [-116.56584, 33.83492], [-116.56626, 33.83484], [-116.56641, 33.83478], [-116.56658, 33.83466], [-116.56671, 33.83453], [-116.56696, 33.83461], [-116.56705, 33.8346], [-116.56708, 33.83455], [-116.5671, 33.83444], [-116.56715, 33.83437], [-116.56726, 33.83434], [-116.56729, 33.83428], [-116.56731, 33.83419], [-116.56735, 33.83417], [-116.56741, 33.83408], [-116.56738, 33.83393], [-116.56738, 33.83373], [-116.56732, 33.83366], [-116.56661, 33.83309], [-116.56634, 33.83294], [-116.56619, 33.83279], [-116.56616, 33.83268], [-116.56626, 33.83245], [-116.5663, 33.83208], [-116.56648, 33.83162], [-116.56666, 33.83103], [-116.5668, 33.83076], [-116.56675, 33.83045], [-116.57471, 33.83041], [-116.58024, 33.83042], [-116.58026, 33.83067], [-116.58059, 33.83067], [-116.5806, 33.84508]]], [[[-116.59707, 33.85934], [-116.58047, 33.85949], [-116.58043, 33.85485], [-116.58245, 33.85483], [-116.5868, 33.85048], [-116.58694, 33.85047], [-116.58874, 33.85195], [-116.59006, 33.85194], [-116.59174, 33.85027], [-116.59259, 33.84761], [-116.59258, 33.84609], [-116.59307, 33.8461], [-116.59621, 33.84759], [-116.59703, 33.84877], [-116.59707, 33.85934]]], [[[-116.58839, 33.78979], [-116.58817, 33.7898], [-116.58804, 33.78983], [-116.58789, 33.7899], [-116.58779, 33.79002], [-116.58763, 33.79028], [-116.58752, 33.79034], [-116.58742, 33.7903], [-116.58707, 33.78996], [-116.58697, 33.78967], [-116.58691, 33.78958], [-116.58674, 33.78955], [-116.58663, 33.7896], [-116.58654, 33.78969], [-116.58651, 33.78979], [-116.58644, 33.78988], [-116.58625, 33.78999], [-116.58619, 33.79], [-116.58573, 33.78994], [-116.58553, 33.78985], [-116.58535, 33.78981], [-116.5853, 33.78978], [-116.58524, 33.78972], [-116.58516, 33.78956], [-116.58501, 33.78941], [-116.58483, 33.78928], [-116.58457, 33.78907], [-116.5845, 33.78884], [-116.58445, 33.78879], [-116.58416, 33.7887], [-116.58414, 33.78669], [-116.58837, 33.78667], [-116.58839, 33.78979]]], [[[-116.59685, 33.79389], [-116.59266, 33.79392], [-116.59262, 33.79028], [-116.59684, 33.79025], [-116.59685, 33.79389]]], [[[-116.60571, 33.87064], [-116.60136, 33.87069], [-116.60135, 33.86804], [-116.6019, 33.86803], [-116.6019, 33.86712], [-116.60569, 33.86709], [-116.60571, 33.87064]]]]} Open Access 1 Santa Rosa and San Jacinto Mountains National Monument   8337 1241 Palm Springs, City of 546 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 2097.913 Santa Rosa and San Jacinto Mtns. NM 2000

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