superunits_with_maps

Table actions

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

42 rows where MNG_AGENCY = 63

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Corona, City of · 42 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
1396 1396 1395 {"type": "Polygon", "coordinates": [[[-117.58063, 33.90172], [-117.58031, 33.90181], [-117.57957, 33.90195], [-117.57948, 33.90164], [-117.57942, 33.90164], [-117.57931, 33.9014], [-117.57926, 33.90133], [-117.57932, 33.90128], [-117.57934, 33.9012], [-117.57948, 33.90119], [-117.5797, 33.90089], [-117.57996, 33.90104], [-117.58024, 33.90127], [-117.58051, 33.90157], [-117.58063, 33.90172]]]} Open Access 1 Aburndale Recreation Center   15241 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 2.025 Aburndale Rec. Ctr.  
1488 1488 1487 {"type": "Polygon", "coordinates": [[[-117.60541, 33.8572], [-117.60486, 33.85771], [-117.60375, 33.85686], [-117.6043, 33.85636], [-117.60447, 33.85647], [-117.60541, 33.8572]]]} Open Access 1 Border Tennis Courts   16281 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 2.633 Border Tennis Courts  
1489 1489 1488 {"type": "Polygon", "coordinates": [[[-117.60688, 33.85681], [-117.60632, 33.85768], [-117.60592, 33.85751], [-117.60571, 33.85789], [-117.60568, 33.85771], [-117.60539, 33.85751], [-117.60642, 33.85657], [-117.60688, 33.85681]]]} Open Access 1 Border Park   16280 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 2.097 Border Park  
1623 1623 1622 {"type": "Polygon", "coordinates": [[[-117.58127, 33.8523], [-117.58105, 33.85375], [-117.57845, 33.85277], [-117.57858, 33.85185], [-117.57868, 33.85158], [-117.57872, 33.85157], [-117.57878, 33.85138], [-117.58127, 33.8523]]]} Open Access 1 Buena Vista Neighborhood Park   16490 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 9.967 Buena Vista Neighborhood Park  
2188 2188 2187 {"type": "Polygon", "coordinates": [[[-117.54858, 33.84398], [-117.54832, 33.84393], [-117.54799, 33.84391], [-117.54751, 33.84394], [-117.54705, 33.84403], [-117.54682, 33.8441], [-117.54656, 33.84421], [-117.54621, 33.84441], [-117.54593, 33.84463], [-117.54574, 33.84481], [-117.54534, 33.84528], [-117.5451, 33.8455], [-117.54495, 33.84561], [-117.5449, 33.84561], [-117.54474, 33.84547], [-117.54461, 33.84539], [-117.54458, 33.84536], [-117.54418, 33.84513], [-117.54382, 33.84499], [-117.54323, 33.84479], [-117.54319, 33.84476], [-117.54319, 33.8447], [-117.54325, 33.8446], [-117.54482, 33.84227], [-117.54727, 33.8431], [-117.54729, 33.84318], [-117.54858, 33.84398]]]} Open Access 1 Citrus Community Park   17269 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 20.234 Citrus Community Park  
2229 2229 2228 {"type": "Polygon", "coordinates": [[[-117.60221, 33.86687], [-117.60182, 33.86723], [-117.60156, 33.86749], [-117.60079, 33.86818], [-117.60075, 33.86794], [-117.60069, 33.86782], [-117.59982, 33.86689], [-117.59977, 33.86682], [-117.59967, 33.86657], [-117.59954, 33.86639], [-117.59934, 33.86622], [-117.59908, 33.86608], [-117.59894, 33.86592], [-117.59888, 33.86579], [-117.59885, 33.86567], [-117.59885, 33.86552], [-117.5989, 33.8653], [-117.59892, 33.8651], [-117.59891, 33.86486], [-117.59884, 33.86457], [-117.59876, 33.86435], [-117.59882, 33.8643], [-117.60221, 33.86687]]]} Open Access 1 Brentwood Park   16357 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 13.042 Brentwood Park  
2435 2435 2434 {"type": "Polygon", "coordinates": [[[-117.60126, 33.89315], [-117.60065, 33.89369], [-117.60036, 33.89447], [-117.59431, 33.89419], [-117.59236, 33.89405], [-117.5912, 33.89388], [-117.59183, 33.89262], [-117.59319, 33.89311], [-117.59341, 33.8929], [-117.59693, 33.89225], [-117.59885, 33.89193], [-117.59981, 33.89174], [-117.60041, 33.89226], [-117.60108, 33.89302], [-117.60126, 33.89315]]]} Open Access 1 Butterfield Park   16607 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 43.437 Butterfield Park  
2862 2862 2861 {"type": "Polygon", "coordinates": [[[-117.54442, 33.83785], [-117.54392, 33.83867], [-117.54356, 33.8392], [-117.54238, 33.8388], [-117.54334, 33.83731], [-117.54442, 33.83785]]]} Open Access 1 Chase Neighborhood Park   17154 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 5.209 Chase Neighborhood Park  
3028 3028 3027 {"type": "Polygon", "coordinates": [[[-117.6095, 33.88962], [-117.6076, 33.89127], [-117.6075, 33.8913], [-117.60728, 33.8913], [-117.60713, 33.89124], [-117.60607, 33.8904], [-117.60678, 33.89012], [-117.60849, 33.88949], [-117.60898, 33.88928], [-117.60903, 33.88925], [-117.60907, 33.88926], [-117.6095, 33.88962]]]} Open Access 1 Clearwater Park   17416 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 7.81 Clearwater Park  
3172 3172 3171 {"type": "Polygon", "coordinates": [[[-117.57659, 33.88504], [-117.57652, 33.88547], [-117.57652, 33.88547], [-117.57638, 33.88542], [-117.57645, 33.88499], [-117.57659, 33.88504]]]} Open Access 1 Contreras Park   17609 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 0.162 Contreras Park  
3320 3320 3319 {"type": "Polygon", "coordinates": [[[-117.53678, 33.88883], [-117.53627, 33.89037], [-117.53499, 33.89006], [-117.53552, 33.88853], [-117.53678, 33.88883]]]} Open Access 1 Cresta Verde Park   17804 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 5.333 Cresta Verde Park  
3390 3390 3389 {"type": "Polygon", "coordinates": [[[-117.56115, 33.87058], [-117.56058, 33.87106], [-117.56017, 33.87147], [-117.56005, 33.87138], [-117.55953, 33.87063], [-117.55987, 33.8703], [-117.56005, 33.87015], [-117.56053, 33.86995], [-117.56115, 33.87058]]]} Open Access 1 Cypress Park   17876 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 3.276 Cypress Park  
3766 3766 3765 {"type": "Polygon", "coordinates": [[[-117.53403, 33.81452], [-117.53381, 33.81471], [-117.53285, 33.81636], [-117.53282, 33.81686], [-117.53209, 33.81689], [-117.53207, 33.81691], [-117.53166, 33.81689], [-117.53138, 33.81684], [-117.5312, 33.81679], [-117.53061, 33.81651], [-117.53073, 33.81636], [-117.53088, 33.81612], [-117.53106, 33.81571], [-117.53112, 33.81549], [-117.53118, 33.81518], [-117.5312, 33.81496], [-117.5312, 33.81465], [-117.53124, 33.81462], [-117.53374, 33.81438], [-117.53375, 33.81446], [-117.53381, 33.81452], [-117.53403, 33.81452]]]} Open Access 1 Eagle Glen Community Park   18338 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 13.492 Eagle Glen Community Park  
4155 4155 4154 {"type": "Polygon", "coordinates": [[[-117.58627, 33.90811], [-117.58528, 33.90901], [-117.58385, 33.90792], [-117.58354, 33.90818], [-117.5835, 33.90816], [-117.58331, 33.90801], [-117.58316, 33.90784], [-117.5829, 33.90754], [-117.58289, 33.90749], [-117.58297, 33.90754], [-117.58312, 33.90759], [-117.58324, 33.90761], [-117.5834, 33.90761], [-117.58342, 33.90763], [-117.58365, 33.90757], [-117.58376, 33.90752], [-117.58409, 33.90744], [-117.58489, 33.90781], [-117.58627, 33.90811]]]} Open Access 1 Fairview Park   18816 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 5.218 Fairview Park  
4419 4419 4418 {"type": "Polygon", "coordinates": [[[-117.6439, 33.87882], [-117.64373, 33.87913], [-117.64378, 33.8793], [-117.64325, 33.8791], [-117.64291, 33.87813], [-117.64282, 33.87707], [-117.64245, 33.87672], [-117.64226, 33.87545], [-117.64241, 33.87503], [-117.6425, 33.87503], [-117.6428, 33.87538], [-117.64305, 33.87624], [-117.64304, 33.87702], [-117.6435, 33.87842], [-117.64387, 33.8787], [-117.6439, 33.87882]]]} Open Access 1 Fresno Park   19112 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 5.325 Fresno Park  
4512 4512 4511 {"type": "Polygon", "coordinates": [[[-117.56206, 33.8703], [-117.562, 33.87064], [-117.56159, 33.87059], [-117.56181, 33.87043], [-117.56206, 33.8703]]]} Open Access 1 Joy Park   20509 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 0.192 Joy Park  
4757 4757 4756 {"type": "Polygon", "coordinates": [[[-117.50924, 33.89166], [-117.50914, 33.89183], [-117.50907, 33.89201], [-117.50905, 33.89215], [-117.50906, 33.89225], [-117.50902, 33.89272], [-117.50894, 33.89315], [-117.50884, 33.89338], [-117.50868, 33.89365], [-117.50843, 33.89393], [-117.50831, 33.89405], [-117.50801, 33.89426], [-117.50785, 33.89435], [-117.50747, 33.89389], [-117.50692, 33.89317], [-117.50664, 33.89331], [-117.50658, 33.89323], [-117.50684, 33.89305], [-117.50628, 33.89215], [-117.50657, 33.89202], [-117.50718, 33.89212], [-117.50799, 33.89137], [-117.50844, 33.89133], [-117.50873, 33.89117], [-117.50894, 33.89126], [-117.50881, 33.8916], [-117.50924, 33.89166]]]} Open Access 1 Griffin Park   19514 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 13.03 Griffin Park  
5057 5057 5056 {"type": "Polygon", "coordinates": [[[-117.57751, 33.84415], [-117.57745, 33.84458], [-117.57741, 33.84466], [-117.57731, 33.84478], [-117.57728, 33.84484], [-117.57731, 33.84492], [-117.57738, 33.84498], [-117.57734, 33.8453], [-117.57585, 33.84516], [-117.57613, 33.84334], [-117.57618, 33.84334], [-117.57617, 33.84345], [-117.57612, 33.84363], [-117.57612, 33.84368], [-117.57618, 33.84378], [-117.57626, 33.84383], [-117.57623, 33.84413], [-117.57666, 33.84413], [-117.5769, 33.8441], [-117.57751, 33.84415]]]} Open Access 1 Heritage Park   19846 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 4.404 Heritage Park  
5309 5309 5308 {"type": "Polygon", "coordinates": [[[-117.57342, 33.86906], [-117.57322, 33.87045], [-117.57284, 33.87041], [-117.57283, 33.87039], [-117.57278, 33.8704], [-117.57229, 33.87035], [-117.5725, 33.86899], [-117.57299, 33.86904], [-117.57299, 33.86906], [-117.57302, 33.86907], [-117.57305, 33.86902], [-117.57342, 33.86906]]]} Open Access 1 Husted Park   20160 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 3.286 Husted Park  
5464 5464 5463 {"type": "Polygon", "coordinates": [[[-117.55597, 33.83411], [-117.55531, 33.83547], [-117.55479, 33.83646], [-117.55375, 33.83618], [-117.55329, 33.83601], [-117.55276, 33.83579], [-117.55424, 33.83354], [-117.55458, 33.83373], [-117.55476, 33.83382], [-117.55496, 33.83389], [-117.55532, 33.834], [-117.55597, 33.83411]]]} Open Access 1 Jameson Park   20356 1068 Corona, City of 63 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 13.039 Jameson Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);