units_with_maps

Table actions

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

7 rows where COUNTY = 10, MNG_AGENCY = 630 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, YR_EST

MNG_AG_TYP 1

  • City Agency · 7 ✖

MNG_AGENCY 1

  • Desert Hot Springs, City of · 7 ✖

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
3426 3426 3425 {"type": "Polygon", "coordinates": [[[-116.50995, 33.95761], [-116.50995, 33.95766], [-116.50944, 33.95766], [-116.5089, 33.95733], [-116.50866, 33.95711], [-116.50861, 33.95705], [-116.50853, 33.95649], [-116.5084, 33.95608], [-116.50835, 33.95599], [-116.50822, 33.95589], [-116.50752, 33.95552], [-116.5074, 33.95546], [-116.50685, 33.95529], [-116.50651, 33.95508], [-116.50645, 33.955], [-116.50642, 33.95476], [-116.50637, 33.95465], [-116.50631, 33.95458], [-116.50591, 33.95426], [-116.50655, 33.95426], [-116.50672, 33.95464], [-116.50719, 33.95512], [-116.50732, 33.95518], [-116.50797, 33.95534], [-116.50843, 33.95568], [-116.50849, 33.95574], [-116.50872, 33.95626], [-116.5088, 33.95669], [-116.50902, 33.95709], [-116.5092, 33.95726], [-116.50928, 33.95731], [-116.50995, 33.95761]]]} Open Access 1 25152 Guy J. Tedesco Park 19576 1670 Desert Hot Springs, City of 641 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 1670 Desert Hot Springs, City of 630 City 2 City Agency 2   Riverside 10 3.923 Guy J. Tedesco Park 0 Local Park 2 4
5159 5159 5158 {"type": "Polygon", "coordinates": [[[-116.50201, 33.96919], [-116.50197, 33.96923], [-116.50197, 33.96987], [-116.50151, 33.96987], [-116.50152, 33.96885], [-116.50158, 33.96882], [-116.50199, 33.96882], [-116.50199, 33.96916], [-116.50201, 33.96919]]]} Open Access 1 25153 Hot Springs Park 32626 1670 Desert Hot Springs, City of 641 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 1670 Desert Hot Springs, City of 630 City 2 City Agency 2   Riverside 10 1.236 Hot Springs Park 0 Local Park 2 4
5161 5161 5160 {"type": "Polygon", "coordinates": [[[-116.50189, 33.97559], [-116.50153, 33.97559], [-116.50153, 33.9753], [-116.50154, 33.97527], [-116.5016, 33.97524], [-116.50189, 33.97524], [-116.50189, 33.97559]]]} Open Access 1 25155 Veteran's Memorial Park 27015 1670 Desert Hot Springs, City of 641 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 1670 Desert Hot Springs, City of 630 City 2 City Agency 2   Riverside 10 0.326 Veteran's Memorial Park 0 Local Park 2 4
5438 5438 5437 {"type": "Polygon", "coordinates": [[[-116.49934, 33.94046], [-116.49924, 33.94316], [-116.49819, 33.94316], [-116.49818, 33.94225], [-116.4971, 33.94225], [-116.49718, 33.94045], [-116.49934, 33.94046]]]} Open Access 1 47920 Mission Springs Park 32032 2330 Mission Springs Water District 806 Special District 4 Water District 13   Special District 4 1670 Desert Hot Springs, City of 630 City 2 City Agency 2   Riverside 10 12.328 Mission Springs Park 0 Local Park 2 4
12149 12149 12148 {"type": "Polygon", "coordinates": [[[-116.50858, 33.96881], [-116.50832, 33.96892], [-116.50803, 33.96908], [-116.50774, 33.96927], [-116.50749, 33.96948], [-116.50727, 33.96971], [-116.50708, 33.96995], [-116.50693, 33.9702], [-116.5068, 33.9705], [-116.50588, 33.9705], [-116.50588, 33.96882], [-116.50858, 33.96881]]]} Open Access 1 25156 Wardman Park 27259 1670 Desert Hot Springs, City of 641 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 1670 Desert Hot Springs, City of 630 City 2 City Agency 2   Riverside 10 6.62 Wardman Park 0 Local Park 2 4
13055 13055 13054 {"type": "Polygon", "coordinates": [[[-116.46046, 33.95158], [-116.4604, 33.95167], [-116.45955, 33.95175], [-116.45948, 33.95163], [-116.45951, 33.95157], [-116.45952, 33.9515], [-116.4595, 33.95145], [-116.45946, 33.95142], [-116.45931, 33.95138], [-116.45924, 33.95117], [-116.45937, 33.95129], [-116.45982, 33.9515], [-116.46046, 33.95158]]]} Open Access 1 34912 Rotary Dog Park 32625 1670 Desert Hot Springs, City of 641 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 1670 Desert Hot Springs, City of 630 City 2 City Agency 2   Riverside 10 0.555 Rotary Dog Park 2017 Local Park 2 4
14959 14959 14958 {"type": "Polygon", "coordinates": [[[-116.51081, 33.96249], [-116.51064, 33.96265], [-116.51039, 33.96264], [-116.51038, 33.96261], [-116.51024, 33.96261], [-116.51024, 33.96232], [-116.51076, 33.96232], [-116.5108, 33.96236], [-116.51081, 33.96249]]]} Open Access 1 45567 Frank Hodge Skate Park 28395 1670 Desert Hot Springs, City of 641 City 2 City Agency 2 http://www.cityofdhs.org/ City 2 1670 Desert Hot Springs, City of 630 City 2 City Agency 2   Riverside 10 0.428 Frank Hodge Skate Park 0 Local Recreation Area 3 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]);