superunits_with_maps

Table actions

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

16 rows where MNG_AGENCY = 237

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Placentia, City of · 16 ✖

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
2199 2199 2198 {"type": "Polygon", "coordinates": [[[-117.86544, 33.88892], [-117.86537, 33.88914], [-117.86535, 33.88913], [-117.86533, 33.88915], [-117.86529, 33.88916], [-117.86511, 33.8891], [-117.865, 33.88899], [-117.86487, 33.88897], [-117.8648, 33.88901], [-117.86473, 33.88907], [-117.86476, 33.88918], [-117.86472, 33.88919], [-117.86425, 33.88905], [-117.86418, 33.889], [-117.86408, 33.889], [-117.86365, 33.88886], [-117.86366, 33.88853], [-117.86455, 33.88852], [-117.8647, 33.88856], [-117.86474, 33.88858], [-117.86478, 33.88871], [-117.86487, 33.8888], [-117.86544, 33.88892]]]} Open Access 1 Bradford Park   16324 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 1.762 Bradford Park  
4543 4543 4542 {"type": "Polygon", "coordinates": [[[-117.8549, 33.90262], [-117.85489, 33.90264], [-117.85489, 33.90365], [-117.85488, 33.90368], [-117.85485, 33.9037], [-117.8548, 33.90371], [-117.85408, 33.90372], [-117.85407, 33.90354], [-117.85392, 33.90352], [-117.85391, 33.90293], [-117.85281, 33.90294], [-117.85279, 33.90275], [-117.85195, 33.90278], [-117.85194, 33.90283], [-117.85131, 33.90283], [-117.85131, 33.9025], [-117.85107, 33.90249], [-117.85107, 33.9022], [-117.85067, 33.90219], [-117.85067, 33.90204], [-117.85489, 33.902], [-117.8549, 33.90262]]]} Open Access 1 George J. Koch Park   19268 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 10.071 George J. Koch Park  
4644 4644 4643 {"type": "Polygon", "coordinates": [[[-117.86078, 33.8789], [-117.8606, 33.87928], [-117.86047, 33.87925], [-117.86035, 33.8795], [-117.86009, 33.87938], [-117.85998, 33.87937], [-117.85989, 33.8794], [-117.85983, 33.87944], [-117.85977, 33.87954], [-117.85919, 33.87936], [-117.85962, 33.87845], [-117.8607, 33.87881], [-117.86068, 33.87888], [-117.86078, 33.8789]]]} Open Access 1 Goldenrod Park   19377 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 2.66 Goldenrod Park  
5778 5778 5777 {"type": "Polygon", "coordinates": [[[-117.87354, 33.8729], [-117.87331, 33.87371], [-117.87338, 33.87375], [-117.87314, 33.87459], [-117.87001, 33.87397], [-117.8703, 33.87293], [-117.87074, 33.87302], [-117.87078, 33.87293], [-117.87132, 33.87303], [-117.87138, 33.87289], [-117.87217, 33.87304], [-117.87229, 33.87266], [-117.87354, 33.8729]]]} Open Access 1 Kraemer Memorial Park   20722 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 11.478 Kraemer Memorial Park  
6830 6830 6829 {"type": "Polygon", "coordinates": [[[-117.8743, 33.86075], [-117.87227, 33.86127], [-117.87212, 33.8609], [-117.87363, 33.85985], [-117.87381, 33.85974], [-117.87398, 33.86023], [-117.8741, 33.86022], [-117.8743, 33.86075]]]} Open Access 1 McFadden Park   22030 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 3.976 McFadden Park  
7986 7986 7985 {"type": "MultiPolygon", "coordinates": [[[[-117.82839, 33.86663], [-117.82839, 33.86673], [-117.82832, 33.86675], [-117.82833, 33.86745], [-117.82612, 33.86721], [-117.82611, 33.86658], [-117.82754, 33.86672], [-117.828, 33.8667], [-117.82839, 33.86663]]], [[[-117.82839, 33.86643], [-117.82805, 33.8665], [-117.82797, 33.86651], [-117.82799, 33.86633], [-117.82817, 33.86636], [-117.82838, 33.86637], [-117.82839, 33.86643]]]]} Open Access 1 Parque de Los Ninos   23474 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 3.87 Parque de Los Ninos  
7988 7988 7987 {"type": "Polygon", "coordinates": [[[-117.83548, 33.88305], [-117.83543, 33.88311], [-117.83528, 33.88367], [-117.83528, 33.88412], [-117.83494, 33.88413], [-117.83476, 33.88485], [-117.83469, 33.88523], [-117.83453, 33.88556], [-117.8339, 33.88557], [-117.83386, 33.88421], [-117.83394, 33.88419], [-117.83392, 33.88275], [-117.83543, 33.88274], [-117.83543, 33.88301], [-117.83548, 33.88305]]]} Open Access 1 Parque De Los Vaqueros   23476 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 8.191 Parque De Los Vaqueros  
7990 7990 7989 {"type": "Polygon", "coordinates": [[[-117.84731, 33.88348], [-117.84722, 33.88366], [-117.84704, 33.88393], [-117.84684, 33.88414], [-117.84638, 33.88454], [-117.84623, 33.88473], [-117.84617, 33.88484], [-117.84611, 33.88499], [-117.84606, 33.88524], [-117.84606, 33.88537], [-117.8461, 33.88585], [-117.84551, 33.88585], [-117.84546, 33.88529], [-117.84548, 33.88506], [-117.84554, 33.88485], [-117.8456, 33.8847], [-117.84577, 33.88443], [-117.84592, 33.88425], [-117.84642, 33.8838], [-117.84668, 33.88377], [-117.84682, 33.88345], [-117.84682, 33.88331], [-117.84731, 33.88348]]]} Open Access 1 Parque del Arroyo Verde   23478 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 3.98 Parque del Arroyo Verde  
8218 8218 8217 {"type": "Polygon", "coordinates": [[[-117.8396, 33.87693], [-117.83858, 33.87693], [-117.83858, 33.87723], [-117.83827, 33.87736], [-117.83782, 33.87737], [-117.83744, 33.87727], [-117.83736, 33.87725], [-117.83733, 33.87722], [-117.83732, 33.87425], [-117.83741, 33.87418], [-117.8381, 33.87419], [-117.83846, 33.8742], [-117.83865, 33.87424], [-117.83868, 33.87589], [-117.83959, 33.8759], [-117.8396, 33.87693]]]} Open Access 1 Placentia Champions Sports Complex   23761 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 12.987 Placentia Champions Sports Complex  
8667 8667 8666 {"type": "Polygon", "coordinates": [[[-117.85737, 33.874], [-117.85725, 33.87448], [-117.85717, 33.87449], [-117.85718, 33.87474], [-117.85713, 33.87494], [-117.8558, 33.87489], [-117.85582, 33.87483], [-117.85579, 33.87478], [-117.85583, 33.87453], [-117.8559, 33.87452], [-117.85606, 33.87395], [-117.85737, 33.874]]]} Open Access 1 Richard Samp Park   24325 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 3.204 Richard Samp Park  
9318 9318 9317 {"type": "Polygon", "coordinates": [[[-117.87742, 33.86933], [-117.87731, 33.86971], [-117.87694, 33.86967], [-117.87676, 33.86967], [-117.87647, 33.8697], [-117.87663, 33.86917], [-117.87695, 33.86923], [-117.87697, 33.86921], [-117.87702, 33.86923], [-117.8771, 33.86924], [-117.87712, 33.86927], [-117.87742, 33.86933]]]} Open Access 1 Santa Fe Park   25088 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 0.938 Santa Fe Park  
10457 10457 10456 {"type": "Polygon", "coordinates": [[[-117.86807, 33.90551], [-117.86382, 33.90555], [-117.86382, 33.90386], [-117.86465, 33.90383], [-117.86468, 33.90372], [-117.86477, 33.90363], [-117.86433, 33.90361], [-117.86431, 33.90364], [-117.86388, 33.90364], [-117.86386, 33.9019], [-117.86803, 33.90185], [-117.86805, 33.90359], [-117.86802, 33.90363], [-117.86805, 33.9037], [-117.86807, 33.90551]]]} Open Access 1 Tri-City Park   26527 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 38.535 Tri-City Park  
10476 10476 10475 {"type": "Polygon", "coordinates": [[[-117.86891, 33.90185], [-117.86741, 33.90185], [-117.8674, 33.90018], [-117.86789, 33.90018], [-117.86791, 33.90004], [-117.86887, 33.90003], [-117.86891, 33.90185]]]} Open Access 1 Tuffree Hill Park   26560 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 6.627 Tuffree Hill Park  
10979 10979 10978 {"type": "Polygon", "coordinates": [[[-117.85306, 33.89319], [-117.85302, 33.89324], [-117.85128, 33.89326], [-117.85107, 33.89328], [-117.85075, 33.89337], [-117.85056, 33.89338], [-117.85055, 33.89262], [-117.85069, 33.89274], [-117.85136, 33.89285], [-117.8517, 33.89298], [-117.85306, 33.89297], [-117.85306, 33.89319]]]} Open Access 1 Wagner Park   27209 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 2.343 Wagner Park  
11792 11792 11791 {"type": "Polygon", "coordinates": [[[-117.87572, 33.8582], [-117.87537, 33.85828], [-117.87529, 33.85805], [-117.87534, 33.85803], [-117.87532, 33.85794], [-117.87526, 33.85786], [-117.87513, 33.85782], [-117.87508, 33.85784], [-117.875, 33.85792], [-117.87491, 33.85799], [-117.87455, 33.85807], [-117.87449, 33.85805], [-117.87448, 33.85802], [-117.8745, 33.85796], [-117.87453, 33.85794], [-117.87467, 33.85787], [-117.87546, 33.85769], [-117.87557, 33.85771], [-117.87572, 33.8582]]]} Open Access 1 La Placita Parkette http://www.placentia.org/facilities/Facility/Details/31 28415 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 0.745 La Placita Parkette  
13641 13641 13640 {"type": "Polygon", "coordinates": [[[-117.87737, 33.85948], [-117.87731, 33.85953], [-117.87727, 33.85959], [-117.87727, 33.85965], [-117.87728, 33.85969], [-117.87732, 33.85969], [-117.87729, 33.85973], [-117.87729, 33.85975], [-117.87728, 33.85976], [-117.87714, 33.85945], [-117.87737, 33.85948]]]} Open Access 1 Jaycee Parkette   31116 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/ City 2 0.062 Jaycee Parkette  

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]);