units_with_maps

Table actions

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

8 rows where COUNTY = 10, GAP_STS = 4, MNG_AGENCY = 211 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 8 ✖

MNG_AGENCY 1

  • Palm Desert, City of · 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
14009 14009 14008 {"type": "Polygon", "coordinates": [[[-116.3736, 33.7155], [-116.3736, 33.71665], [-116.37357, 33.71669], [-116.37171, 33.71671], [-116.37166, 33.71668], [-116.37165, 33.7155], [-116.3736, 33.7155]]]} Restricted Access 2 39070 Washington Charter School Park 31654 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 5.945 Washington Charter School 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

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