units_with_maps

Table actions

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

8 rows where ACCESS_TYP = 1, MNG_AGENCY = 211 and MNG_AG_LEV = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Palm Desert, City of · 8 ✖

ACCESS_TYP 1

  • Open Access · 8 ✖
Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
584 584 583 {"type": "Polygon", "coordinates": [[[-116.38667, 33.7023], [-116.3866, 33.7023], [-116.38658, 33.70202], [-116.38633, 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 2198 Ironwood Park 20236 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 15.314 Ironwood Park 0 Local Park 2 4
2896 2896 2895 {"type": "Polygon", "coordinates": [[[-116.36542, 33.74351], [-116.36542, 33.74652], [-116.36493, 33.74652], [-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 12963 Hovley Soccer Park 20113 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 19.054 Hovley Soccer Park 0 Local Recreation Area 3 4
3994 3994 3993 {"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.7812], [-116.363, 33.78111], [-116.36306, 33.78116], [-116.36291, 33.78143], [-116.36325, 33.78158]]]} Open Access 1 39068 University Dog Park 26679 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 2.479 University Dog Park 0 Local Park 2 4
11307 11307 11306 {"type": "Polygon", "coordinates": [[[-116.30887, 33.74041], [-116.30887, 33.74077], [-116.30728, 33.74152], [-116.30717, 33.74152], [-116.30733, 33.74116], [-116.30754, 33.74112], [-116.30744, 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.30753, 33.74073], [-116.30797, 33.74074], [-116.30798, 33.74073], [-116.30797, 33.7404], [-116.30885, 33.7404], [-116.30887, 33.74041]]]} Open Access 1 22013 Joe Mann Park 20422 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 2.617 Joe Mann Park 0 Local Park 2 4
11994 11994 11993 {"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.72385], [-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 24652 Palma Village Park 23350 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 1.998 Palma Village Park 0 Local Park 2 4
14062 14062 14061 {"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.31605, 33.75982], [-116.31629, 33.75964], [-116.3165, 33.75943], [-116.31664, 33.75924], [-116.31675, 33.75903], [-116.31683, 33.75876], [-116.31684, 33.75853], [-116.31676, 33.75846], [-116.31625, 33.75846], [-116.31595, 33.75843], [-116.31336, 33.75841], [-116.31335, 33.75986], [-116.31457, 33.75987], [-116.31458, 33.75993], [-116.3149, 33.75994], [-116.31496, 33.75999], [-116.31497, 33.76008], [-116.315, 33.76013], [-116.31505, 33.76015], [-116.31519, 33.76015], [-116.31554, 33.75988], [-116.3159, 33.75965]]]} Open Access 1 39065 Freedom Park 19087 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 22.93 Freedom Park 0 Local Park 2 4
14063 14063 14062 {"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 39069 University Park East 26688 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 2.501 University Park East 0 Local Park 2 4
16973 16973 16972 {"type": "MultiPolygon", "coordinates": [[[[-116.40815, 33.67042], [-116.40786, 33.67036], [-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.40528, 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.40684, 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.72641], [-116.4064, 33.7255], [-116.40497, 33.72403], [-116.40463, 33.72346], [-116.40453, 33.72287], [-116.40411, 33.72255], [-116.40389, 33.72245], [-116.40392, 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.72149], [-116.40175, 33.7185], [-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.40319, 33.717], [-116.40326, 33.71705], [-116.40359, 33.7171], [-116.40379, 33.71717], [-116.4039, 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.71801], [-116.40387, 33.71809], [-116.40386, 33.71821], [-116.40388, 33.71829], [-116.40363, 33.71859], [-116.40435, 33.71968], [-116.40505, 33.72005], [-116.40443, 33.72029], [-116.40465, 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.41563, 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.41648, 33.6729], [-116.41612, 33.67323], [-116.41612, 33.6734], [-116.41694, 33.67337], [-116.41696, 33.67309], [-116.41677, 33.67294], [-116.41672, 33.67293]]]]} Open Access 1 5785 Santa Rosa and San Jacinto Mountains National Monument 8325 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 562.433 Santa Rosa and San Jacinto Mtns. NM 2000 National Monument or Landmark 80 3

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);