units_with_maps

Table actions

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

11 rows where COUNTY = 10, DES_TP = 2 and MNG_AGENCY = 111

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Norco, City of · 11 ✖

DES_TP 1

  • Local Park · 11 ✖

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
2987 2987 2986 {"type": "Polygon", "coordinates": [[[-117.57957, 33.91794], [-117.57954, 33.91868], [-117.57869, 33.91868], [-117.57869, 33.91804], [-117.57887, 33.91791], [-117.57901, 33.91776], [-117.57904, 33.91774], [-117.57908, 33.91774], [-117.57957, 33.91794]]]} Open Access 1 19853 Pacer Park 23290 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 1.81 Pacer Park 0 Local Park 2 4
3949 3949 3948 {"type": "Polygon", "coordinates": [[[-117.55804, 33.95506], [-117.55383, 33.95686], [-117.55383, 33.95718], [-117.54956, 33.95724], [-117.54958, 33.95672], [-117.54972, 33.95606], [-117.54998, 33.95533], [-117.55028, 33.95456], [-117.55059, 33.95387], [-117.55111, 33.95285], [-117.55167, 33.95202], [-117.55193, 33.95167], [-117.55217, 33.95146], [-117.55281, 33.95103], [-117.55304, 33.95085], [-117.55325, 33.95063], [-117.55343, 33.95039], [-117.55356, 33.95016], [-117.55371, 33.95016], [-117.55372, 33.94999], [-117.5559, 33.94996], [-117.5559, 33.94815], [-117.55799, 33.94815], [-117.55795, 33.94909], [-117.55796, 33.95169], [-117.55804, 33.95506]]]} Open Access 1 47426 Silverlakes Park 31143 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2 http://silverlakespark.com/ Riverside 10 123.732 Silverlakes Park 0 Local Park 2 4
5216 5216 5215 {"type": "Polygon", "coordinates": [[[-117.58908, 33.91975], [-117.58908, 33.91975], [-117.58848, 33.92029], [-117.58833, 33.91958], [-117.58856, 33.91936], [-117.58908, 33.91975]]]} Open Access 1 19852 Sundance Park 25988 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 0.891 Sundance Park 0 Local Park 2 4
6697 6697 6696 {"type": "Polygon", "coordinates": [[[-117.57934, 33.9283], [-117.57931, 33.92864], [-117.57932, 33.92971], [-117.57929, 33.92995], [-117.57923, 33.93017], [-117.57918, 33.9303], [-117.57908, 33.93047], [-117.57892, 33.93067], [-117.57852, 33.93108], [-117.57798, 33.93108], [-117.57797, 33.93107], [-117.57667, 33.93109], [-117.57666, 33.92704], [-117.578, 33.92701], [-117.578, 33.92753], [-117.57865, 33.92801], [-117.57919, 33.92828], [-117.57934, 33.9283]]]} Open Access 1 4977 Wayne Makin Park 27322 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 23.137 Wayne Makin Park 0 Local Park 2 4
6941 6941 6940 {"type": "Polygon", "coordinates": [[[-117.56288, 33.93152], [-117.56288, 33.9323], [-117.55781, 33.9323], [-117.55797, 33.93125], [-117.5615, 33.93124], [-117.56196, 33.9313], [-117.56288, 33.93152]]]} Open Access 1 5842 Neil Snipes Park 22688 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 12.899 Neil Snipes Park 0 Local Park 2 4
7724 7724 7723 {"type": "Polygon", "coordinates": [[[-117.54835, 33.92287], [-117.5476, 33.92282], [-117.54731, 33.92303], [-117.54724, 33.92331], [-117.54672, 33.92277], [-117.5462, 33.9221], [-117.5472, 33.9217], [-117.5477, 33.92212], [-117.54835, 33.92287]]]} Open Access 1 7963 Parmenter Park 23470 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 3.997 Parmenter Park 0 Local Park 2 4
8933 8933 8932 {"type": "Polygon", "coordinates": [[[-117.58943, 33.92238], [-117.5882, 33.9224], [-117.5882, 33.92215], [-117.58814, 33.92214], [-117.58808, 33.92203], [-117.58883, 33.9217], [-117.58943, 33.92238]]]} Open Access 1 14680 Ted Brooks Park 26211 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 1.443 Ted Brooks Park 0 Local Park 2 4
14108 14108 14107 {"type": "Polygon", "coordinates": [[[-117.54569, 33.90209], [-117.54445, 33.90209], [-117.54445, 33.90174], [-117.54434, 33.90165], [-117.54437, 33.90159], [-117.54453, 33.90165], [-117.54522, 33.90169], [-117.54556, 33.90179], [-117.54565, 33.90193], [-117.54569, 33.90209]]]} Open Access 1 39189 Norco Hills Park 22787 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 1.231 Norco Hills Park 0 Local Park 2 4
14109 14109 14108 {"type": "Polygon", "coordinates": [[[-117.52809, 33.93125], [-117.528, 33.93143], [-117.52794, 33.93163], [-117.52794, 33.93222], [-117.5279, 33.93225], [-117.52763, 33.93226], [-117.52763, 33.93173], [-117.52734, 33.93172], [-117.52734, 33.93126], [-117.52809, 33.93125]]]} Open Access 1 39190 Hawks Crest Park 19749 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 1.194 Hawks Crest Park 0 Local Park 2 4
14110 14110 14109 {"type": "Polygon", "coordinates": [[[-117.53259, 33.92547], [-117.53229, 33.92572], [-117.53218, 33.92582], [-117.53208, 33.92624], [-117.53199, 33.9263], [-117.53178, 33.92636], [-117.53172, 33.92633], [-117.53165, 33.92633], [-117.53163, 33.92548], [-117.53259, 33.92547]]]} Open Access 1 39191 Ridge Ranch Park 24349 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 1.254 Ridge Ranch Park 0 Local Park 2 4
14642 14642 14641 {"type": "Polygon", "coordinates": [[[-117.58128, 33.91188], [-117.58118, 33.912], [-117.58105, 33.9121], [-117.58069, 33.91233], [-117.58062, 33.91233], [-117.58002, 33.91165], [-117.58058, 33.9113], [-117.58128, 33.91188]]]} Open Access 1 44889 Kips Korner Park 20676 1395 Norco, City of 114 City 2 City Agency 2 http://www.norco.ca.us/depts/parks/default.asp City 2 1395 Norco, City of 111 City 2 City Agency 2   Riverside 10 1.721 Kips Korner 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]);