units_with_maps

Table actions

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

7 rows where ACCESS_TYP = 1, AGNCY_NAME = 189 and DES_TP = 3

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 7 ✖
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
2926 2926 2925 {"type": "Polygon", "coordinates": [[[-117.44729, 33.93129], [-117.44564, 33.93223], [-117.44557, 33.93222], [-117.44446, 33.93087], [-117.44445, 33.93083], [-117.44448, 33.9308], [-117.44622, 33.92979], [-117.44646, 33.93007], [-117.44651, 33.93028], [-117.44658, 33.93041], [-117.44729, 33.93129]]]} Open Access 1 19857 Don Lorenzi Sports Park 18207 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 9.204 Don Lorenzi Sports Park 0 Local Recreation Area 3 4
3188 3188 3187 {"type": "Polygon", "coordinates": [[[-117.33536, 33.9812], [-117.33535, 33.98219], [-117.33523, 33.98258], [-117.33522, 33.98284], [-117.33513, 33.9829], [-117.33282, 33.98289], [-117.33281, 33.98294], [-117.33261, 33.98294], [-117.33261, 33.98289], [-117.33248, 33.98289], [-117.33246, 33.98294], [-117.33221, 33.98294], [-117.3322, 33.98289], [-117.33128, 33.98289], [-117.33124, 33.98286], [-117.33125, 33.98119], [-117.33284, 33.9812], [-117.33536, 33.9812]]]} Open Access 1 22126 Riverside Sports Center 24460 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 17.499 Riverside Sports Ctr. 0 Local Recreation Area 3 4
5463 5463 5462 {"type": "Polygon", "coordinates": [[[-117.35709, 33.97285], [-117.35709, 33.97395], [-117.356, 33.97398], [-117.35595, 33.97467], [-117.35505, 33.97466], [-117.35504, 33.97285], [-117.35709, 33.97285]]]} Open Access 1 6271 Bobby Bonds Park and Sports Complex 16213 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 7.442 Bobby Bonds Park and Sports Complex 0 Local Recreation Area 3 4
9396 9396 9395 {"type": "Polygon", "coordinates": [[[-117.44487, 33.92816], [-117.44309, 33.92917], [-117.44256, 33.92851], [-117.44257, 33.92847], [-117.44432, 33.92748], [-117.44487, 33.92816]]]} Open Access 1 18711 Don Lorenzi Sports Center 18206 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 4.492 Don Lorenzi Sports Ctr. 0 Local Recreation Area 3 4
10703 10703 10702 {"type": "MultiPolygon", "coordinates": [[[[-117.45748, 33.93032], [-117.45696, 33.93055], [-117.45685, 33.9303], [-117.45635, 33.9303], [-117.45634, 33.92971], [-117.45667, 33.92988], [-117.45692, 33.92988], [-117.45719, 33.92984], [-117.45748, 33.93032]]], [[[-117.46005, 33.93408], [-117.45945, 33.93387], [-117.45903, 33.93388], [-117.45891, 33.93342], [-117.45839, 33.93258], [-117.45813, 33.93269], [-117.45809, 33.93262], [-117.45833, 33.9325], [-117.45785, 33.93171], [-117.45762, 33.93157], [-117.45742, 33.93157], [-117.45754, 33.93125], [-117.45743, 33.93101], [-117.45709, 33.93091], [-117.45701, 33.93071], [-117.45758, 33.93047], [-117.45766, 33.93059], [-117.45798, 33.93077], [-117.45806, 33.93088], [-117.45868, 33.93185], [-117.45891, 33.93175], [-117.45898, 33.93186], [-117.45875, 33.93198], [-117.4592, 33.93271], [-117.45924, 33.93286], [-117.45933, 33.93298], [-117.45956, 33.93287], [-117.45967, 33.93295], [-117.45957, 33.93316], [-117.4598, 33.93348], [-117.45976, 33.93354], [-117.45977, 33.93361], [-117.4598, 33.93366], [-117.45989, 33.93372], [-117.45993, 33.93376], [-117.46002, 33.93393], [-117.46005, 33.93408]]]]} Open Access 1 19859 El Dorado Open Space Park 18503 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 8.427 El Dorado OS Park 0 Local Recreation Area 3 4
14846 14846 14845 {"type": "Polygon", "coordinates": [[[-117.4311, 33.90173], [-117.43346, 33.90466], [-117.43347, 33.90469], [-117.43345, 33.90471], [-117.43013, 33.90662], [-117.43009, 33.90663], [-117.43006, 33.90661], [-117.42888, 33.90516], [-117.42945, 33.90482], [-117.42825, 33.90334], [-117.4311, 33.90173]]]} Open Access 1 45361 Arlington Heights Sports Park Picnic Area 15588 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 34.333 Arlington Heights Sports Park Picnic Area 0 Local Recreation Area 3 4
16184 16184 16183 {"type": "Polygon", "coordinates": [[[-117.31978, 33.96039], [-117.31974, 33.9609], [-117.31968, 33.96095], [-117.31927, 33.96088], [-117.31898, 33.96081], [-117.3189, 33.96076], [-117.31846, 33.96064], [-117.31744, 33.96024], [-117.31672, 33.96039], [-117.31629, 33.96031], [-117.31548, 33.9604], [-117.315, 33.96042], [-117.3143, 33.96034], [-117.31376, 33.9604], [-117.31372, 33.96037], [-117.31375, 33.95792], [-117.31407, 33.95785], [-117.31439, 33.95776], [-117.31494, 33.95755], [-117.31525, 33.95797], [-117.3168, 33.958], [-117.31679, 33.9592], [-117.31861, 33.95961], [-117.31924, 33.95929], [-117.31926, 33.95944], [-117.31931, 33.95957], [-117.31939, 33.95969], [-117.31957, 33.95987], [-117.31969, 33.96005], [-117.31975, 33.96017], [-117.31978, 33.96039]]]} Open Access 1 25075 Quail Run Open Space 24052 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 27.591 Quail Run OS 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]);