superunits_with_maps

Table actions

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

9 rows where MNG_AGENCY = 211 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 9 ✖

MNG_AGENCY 1

  • Palm Desert, City of · 9 ✖
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
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  
5267 5267 5266 {"type": "Polygon", "coordinates": [[[-116.36542, 33.74351], [-116.36542, 33.74652], [-116.36493, 33.74653], [-116.36493, 33.74695], [-116.36312, 33.74695], [-116.36312, 33.74393], [-116.36361, 33.74392], [-116.36361, 33.74351], [-116.36542, 33.74351]]]} Open Access 1 Hovley Soccer Park   20113 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 19.059 Hovley Soccer Park  
5372 5372 5371 {"type": "Polygon", "coordinates": [[[-116.38667, 33.7023], [-116.3866, 33.7023], [-116.38657, 33.70202], [-116.38634, 33.70203], [-116.38633, 33.7023], [-116.38447, 33.7023], [-116.38441, 33.69954], [-116.38662, 33.69954], [-116.38665, 33.70043], [-116.38667, 33.7023]]]} Open Access 1 Ironwood Park   20236 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 15.318 Ironwood Park  
5540 5540 5539 {"type": "Polygon", "coordinates": [[[-116.30887, 33.74041], [-116.30887, 33.74077], [-116.30728, 33.74152], [-116.30717, 33.74152], [-116.30733, 33.74116], [-116.30753, 33.74112], [-116.30745, 33.74077], [-116.3071, 33.74081], [-116.30683, 33.74079], [-116.30695, 33.74068], [-116.30711, 33.74057], [-116.30729, 33.74048], [-116.30746, 33.74043], [-116.30754, 33.74073], [-116.30797, 33.74074], [-116.30798, 33.74072], [-116.30797, 33.7404], [-116.30885, 33.7404], [-116.30887, 33.74041]]]} Open Access 1 Joe Mann Park   20422 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 2.624 Joe Mann Park  
7877 7877 7876 {"type": "Polygon", "coordinates": [[[-116.38074, 33.72332], [-116.38074, 33.72337], [-116.38056, 33.72392], [-116.38044, 33.72411], [-116.38026, 33.72431], [-116.37976, 33.72386], [-116.37952, 33.72419], [-116.379, 33.72402], [-116.37912, 33.72387], [-116.37916, 33.72384], [-116.37955, 33.72373], [-116.3799, 33.7236], [-116.38027, 33.72344], [-116.38058, 33.72326], [-116.38068, 33.72326], [-116.38074, 33.72332]]]} Open Access 1 Palma Village Park   23350 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 2.002 Palma Village Park  
9121 9121 9120 {"type": "Polygon", "coordinates": [[[-116.35903, 33.77728], [-116.35778, 33.77835], [-116.35772, 33.77841], [-116.3576, 33.77814], [-116.3575, 33.77779], [-116.35747, 33.77756], [-116.35747, 33.77734], [-116.35752, 33.77726], [-116.35761, 33.77723], [-116.35872, 33.77725], [-116.35903, 33.77728]]]} Open Access 1 University Park East   26688 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 2.501 University Park East  
10566 10566 10565 {"type": "Polygon", "coordinates": [[[-116.36325, 33.78158], [-116.36306, 33.78189], [-116.36299, 33.78189], [-116.36294, 33.78191], [-116.3629, 33.78196], [-116.36288, 33.782], [-116.36283, 33.782], [-116.36255, 33.78223], [-116.36223, 33.78193], [-116.36184, 33.78152], [-116.36186, 33.78144], [-116.3621, 33.78123], [-116.3623, 33.78099], [-116.36287, 33.78119], [-116.363, 33.78111], [-116.36306, 33.78116], [-116.36291, 33.78143], [-116.36325, 33.78158]]]} Open Access 1 University Dog Park   26679 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 2.483 University Dog Park  
14178 14178 14177 {"type": "Polygon", "coordinates": [[[-116.3736, 33.71665], [-116.37357, 33.71669], [-116.37171, 33.71671], [-116.37166, 33.71668], [-116.37165, 33.7155], [-116.3736, 33.7155], [-116.3736, 33.71665]]]} Restricted Access 2 Washington Charter School Park   31654 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 5.944 Washington Charter School Park  
15581 15581 15580 {"type": "MultiPolygon", "coordinates": [[[[-116.40815, 33.67042], [-116.40786, 33.67037], [-116.40782, 33.67052], [-116.40799, 33.67062], [-116.39102, 33.67062], [-116.391, 33.66342], [-116.39893, 33.66343], [-116.39911, 33.66404], [-116.40094, 33.66486], [-116.40196, 33.66555], [-116.40233, 33.66566], [-116.40387, 33.6657], [-116.4042, 33.66582], [-116.40453, 33.66609], [-116.40497, 33.66685], [-116.4053, 33.66712], [-116.40552, 33.66717], [-116.40529, 33.66757], [-116.40635, 33.66818], [-116.40697, 33.6684], [-116.40765, 33.66936], [-116.40814, 33.66949], [-116.40815, 33.67042]]], [[[-116.40827, 33.72153], [-116.40815, 33.72862], [-116.40669, 33.72863], [-116.40669, 33.72848], [-116.40683, 33.7284], [-116.40655, 33.72811], [-116.40623, 33.7282], [-116.40596, 33.72815], [-116.40582, 33.72814], [-116.40548, 33.72787], [-116.40502, 33.72771], [-116.40502, 33.72751], [-116.40505, 33.72734], [-116.40537, 33.72647], [-116.40619, 33.7264], [-116.40639, 33.72549], [-116.40497, 33.72403], [-116.40463, 33.72346], [-116.40453, 33.72287], [-116.40411, 33.72255], [-116.40389, 33.72245], [-116.40391, 33.72232], [-116.40349, 33.72228], [-116.4033, 33.72239], [-116.40281, 33.72177], [-116.4027, 33.7215], [-116.4029, 33.7215], [-116.40291, 33.72148], [-116.40176, 33.71851], [-116.40156, 33.71853], [-116.40039, 33.71553], [-116.40161, 33.71553], [-116.402, 33.71581], [-116.40276, 33.71609], [-116.40281, 33.71616], [-116.40284, 33.71642], [-116.40297, 33.71668], [-116.40302, 33.71674], [-116.40306, 33.71693], [-116.40319, 33.71696], [-116.4032, 33.717], [-116.40326, 33.71705], [-116.40359, 33.7171], [-116.40379, 33.71717], [-116.40391, 33.71725], [-116.40409, 33.71744], [-116.4044, 33.71793], [-116.40416, 33.71802], [-116.40406, 33.71789], [-116.40398, 33.71792], [-116.40391, 33.718], [-116.40388, 33.71809], [-116.40386, 33.71821], [-116.40388, 33.71829], [-116.40363, 33.7186], [-116.40435, 33.71968], [-116.40505, 33.72005], [-116.40443, 33.7203], [-116.40466, 33.72151], [-116.40827, 33.72153]]], [[[-116.42543, 33.68504], [-116.4238, 33.68504], [-116.42375, 33.68413], [-116.42366, 33.68321], [-116.42348, 33.68225], [-116.42102, 33.67791], [-116.42092, 33.67739], [-116.41891, 33.67625], [-116.41686, 33.6757], [-116.4163, 33.67524], [-116.41641, 33.67467], [-116.41631, 33.67457], [-116.41632, 33.67446], [-116.41628, 33.67436], [-116.41599, 33.67408], [-116.41578, 33.67406], [-116.41562, 33.67392], [-116.41474, 33.67379], [-116.41409, 33.67414], [-116.41322, 33.67388], [-116.41171, 33.67319], [-116.41164, 33.67302], [-116.41166, 33.6721], [-116.4118, 33.6721], [-116.4119, 33.67207], [-116.41196, 33.672], [-116.41201, 33.67187], [-116.412, 33.67179], [-116.41196, 33.67172], [-116.41186, 33.67163], [-116.41177, 33.67159], [-116.41442, 33.67067], [-116.41673, 33.67067], [-116.41674, 33.67069], [-116.4254, 33.67068], [-116.42543, 33.68504]], [[-116.41672, 33.67293], [-116.41647, 33.6729], [-116.41612, 33.67323], [-116.41612, 33.67339], [-116.41694, 33.67337], [-116.41696, 33.67309], [-116.41677, 33.67294], [-116.41672, 33.67293]]]]} Open Access 1 Santa Rosa and San Jacinto Mountains National Monument   8325 1240 Palm Desert, City of 211 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 562.495 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]);