superunits_with_maps

Table actions

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

22 rows where MNG_AGENCY = 199

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • La Habra, City of · 22 ✖

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
1096 1096 1095 {"type": "Polygon", "coordinates": [[[-117.94602, 33.92979], [-117.94596, 33.92982], [-117.94483, 33.92983], [-117.94483, 33.92951], [-117.94482, 33.92949], [-117.94482, 33.92941], [-117.94515, 33.92941], [-117.94536, 33.92938], [-117.94555, 33.92938], [-117.94556, 33.92932], [-117.94564, 33.92931], [-117.94579, 33.92933], [-117.94592, 33.92931], [-117.94593, 33.92928], [-117.94596, 33.92928], [-117.94602, 33.92933], [-117.94602, 33.92979]]]} Open Access 1 Brio Park http://www.lhcm.org/Facilities/Facility/Details/Brio-Park-27 32858 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1.386 Brio Park  
3166 3166 3165 {"type": "Polygon", "coordinates": [[[-117.9344, 33.93896], [-117.93383, 33.93901], [-117.93354, 33.93901], [-117.93332, 33.939], [-117.93322, 33.93896], [-117.93317, 33.93889], [-117.93316, 33.93885], [-117.93316, 33.93848], [-117.93327, 33.93813], [-117.93332, 33.93825], [-117.93342, 33.93841], [-117.93365, 33.93864], [-117.93385, 33.93877], [-117.93401, 33.93885], [-117.93423, 33.93892], [-117.9344, 33.93896]]]} Open Access 1 Constitution Plaza Park   17602 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1.032 Constitution Plaza Park  
3191 3191 3190 {"type": "Polygon", "coordinates": [[[-117.95426, 33.92688], [-117.95426, 33.92723], [-117.9541, 33.92723], [-117.9541, 33.92688], [-117.95426, 33.92688]]]} Open Access 1 Corona Park   17643 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 0.143 Corona Park  
3579 3579 3578 {"type": "Polygon", "coordinates": [[[-117.92918, 33.9331], [-117.92918, 33.93366], [-117.92871, 33.93366], [-117.9287, 33.93288], [-117.92903, 33.93288], [-117.92904, 33.93298], [-117.92906, 33.93302], [-117.92911, 33.93307], [-117.92918, 33.9331]]]} Open Access 1 Descanso Park   18108 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 0.866 Descanso Park  
3886 3886 3885 {"type": "Polygon", "coordinates": [[[-117.94385, 33.93367], [-117.94187, 33.93367], [-117.94187, 33.9329], [-117.94297, 33.93289], [-117.94343, 33.93281], [-117.94383, 33.93282], [-117.94385, 33.93284], [-117.94385, 33.93367]]]} Open Access 1 El Centro Park   18489 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 4.031 El Centro Park  
4061 4061 4060 {"type": "Polygon", "coordinates": [[[-117.92111, 33.94507], [-117.91973, 33.94508], [-117.91937, 33.94443], [-117.91927, 33.94399], [-117.91937, 33.94376], [-117.91922, 33.94348], [-117.91899, 33.94316], [-117.91905, 33.94291], [-117.91937, 33.94291], [-117.91943, 33.94277], [-117.91996, 33.94277], [-117.91998, 33.94291], [-117.9211, 33.9429], [-117.92111, 33.94507]]]} Open Access 1 Esteli Park   18722 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 9.99 Esteli Park  
4794 4794 4793 {"type": "Polygon", "coordinates": [[[-117.95906, 33.92836], [-117.95906, 33.92852], [-117.95319, 33.92855], [-117.95317, 33.92866], [-117.95309, 33.92868], [-117.95309, 33.92894], [-117.95265, 33.92893], [-117.95262, 33.92856], [-117.95171, 33.92859], [-117.95111, 33.92866], [-117.95055, 33.92877], [-117.95056, 33.92841], [-117.95906, 33.92836]]]} Open Access 1 Guadalupe Park   19556 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 4.138 Guadalupe Park  
5798 5798 5797 {"type": "Polygon", "coordinates": [[[-117.96304, 33.93707], [-117.96271, 33.93783], [-117.96286, 33.93844], [-117.96201, 33.93834], [-117.96201, 33.93921], [-117.96076, 33.9391], [-117.96087, 33.9381], [-117.96051, 33.93774], [-117.96048, 33.93721], [-117.96058, 33.9372], [-117.96056, 33.93693], [-117.96068, 33.93645], [-117.96048, 33.93547], [-117.96238, 33.93547], [-117.96291, 33.93606], [-117.96304, 33.93707]]]} Open Access 1 La Bonita Park   20742 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 18.864 La Bonita Park  
6012 6012 6011 {"type": "Polygon", "coordinates": [[[-117.94847, 33.9231], [-117.94621, 33.92236], [-117.94621, 33.92209], [-117.94674, 33.92208], [-117.94689, 33.9221], [-117.94739, 33.92237], [-117.94793, 33.92261], [-117.94815, 33.92266], [-117.94847, 33.92268], [-117.94847, 33.9231]]]} Open Access 1 Las Lomas Park   21057 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 2.152 Las Lomas Park  
6121 6121 6120 {"type": "Polygon", "coordinates": [[[-117.9402, 33.91751], [-117.94011, 33.91759], [-117.94011, 33.91819], [-117.93982, 33.91778], [-117.9398, 33.91767], [-117.9398, 33.91753], [-117.93984, 33.9175], [-117.9402, 33.91751]]]} Open Access 1 Leslie Park   21180 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 0.375 Leslie Park  
6318 6318 6317 {"type": "Polygon", "coordinates": [[[-117.95205, 33.92722], [-117.95059, 33.92723], [-117.95059, 33.92723], [-117.95059, 33.92714], [-117.95061, 33.92707], [-117.95148, 33.92677], [-117.95205, 33.92651], [-117.95205, 33.92722]]]} Open Access 1 Loma Verde Park   21409 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1.538 Loma Verde Park  
6328 6328 6327 {"type": "Polygon", "coordinates": [[[-117.92433, 33.94505], [-117.92328, 33.94506], [-117.92328, 33.94297], [-117.92418, 33.94297], [-117.92422, 33.943], [-117.92422, 33.94314], [-117.92384, 33.94319], [-117.92388, 33.94335], [-117.92396, 33.94349], [-117.92433, 33.94403], [-117.92433, 33.94505]]]} Open Access 1 Loma Norte Park   21406 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 4.875 Loma Norte Park  
7171 7171 7170 {"type": "Polygon", "coordinates": [[[-117.94442, 33.91445], [-117.94432, 33.91452], [-117.94376, 33.91451], [-117.94376, 33.91415], [-117.94441, 33.91415], [-117.94442, 33.91445]]]} Open Access 1 Montwood Park   22445 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 0.599 Montwood Park  
7636 7636 7635 {"type": "Polygon", "coordinates": [[[-117.97245, 33.9232], [-117.97243, 33.92449], [-117.97188, 33.92449], [-117.97187, 33.92455], [-117.97105, 33.92455], [-117.97104, 33.92329], [-117.97187, 33.92329], [-117.97189, 33.92312], [-117.97223, 33.92312], [-117.97224, 33.92319], [-117.97245, 33.9232]]]} Open Access 1 Oeste Park   23071 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 4.561 Oeste Park  
7660 7660 7659 {"type": "Polygon", "coordinates": [[[-117.93856, 33.94274], [-117.93749, 33.94274], [-117.93748, 33.9424], [-117.93795, 33.9424], [-117.93797, 33.94231], [-117.93855, 33.94231], [-117.93856, 33.94274]]]} Open Access 1 Old Reservoir Park   23101 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1.073 Old Reservoir Park  
7787 7787 7786 {"type": "Polygon", "coordinates": [[[-117.96685, 33.9453], [-117.96665, 33.94607], [-117.96489, 33.94606], [-117.96488, 33.94491], [-117.96671, 33.9449], [-117.96685, 33.9453]]]} Open Access 1 Osornio Park   23237 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 5.519 Osornio Park  
8327 8327 8326 {"type": "Polygon", "coordinates": [[[-117.94828, 33.92839], [-117.94829, 33.92877], [-117.94828, 33.92984], [-117.94825, 33.92986], [-117.94827, 33.93031], [-117.94624, 33.93031], [-117.94624, 33.92978], [-117.94621, 33.92976], [-117.94621, 33.92933], [-117.94624, 33.92931], [-117.94625, 33.9284], [-117.94828, 33.92839]]]} Open Access 1 Portola Park   23910 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 9.934 Portola Park  
8662 8662 8661 {"type": "Polygon", "coordinates": [[[-117.946, 33.92432], [-117.946, 33.92447], [-117.94596, 33.9245], [-117.9454, 33.9245], [-117.94535, 33.92447], [-117.94535, 33.92436], [-117.94565, 33.92436], [-117.94567, 33.92432], [-117.946, 33.92432]]]} Open Access 1 Richard's Park   24320 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 0.263 Richard's Park  
9229 9229 9228 {"type": "Polygon", "coordinates": [[[-117.94822, 33.94183], [-117.94705, 33.94183], [-117.94705, 33.94138], [-117.94714, 33.94137], [-117.94715, 33.94093], [-117.9477, 33.94093], [-117.94772, 33.94138], [-117.94821, 33.94139], [-117.94822, 33.94183]]]} Open Access 1 San Miguel Park   24957 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1.984 San Miguel Park  
10293 10293 10292 {"type": "Polygon", "coordinates": [[[-117.97513, 33.92838], [-117.9745, 33.92839], [-117.97406, 33.92843], [-117.97362, 33.9285], [-117.97226, 33.92878], [-117.9717, 33.92884], [-117.97113, 33.92885], [-117.97113, 33.92851], [-117.97133, 33.92837], [-117.97513, 33.92838]]]} Open Access 1 Terraza Park   26265 1155 La Habra, City of 199 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 2.359 Terraza 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]);