units_with_maps

Table actions

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

9 rows where COUNTY = 10, DES_TP = 2 and MNG_AGENCY = 546

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Palm Springs, City of · 9 ✖

DES_TP 1

  • Local Park · 9 ✖

ACCESS_TYP 1

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
2783 2783 2782 {"type": "Polygon", "coordinates": [[[-116.50843, 33.80945], [-116.50824, 33.80934], [-116.5073, 33.81041], [-116.50623, 33.80975], [-116.50623, 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.50078, 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 18549 Demuth Park 18082 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 44.804 Demuth Park 0 Local Park 2 4
3423 3423 3422 {"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 25147 Baristo Park 15814 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 1.082 Baristo Park 0 Local Park 2 4
5146 5146 5145 {"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 10617 Ruth Hardy Park 24752 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 21.7 Ruth Hardy Park 0 Local Park 2 4
5541 5541 5540 {"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 39080 Frances Stevens Park 19041 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 0.975 Frances Stevens Park 0 Local Park 2 4
5542 5542 5541 {"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 39081 Wellness Park 27343 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 4.891 Wellness Park 0 Local Park 2 4
5543 5543 5542 {"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 39082 Dog Park 18182 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 1.309 Dog Park 0 Local Park 2 4
8367 8367 8366 {"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 12965 Victoria Park 27080 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 7.487 Victoria Park 0 Local Park 2 4
10068 10068 10067 {"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 17445 Sunrise Park 26024 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 28.157 Sunrise Park 0 Local Park 2 4
10744 10744 10743 {"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 19964 Desert Highland Park 18112 1241 Palm Springs, City of 553 City 2 City Agency 2 http://www.ci.palm-springs.ca.us/index.aspx?page=80 City 2 1241 Palm Springs, City of 546 City 2 City Agency 2   Riverside 10 18.077 Desert Highland Park 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]);