units_with_maps

Table actions

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

13 rows where COUNTY = 3, MNG_AGENCY = 237 and YR_EST = 0

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Placentia, City of · 13 ✖

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
692 692 691 {"type": "Polygon", "coordinates": [[[-117.8743, 33.86075], [-117.87227, 33.86127], [-117.87212, 33.8609], [-117.87363, 33.85985], [-117.87381, 33.85974], [-117.87399, 33.86023], [-117.8741, 33.86022], [-117.8743, 33.86075]]]} Open Access 1 5213 McFadden Park 22030 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 3.975 McFadden Park 0 Local Park 2 4
1462 1462 1461 {"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.86496, 33.88897], [-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.86409, 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 9871 Bradford Park 16324 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 1.759 Bradford Park 0 Local Park 2 4
1548 1548 1547 {"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.86924], [-117.8771, 33.86924], [-117.87712, 33.86926], [-117.87742, 33.86933]]]} Open Access 1 11534 Santa Fe Park 25088 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 0.938 Santa Fe Park 0 Local Park 2 4
2516 2516 2515 {"type": "Polygon", "coordinates": [[[-117.86891, 33.90185], [-117.86741, 33.90185], [-117.8674, 33.90018], [-117.8679, 33.90018], [-117.86791, 33.90004], [-117.86887, 33.90003], [-117.86891, 33.90185]]]} Open Access 1 20028 Tuffree Hill Park 26560 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 6.627 Tuffree Hill Park 0 Local Park 2 4
2806 2806 2805 {"type": "Polygon", "coordinates": [[[-117.8549, 33.90262], [-117.85489, 33.90263], [-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.85392, 33.90293], [-117.85281, 33.90294], [-117.8528, 33.90275], [-117.85194, 33.90278], [-117.85194, 33.90283], [-117.85131, 33.90283], [-117.85131, 33.90249], [-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 940 George J. Koch Park 19268 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 10.057 George J. Koch Park 0 Local Park 2 4
4847 4847 4846 {"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.87945], [-117.85977, 33.87954], [-117.85919, 33.87936], [-117.85962, 33.87845], [-117.8607, 33.87881], [-117.86067, 33.87888], [-117.86078, 33.8789]]]} Open Access 1 1103 Goldenrod Park 19377 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 2.658 Goldenrod Park 0 Local Park 2 4
5273 5273 5272 {"type": "Polygon", "coordinates": [[[-117.87737, 33.85948], [-117.87731, 33.85953], [-117.87727, 33.85959], [-117.87726, 33.85965], [-117.87728, 33.8597], [-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 47392 Jaycee Parkette 31116 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 0.062 Jaycee Parkette 0 Local Park 2 4
6540 6540 6539 {"type": "Polygon", "coordinates": [[[-117.87354, 33.8729], [-117.87331, 33.87372], [-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.87133, 33.87304], [-117.87138, 33.87289], [-117.87217, 33.87304], [-117.87229, 33.87266], [-117.87354, 33.8729]]]} Open Access 1 2985 Kraemer Memorial Park 20722 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 11.472 Kraemer Memorial Park 0 Local Park 2 4
7886 7886 7885 {"type": "Polygon", "coordinates": [[[-117.85737, 33.874], [-117.85725, 33.87448], [-117.85717, 33.87448], [-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 9888 Richard Samp Park 24325 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 3.203 Richard Samp Park 0 Local Park 2 4
8979 8979 8978 {"type": "Polygon", "coordinates": [[[-117.86807, 33.90551], [-117.86382, 33.90555], [-117.86382, 33.90386], [-117.86465, 33.90383], [-117.86468, 33.90372], [-117.86479, 33.90362], [-117.86432, 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 14821 Tri-City Park 26527 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 38.531 Tri-City Park 0 Local Park 2 4
9129 9129 9128 {"type": "Polygon", "coordinates": [[[-117.85306, 33.89297], [-117.85306, 33.89319], [-117.85302, 33.89324], [-117.85128, 33.89326], [-117.85108, 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]]]} Open Access 1 15138 Wagner Park 27209 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 2.343 Wagner Park 0 Local Park 2 4
12870 12870 12869 {"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.8759], [-117.83959, 33.8759], [-117.8396, 33.87693]]]} Open Access 1 30314 Placentia Champions Sports Complex 23761 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2   Orange 3 12.979 Placentia Champions Sports Complex 0 Local Recreation Area 3 4
14973 14973 14972 {"type": "Polygon", "coordinates": [[[-117.87572, 33.8582], [-117.87537, 33.85828], [-117.87529, 33.85805], [-117.87534, 33.85804], [-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.85793], [-117.87467, 33.85787], [-117.87546, 33.85769], [-117.87557, 33.85771], [-117.87572, 33.8582]]]} Open Access 1 45589 La Placita Parkette 28415 1255 Placentia, City of 241 City 2 City Agency 2 http://www.placentia.org/ City 2 1255 Placentia, City of 237 City 2 City Agency 2 http://www.placentia.org/facilities/Facility/Details/31 Orange 3 0.744 La Placita Parkette 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]);