units_with_maps

Table actions

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

22 rows where COUNTY = 3, LAYER = 2 and MNG_AGENCY = 199

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • La Habra, City of · 22 ✖

DES_TP 1

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
550 550 549 {"type": "Polygon", "coordinates": [[[-117.96304, 33.93707], [-117.96271, 33.93783], [-117.96286, 33.93844], [-117.962, 33.93833], [-117.96201, 33.93921], [-117.96076, 33.9391], [-117.96087, 33.9381], [-117.96051, 33.93774], [-117.96048, 33.93721], [-117.96059, 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 3043 La Bonita Park 20742 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 18.853 La Bonita Park 0 Local Park 2 4
837 837 836 {"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 5461 Montwood Park 22445 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 0.6 Montwood Park 0 Local Park 2 4
895 895 894 {"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.97188, 33.92329], [-117.97189, 33.92312], [-117.97223, 33.92312], [-117.97224, 33.92319], [-117.97245, 33.9232]]]} Open Access 1 6330 Oeste Park 23071 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 4.558 Oeste Park 0 Local Park 2 4
1223 1223 1222 {"type": "Polygon", "coordinates": [[[-117.94828, 33.92839], [-117.94829, 33.92877], [-117.94828, 33.92984], [-117.94825, 33.92985], [-117.94827, 33.93031], [-117.94624, 33.93031], [-117.94624, 33.92977], [-117.94621, 33.92976], [-117.94621, 33.92933], [-117.94624, 33.92932], [-117.94625, 33.9284], [-117.94828, 33.92839]]]} Open Access 1 8808 Portola Park 23910 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 9.934 Portola Park 0 Local Park 2 4
1966 1966 1965 {"type": "Polygon", "coordinates": [[[-117.95903, 33.92151], [-117.95902, 33.9244], [-117.95895, 33.92445], [-117.9564, 33.92444], [-117.95641, 33.92279], [-117.95705, 33.92278], [-117.95706, 33.92154], [-117.95903, 33.92151]]]} Open Access 1 15115 Vista Grande Park 27173 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 17.31 Vista Grande Park 0 Local Park 2 4
2658 2658 2657 {"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 18157 Corona Park 17643 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 0.143 Corona Park 0 Local Park 2 4
3342 3342 3341 {"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.93884], [-117.93316, 33.93848], [-117.93327, 33.93813], [-117.93332, 33.93824], [-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 30298 Constitution Plaza Park 17602 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 1.032 Constitution Plaza Park 0 Local Park 2 4
5755 5755 5754 {"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 3692 Las Lomas Park 21057 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 2.154 Las Lomas Park 0 Local Park 2 4
5792 5792 5791 {"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 44 El Centro Park 18489 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 4.032 El Centro Park 0 Local Park 2 4
5912 5912 5911 {"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.91997, 33.94291], [-117.9211, 33.9429], [-117.92111, 33.94507]]]} Open Access 1 369 Esteli Park 18722 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 9.989 Esteli Park 0 Local Park 2 4
11820 11820 11819 {"type": "Polygon", "coordinates": [[[-117.93856, 33.94274], [-117.93749, 33.94274], [-117.93748, 33.9424], [-117.93796, 33.9424], [-117.93797, 33.94231], [-117.93855, 33.94231], [-117.93856, 33.94274]]]} Open Access 1 24593 Old Reservoir Park 23101 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 1.073 Old Reservoir Park 0 Local Park 2 4
11971 11971 11970 {"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 24591 Descanso Park 18108 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 0.867 Descanso Park 0 Local Park 2 4
11972 11972 11971 {"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 24592 Loma Verde Park 21409 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 1.539 Loma Verde Park 0 Local Park 2 4
11973 11973 11972 {"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.94771, 33.94138], [-117.94821, 33.94139], [-117.94822, 33.94183]]]} Open Access 1 24594 San Miguel Park 24957 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 1.981 San Miguel Park 0 Local Park 2 4
11974 11974 11973 {"type": "Polygon", "coordinates": [[[-117.97513, 33.92838], [-117.9745, 33.92839], [-117.97406, 33.92843], [-117.97362, 33.9285], [-117.97227, 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 24595 Terraza Park 26265 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 2.36 Terraza Park 0 Local Park 2 4
12847 12847 12846 {"type": "Polygon", "coordinates": [[[-117.95906, 33.92836], [-117.95906, 33.92852], [-117.95318, 33.92855], [-117.95317, 33.92866], [-117.95309, 33.92867], [-117.95309, 33.92894], [-117.95265, 33.92893], [-117.95263, 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 30299 Guadalupe Park 19556 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 4.132 Guadalupe Park 0 Local Park 2 4
12848 12848 12847 {"type": "Polygon", "coordinates": [[[-117.9402, 33.91751], [-117.94011, 33.91758], [-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 30300 Leslie Park 21180 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 0.374 Leslie Park 0 Local Park 2 4
12849 12849 12848 {"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.94318], [-117.92388, 33.94335], [-117.92396, 33.94349], [-117.92433, 33.94403], [-117.92433, 33.94505]]]} Open Access 1 30301 Loma Norte Park 21406 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 4.871 Loma Norte Park 0 Local Park 2 4
12850 12850 12849 {"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 30302 Osornio Park 23237 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 5.52 Osornio Park 0 Local Park 2 4
12851 12851 12850 {"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.94566, 33.92436], [-117.94567, 33.92432], [-117.946, 33.92432]]]} Open Access 1 30303 Richard's Park 24320 1155 La Habra, City of 203 City 2 City Agency 2 http://www.ci.la-habra.ca.us/section.cfm?id=79 City 2 1155 La Habra, City of 199 City 2 City Agency 2   Orange 3 0.262 Richard's Park 0 Local Park 2 4

Next page

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