units_with_maps

Table actions

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

3 rows where AGNCY_NAME = 262 and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Park · 3 ✖

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
800 800 799 {"type": "Polygon", "coordinates": [[[-116.73692, 33.70731], [-116.73692, 33.70798], [-116.73675, 33.71539], [-116.73248, 33.71537], [-116.73258, 33.70742], [-116.73272, 33.70733], [-116.73692, 33.70731]]]} Open Access 1 5190 McCall Memorial Park 21990 2123 Riverside County Regional Park and Open Space District 262 Special District 4 Recreation/Parks District 4 http://www.riversidecountyparks.org/ Special District 4 2123 Riverside County Regional Park and Open Space District 258 Special District 4 Recreation/Parks District 4   Riverside 10 88.363 McCall Memorial Park 0 Local Park 2 4
12139 12139 12138 {"type": "Polygon", "coordinates": [[[-117.06136, 33.78295], [-117.05948, 33.78298], [-117.05934, 33.78716], [-117.05089, 33.78742], [-117.05152, 33.78022], [-117.05245, 33.78019], [-117.05246, 33.78027], [-117.0525, 33.78037], [-117.05261, 33.78051], [-117.05279, 33.78061], [-117.05299, 33.78066], [-117.05311, 33.78066], [-117.05324, 33.78063], [-117.05381, 33.78044], [-117.05395, 33.78045], [-117.05402, 33.7805], [-117.05408, 33.78058], [-117.05408, 33.78064], [-117.05404, 33.78083], [-117.05403, 33.78095], [-117.05406, 33.78108], [-117.05415, 33.78123], [-117.05425, 33.78133], [-117.05439, 33.78142], [-117.05454, 33.78147], [-117.05474, 33.78149], [-117.05491, 33.78147], [-117.0551, 33.78143], [-117.05598, 33.78117], [-117.05599, 33.781], [-117.05499, 33.78129], [-117.05476, 33.78132], [-117.0546, 33.78131], [-117.05442, 33.78123], [-117.05434, 33.78117], [-117.05427, 33.78108], [-117.05423, 33.78092], [-117.05424, 33.78083], [-117.05428, 33.78067], [-117.05427, 33.78055], [-117.0542, 33.78042], [-117.05409, 33.78033], [-117.05394, 33.78028], [-117.05377, 33.78028], [-117.05317, 33.78048], [-117.05298, 33.78049], [-117.05286, 33.78046], [-117.05276, 33.78039], [-117.05268, 33.7803], [-117.05265, 33.78019], [-117.05959, 33.77997], [-117.05959, 33.78013], [-117.06066, 33.7801], [-117.06071, 33.78014], [-117.06072, 33.78046], [-117.06057, 33.78122], [-117.06056, 33.78137], [-117.06058, 33.7815], [-117.06063, 33.78163], [-117.06072, 33.78183], [-117.06086, 33.78198], [-117.06095, 33.78204], [-117.06109, 33.78209], [-117.0612, 33.78211], [-117.06135, 33.78211], [-117.06136, 33.78295]]]} Open Access 1 25107 Maze Stone Park 21984 2123 Riverside County Regional Park and Open Space District 262 Special District 4 Recreation/Parks District 4 http://www.riversidecountyparks.org/ Special District 4 2123 Riverside County Regional Park and Open Space District 258 Special District 4 Recreation/Parks District 4   Riverside 10 158.229 Maze Stone Park 0 Local Park 2 4
16385 16385 16384 {"type": "Polygon", "coordinates": [[[-117.42159, 33.98048], [-117.42081, 33.98144], [-117.41987, 33.9818], [-117.41783, 33.98249], [-117.41783, 33.98251], [-117.41846, 33.98293], [-117.41668, 33.98402], [-117.4151, 33.98494], [-117.41511, 33.98495], [-117.41679, 33.98621], [-117.41677, 33.98622], [-117.41647, 33.98611], [-117.41616, 33.98602], [-117.41589, 33.98597], [-117.41561, 33.98594], [-117.41415, 33.98593], [-117.41401, 33.98606], [-117.4138, 33.98591], [-117.41345, 33.9859], [-117.41311, 33.98586], [-117.41278, 33.9858], [-117.41244, 33.98569], [-117.41217, 33.98558], [-117.41188, 33.98542], [-117.40831, 33.98323], [-117.40796, 33.98304], [-117.40754, 33.98284], [-117.40716, 33.98271], [-117.40677, 33.9826], [-117.40638, 33.98252], [-117.40581, 33.98246], [-117.40524, 33.98246], [-117.4046, 33.98253], [-117.40404, 33.98265], [-117.40351, 33.98283], [-117.40295, 33.98309], [-117.40268, 33.98325], [-117.40243, 33.98342], [-117.40202, 33.98376], [-117.40249, 33.98324], [-117.40324, 33.98249], [-117.40376, 33.98201], [-117.40431, 33.98155], [-117.40525, 33.98081], [-117.40543, 33.98095], [-117.40598, 33.98057], [-117.40598, 33.98055], [-117.40584, 33.98039], [-117.40712, 33.97953], [-117.40517, 33.97713], [-117.4044, 33.97762], [-117.40329, 33.97839], [-117.40257, 33.97893], [-117.40154, 33.97979], [-117.40088, 33.98038], [-117.39995, 33.9813], [-117.39801, 33.98342], [-117.40257, 33.97667], [-117.40275, 33.97634], [-117.40381, 33.97674], [-117.40711, 33.97636], [-117.40986, 33.97527], [-117.41045, 33.97568], [-117.41297, 33.97467], [-117.41986, 33.97931], [-117.41979, 33.97937], [-117.41979, 33.97939], [-117.42056, 33.97987], [-117.42099, 33.98007], [-117.42159, 33.98048]]]} Open Access 1 30003 Ranch Jurupa Regional Park 9395 2123 Riverside County Regional Park and Open Space District 262 Special District 4 Recreation/Parks District 4 http://www.riversidecountyparks.org/ Special District 4 2123 Riverside County Regional Park and Open Space District 258 Special District 4 Recreation/Parks District 4 http://www.rivcoparks.org/parks/rancho-jurupa/rancho-jurupa-park-home/ Riverside 10 309.352 Ranch Jurupa RP 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]);