units_with_maps

Table actions

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

16 rows where AGNCY_NAME = 114, MNG_AGENCY = 111 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 16 ✖

MNG_AGENCY 1

  • Norco, City of · 16 ✖

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
277 277 276 {"type": "Polygon", "coordinates": [[[-117.5615, 33.93786], [-117.56124, 33.93819], [-117.56111, 33.93847], [-117.56107, 33.93871], [-117.56106, 33.93932], [-117.55877, 33.93932], [-117.55877, 33.93876], [-117.55864, 33.93875], [-117.55864, 33.9379], [-117.55991, 33.93791], [-117.55992, 33.93787], [-117.5615, 33.93786]]]} Open Access 1 47359 Community Center Park 31082 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://www.norco.ca.us/depts/parks/facilities/parks/communitycenter.asp Riverside 10 8.953 Community Ctr. Park 0 Local Recreation Area 3 4
2184 2184 2183 {"type": "Polygon", "coordinates": [[[-117.55805, 33.94196], [-117.55713, 33.94196], [-117.55713, 33.94109], [-117.558, 33.94108], [-117.55805, 33.94196]]]} Open Access 1 17784 Clark Field 17386 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.993 Clark Field 0 Local Recreation Area 3 4
2804 2804 2803 {"type": "Polygon", "coordinates": [[[-117.53379, 33.9259], [-117.53312, 33.92591], [-117.53313, 33.92683], [-117.53242, 33.92684], [-117.53239, 33.92687], [-117.53234, 33.92681], [-117.53223, 33.92658], [-117.53218, 33.92639], [-117.53209, 33.92639], [-117.53184, 33.92645], [-117.53182, 33.9264], [-117.532, 33.92637], [-117.53213, 33.92633], [-117.53221, 33.92621], [-117.53224, 33.92612], [-117.53228, 33.92603], [-117.53241, 33.92588], [-117.53241, 33.92578], [-117.53243, 33.92572], [-117.53255, 33.92559], [-117.53271, 33.92553], [-117.53277, 33.92553], [-117.53304, 33.92564], [-117.53305, 33.9258], [-117.53379, 33.92579], [-117.53379, 33.9259]]]} Open Access 1 47394 The Basin 31118 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://www.norco.ca.us/depts/parks/facilities/parks/basin.asp Riverside 10 2.811 The Basin   None 232  
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
6065 6065 6064 {"type": "Polygon", "coordinates": [[[-117.52357, 33.93359], [-117.52356, 33.93837], [-117.52151, 33.93837], [-117.52126, 33.93832], [-117.52105, 33.93823], [-117.52094, 33.93816], [-117.52084, 33.93806], [-117.52073, 33.93788], [-117.52068, 33.93766], [-117.52068, 33.93753], [-117.52066, 33.9374], [-117.5206, 33.93725], [-117.52048, 33.93709], [-117.52049, 33.93698], [-117.52037, 33.93696], [-117.51987, 33.93646], [-117.52187, 33.93357], [-117.52188, 33.93358], [-117.52357, 33.93359]], [[-117.52353, 33.93733], [-117.52348, 33.93731], [-117.52345, 33.93728], [-117.52329, 33.93727], [-117.52328, 33.93737], [-117.52352, 33.93741], [-117.52353, 33.93733]]]} Open Access 1 47360 George Ingalls Equestrian Event Center 31083 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://www.norco.ca.us/depts/parks/facilities/parks/ingalls.asp Riverside 10 34.063 George Ingalls Equestrian Event Ctr. 0 Local Recreation Area 3 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
14107 14107 14106 {"type": "Polygon", "coordinates": [[[-117.52281, 33.94005], [-117.52068, 33.94006], [-117.52067, 33.93881], [-117.5207, 33.93866], [-117.52077, 33.93853], [-117.52281, 33.93853], [-117.52281, 33.94005]]]} Open Access 1 39188 Pikes Peak park 23667 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 8.233 Pikes Peak park   None 1204  
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]);