units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
74 rows where DES_TP = 2, MNG_AGENCY = 122 and MNG_AG_TYP = 2 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 74 ✖
MNG_AGENCY 1
- Huntington Beach, City of · 74 ✖
DES_TP 1
- Local Park · 74 ✖
ACCESS_TYP 1
- Open Access 74
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6342 | 6342 | 6341 | {"type": "MultiPolygon", "coordinates": [[[[-117.97078, 33.65111], [-117.96703, 33.65113], [-117.96703, 33.65064], [-117.97069, 33.65061], [-117.97075, 33.65064], [-117.97077, 33.65069], [-117.97078, 33.65111]]], [[[-117.97752, 33.65107], [-117.97529, 33.65108], [-117.97531, 33.65291], [-117.97363, 33.65292], [-117.97364, 33.65408], [-117.97108, 33.6541], [-117.97104, 33.65111], [-117.97111, 33.6511], [-117.9711, 33.65068], [-117.97112, 33.65065], [-117.97116, 33.65062], [-117.97751, 33.65057], [-117.97752, 33.65107]]]]} | Open Access 1 | 47451 | Edison Park | 31166 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/edison-park.cfm | Orange 3 | 39.989 | Edison Park | 0 | Local Park 2 | 4 |
6343 | 6343 | 6342 | {"type": "MultiPolygon", "coordinates": [[[[-118.00137, 33.66846], [-118.00124, 33.66851], [-118.00109, 33.66855], [-118.00094, 33.66855], [-118.0009, 33.66854], [-118.00066, 33.668], [-118.00113, 33.66787], [-118.00137, 33.66846]]], [[[-118.00141, 33.66844], [-118.00107, 33.6676], [-118.00128, 33.66748], [-118.00145, 33.66737], [-118.0015, 33.66736], [-118.00154, 33.66739], [-118.0017, 33.66763], [-118.00178, 33.66769], [-118.00192, 33.66772], [-118.00207, 33.6677], [-118.00218, 33.66772], [-118.00232, 33.66779], [-118.00238, 33.66786], [-118.00242, 33.66795], [-118.00241, 33.66808], [-118.00236, 33.66816], [-118.00229, 33.66823], [-118.00219, 33.66827], [-118.00208, 33.66829], [-118.00185, 33.66824], [-118.00172, 33.66825], [-118.00163, 33.66829], [-118.00141, 33.66844]]]]} | Open Access 1 | 47452 | Farquhar Park | 31167 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/farquhar-park.cfm | Orange 3 | 2.802 | Farquhar Park | 0 | Local Park 2 | 4 |
599 | 599 | 598 | {"type": "MultiPolygon", "coordinates": [[[[-118.00637, 33.70704], [-118.00631, 33.70705], [-118.00632, 33.70813], [-118.00629, 33.70817], [-118.00622, 33.7082], [-118.00432, 33.70821], [-118.00429, 33.70711], [-118.00008, 33.70717], [-118.00006, 33.7058], [-118.0, 33.70579], [-117.99998, 33.70472], [-118.00005, 33.70471], [-118.00004, 33.70396], [-118.0008, 33.70395], [-118.00129, 33.70372], [-118.00219, 33.70362], [-118.00217, 33.70308], [-118.00194, 33.7031], [-118.00167, 33.70337], [-118.00136, 33.70337], [-118.00136, 33.70257], [-118.00183, 33.70257], [-118.00181, 33.70184], [-118.00233, 33.70183], [-118.00232, 33.70108], [-118.0, 33.70109], [-118.0, 33.70102], [-117.99993, 33.70101], [-117.99991, 33.69928], [-118.00249, 33.69926], [-118.00246, 33.69746], [-118.00199, 33.69746], [-118.00194, 33.69392], [-118.00332, 33.6939], [-118.00333, 33.69393], [-118.00343, 33.69393], [-118.00343, 33.6939], [-118.00618, 33.69387], [-118.0062, 33.69471], [-118.00613, 33.69472], [-118.00615, 33.6956], [-118.00621, 33.69561], [-118.00625, 33.69833], [-118.00618, 33.69834], [-118.00622, 33.70105], [-118.00629, 33.70581], [-118.00635, 33.70582], [-118.00637, 33.70704]], [[-118.00621, 33.70812], [-118.00622, 33.70811], [-118.00621, 33.70738], [-118.00561, 33.70738], [-118.0054, 33.70756], [-118.0054, 33.70812], [-118.00621, 33.70812]]], [[[-118.01501, 33.69733], [-118.01496, 33.69734], [-118.01498, 33.69916], [-118.01287, 33.69918], [-118.01286, 33.69895], [-118.01285, 33.69894], [-118.01201, 33.69947], [-118.01143, 33.69976], [-118.01071, 33.70021], [-118.01077, 33.70465], [-118.0066, 33.70468], [-118.00647, 33.69562], [-118.00641, 33.69561], [-118.00639, 33.6947], [-118.00646, 33.69469], [-118.00645, 33.69399], [-118.00648, 33.69392], [-118.00655, 33.6939], [-118.00844, 33.69388], [-118.00845, 33.69382], [-118.01044, 33.6938], [-118.01045, 33.69441], [-118.01052, 33.69442], [-118.01052, 33.6938], [-118.01269, 33.69378], [-118.0127, 33.6944], [-118.01172, 33.69441], [-118.01172, 33.69451], [-118.0127, 33.69451], [-118.01271, 33.69512], [-118.01173, 33.69513], [-118.01173, 33.69523], [-118.01271, 33.69523], [-118.01272, 33.69585], [-118.01174, 33.69586], [-118.01174, 33.69596], [-118.01272, 33.69596], [-118.01273, 33.69657], [-118.01174, 33.69659], [-118.01175, 33.69669], [-118.01273, 33.69668], [-118.01274, 33.6973], [-118.01176, 33.69731], [-118.01175, 33.69735], [-118.01283, 33.69735], [-118.01284, 33.69734], [-118.01279, 33.69378], [-118.01387, 33.69377], [-118.01389, 33.6938], [-118.01496, 33.69379], [-118.01501, 33.69733]], [[-118.01054, 33.69556], [-118.01054, 33.69526], [-118.01039, 33.69526], [-118.01038, 33.69556], [-118.01054, 33.69556]], [[-118.01046, 33.69513], [-118.01054, 33.69514], [-118.01052, 33.69453], [-118.01045, 33.69454], [-118.01046, 33.69513]]]]} | Open Access 1 | 2039 | Huntington Beach Central Park | 29219 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/huntington_central_park/ | Orange 3 | 345.196 | Huntington Beach Central Park | 0 | Local Park 2 | 4 |
6194 | 6194 | 6193 | {"type": "MultiPolygon", "coordinates": [[[[-118.00915, 33.73873], [-118.00872, 33.73874], [-118.00873, 33.73936], [-118.00767, 33.73936], [-118.00765, 33.73733], [-118.00913, 33.73732], [-118.00915, 33.73873]]], [[[-118.00906, 33.73604], [-118.00909, 33.73631], [-118.00927, 33.73696], [-118.00929, 33.73713], [-118.00927, 33.73717], [-118.00918, 33.73721], [-118.00791, 33.73722], [-118.00788, 33.7356], [-118.00795, 33.7356], [-118.00796, 33.73588], [-118.00906, 33.73604]]]]} | Open Access 1 | 1223 | Greer Park | 19494 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/greer-park.cfm | Orange 3 | 11.09 | Greer Park | 0 | Local Park 2 | 4 |
10662 | 10662 | 10661 | {"type": "MultiPolygon", "coordinates": [[[[-118.01043, 33.68427], [-118.01036, 33.68434], [-118.01026, 33.68438], [-118.0102, 33.68444], [-118.01013, 33.6844], [-118.01005, 33.68443], [-118.00998, 33.68442], [-118.00994, 33.68444], [-118.00981, 33.68434], [-118.0082, 33.68347], [-118.00802, 33.68341], [-118.00783, 33.68337], [-118.00763, 33.68335], [-118.00732, 33.68337], [-118.00727, 33.68291], [-118.00769, 33.68287], [-118.00811, 33.68289], [-118.00852, 33.68297], [-118.0089, 33.6831], [-118.00926, 33.68329], [-118.00949, 33.68344], [-118.01041, 33.68419], [-118.01042, 33.68426], [-118.01043, 33.68427]]], [[[-118.01234, 33.68482], [-118.01231, 33.68488], [-118.01232, 33.68507], [-118.01193, 33.68516], [-118.0113, 33.68493], [-118.01118, 33.68493], [-118.01108, 33.68498], [-118.01071, 33.68488], [-118.01068, 33.68489], [-118.0106, 33.68516], [-118.01057, 33.68545], [-118.01057, 33.68584], [-118.01061, 33.68587], [-118.01046, 33.68585], [-118.01039, 33.68587], [-118.01039, 33.6854], [-118.01043, 33.68513], [-118.0105, 33.68485], [-118.0105, 33.68469], [-118.01044, 33.68467], [-118.01032, 33.68468], [-118.01027, 33.68465], [-118.01025, 33.6846], [-118.01038, 33.68459], [-118.01044, 33.68456], [-118.01048, 33.68452], [-118.01049, 33.68442], [-118.01056, 33.68435], [-118.01065, 33.68434], [-118.01084, 33.68444], [-118.0111, 33.68455], [-118.01151, 33.68467], [-118.01194, 33.68473], [-118.01229, 33.68474], [-118.01229, 33.68478], [-118.01234, 33.68482]]]]} | Open Access 1 | 19003 | Discovery Well Park | 18168 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/discovery-well-park.cfm | Orange 3 | 7.074 | Discovery Well Park | 0 | Local Park 2 | 4 |
1683 | 1683 | 1682 | {"type": "Polygon", "coordinates": [[[-117.94628, 33.67622], [-117.94628, 33.6763], [-117.94625, 33.67634], [-117.94616, 33.67636], [-117.94592, 33.67638], [-117.94564, 33.67662], [-117.94522, 33.67792], [-117.94463, 33.67779], [-117.94518, 33.67613], [-117.94576, 33.67624], [-117.94576, 33.67627], [-117.94615, 33.67622], [-117.9462, 33.67616], [-117.94628, 33.67622]]]} | Open Access 1 | 14568 | Arevalos Park | 15580 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/arevalos-park.cfm | Orange 3 | 2.89 | Arevalos Park | 0 | Local Park 2 | 4 |
4086 | 4086 | 4085 | {"type": "Polygon", "coordinates": [[[-117.95161, 33.68111], [-117.95086, 33.68111], [-117.95084, 33.67975], [-117.95159, 33.67974], [-117.95161, 33.68111]]]} | Open Access 1 | 47458 | Lamb Park | 31172 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lamb-park.cfm | Orange 3 | 2.599 | Lamb Park | 0 | Local Park 2 | 4 |
6574 | 6574 | 6573 | {"type": "Polygon", "coordinates": [[[-117.95262, 33.66614], [-117.95257, 33.66614], [-117.95256, 33.66584], [-117.95215, 33.66586], [-117.95156, 33.66593], [-117.95157, 33.66564], [-117.95152, 33.66493], [-117.95072, 33.66492], [-117.95046, 33.66512], [-117.95042, 33.66523], [-117.95031, 33.66523], [-117.9502, 33.66514], [-117.9502, 33.66567], [-117.95018, 33.6656], [-117.95014, 33.66553], [-117.95007, 33.66548], [-117.94998, 33.66546], [-117.94957, 33.66546], [-117.94934, 33.66543], [-117.94923, 33.66546], [-117.94917, 33.6655], [-117.94902, 33.66545], [-117.94885, 33.66542], [-117.94914, 33.6644], [-117.94963, 33.66441], [-117.94975, 33.66446], [-117.95008, 33.66446], [-117.95009, 33.66439], [-117.9526, 33.66437], [-117.95262, 33.66614]]]} | Open Access 1 | 3852 | LeBard Park | 21126 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lebard-park.cfm | Orange 3 | 9.388 | LeBard Park | 0 | Local Park 2 | 4 |
8408 | 8408 | 8407 | {"type": "Polygon", "coordinates": [[[-117.95827, 33.67701], [-117.95936, 33.67701], [-117.9594, 33.67707], [-117.9594, 33.67765], [-117.95937, 33.67768], [-117.95933, 33.67769], [-117.95882, 33.67769], [-117.95873, 33.67771], [-117.95826, 33.67769], [-117.95825, 33.67781], [-117.95819, 33.67781], [-117.95818, 33.6777], [-117.958, 33.67751], [-117.95803, 33.67743], [-117.95798, 33.67731], [-117.95795, 33.67708], [-117.95826, 33.67707], [-117.95827, 33.67701]]]} | Open Access 1 | 13024 | Bushard Park | 16539 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bushard-park.cfm | Orange 3 | 2.372 | Bushard Park | 0 | Local Park 2 | 4 |
7594 | 7594 | 7593 | {"type": "Polygon", "coordinates": [[[-117.95873, 33.64693], [-117.95787, 33.64693], [-117.95785, 33.64543], [-117.95811, 33.64541], [-117.95837, 33.64536], [-117.9587, 33.64535], [-117.95873, 33.64693]]]} | Open Access 1 | 12172 | Seeley Park | 25283 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.371 | Seeley Park | 0 | Local Park 2 | 4 | |
463 | 463 | 462 | {"type": "Polygon", "coordinates": [[[-117.95893, 33.6679], [-117.95781, 33.6679], [-117.9578, 33.66708], [-117.95781, 33.66704], [-117.95787, 33.66701], [-117.95834, 33.66699], [-117.95844, 33.66703], [-117.95854, 33.66704], [-117.95857, 33.66703], [-117.95862, 33.66697], [-117.95864, 33.66689], [-117.95891, 33.66689], [-117.95893, 33.6679]]]} | Open Access 1 | 1536 | Hawes Park | 19742 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/hawes-park.cfm | Orange 3 | 2.599 | Hawes Park | 0 | Local Park 2 | 4 |
8381 | 8381 | 8380 | {"type": "Polygon", "coordinates": [[[-117.95978, 33.66175], [-117.95953, 33.66177], [-117.95945, 33.6618], [-117.95939, 33.66186], [-117.95936, 33.66197], [-117.95937, 33.66243], [-117.95934, 33.66247], [-117.95888, 33.66264], [-117.95866, 33.66266], [-117.95859, 33.66263], [-117.95857, 33.66158], [-117.95855, 33.6615], [-117.95978, 33.66149], [-117.95978, 33.66175]]]} | Open Access 1 | 12978 | Burke Park | 16521 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/burke-park.cfm | Orange 3 | 2.488 | Burke Park | 0 | Local Park 2 | 4 |
2865 | 2865 | 2864 | {"type": "Polygon", "coordinates": [[[-117.96216, 33.65367], [-117.96217, 33.65436], [-117.96215, 33.6544], [-117.9621, 33.65444], [-117.96168, 33.65444], [-117.96167, 33.65417], [-117.95797, 33.65419], [-117.95797, 33.65472], [-117.95756, 33.65473], [-117.95755, 33.65454], [-117.95718, 33.65454], [-117.95717, 33.65419], [-117.95382, 33.65421], [-117.95382, 33.65372], [-117.96216, 33.65367]]]} | Open Access 1 | 996 | Gisler Park | 19304 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/gisler-park.cfm | Orange 3 | 11.741 | Gisler Park | 0 | Local Park 2 | 4 |
10653 | 10653 | 10652 | {"type": "Polygon", "coordinates": [[[-117.96625, 33.64478], [-117.96566, 33.64478], [-117.96564, 33.64374], [-117.96508, 33.64374], [-117.96508, 33.64337], [-117.96624, 33.64336], [-117.96625, 33.64478]]]} | Open Access 1 | 18995 | Eader Park | 18334 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/eader-park.cfm | Orange 3 | 2.682 | Eader Park | 0 | Local Park 2 | 4 |
6943 | 6943 | 6942 | {"type": "Polygon", "coordinates": [[[-117.96654, 33.66494], [-117.96582, 33.66494], [-117.9658, 33.66366], [-117.96652, 33.66365], [-117.96654, 33.66494]]]} | Open Access 1 | 5846 | Sowers Park | 25709 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.359 | Sowers Park | 0 | Local Park 2 | 4 | |
9142 | 9142 | 9141 | {"type": "Polygon", "coordinates": [[[-117.97119, 33.6764], [-117.96917, 33.67642], [-117.96916, 33.67593], [-117.96888, 33.67593], [-117.96889, 33.67476], [-117.971, 33.67475], [-117.97107, 33.67477], [-117.9711, 33.67483], [-117.97112, 33.67587], [-117.97118, 33.67587], [-117.97119, 33.6764]]]} | Open Access 1 | 15170 | Wardlow Park | 27257 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 9.111 | Wardlow Park | 0 | Local Park 2 | 4 | |
4942 | 4942 | 4941 | {"type": "Polygon", "coordinates": [[[-117.97129, 33.68368], [-117.96722, 33.68371], [-117.96721, 33.68335], [-117.96727, 33.68316], [-117.97128, 33.68313], [-117.97129, 33.68368]]]} | Open Access 1 | 14652 | Talbert Park | 26172 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 5.669 | Talbert Park | 0 | Local Park 2 | 4 | |
6337 | 6337 | 6336 | {"type": "Polygon", "coordinates": [[[-117.9718, 33.64249], [-117.9714, 33.64287], [-117.97112, 33.64322], [-117.97106, 33.64322], [-117.97105, 33.64195], [-117.9718, 33.64249]]]} | Open Access 1 | 47443 | Banning/Magnolia Park | 31160 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/banning-magnolia-park.cfm | Orange 3 | 1.21 | Banning/Magnolia Park | 0 | Local Park 2 | 4 |
1396 | 1396 | 1395 | {"type": "Polygon", "coordinates": [[[-117.97577, 33.72084], [-117.97411, 33.72085], [-117.9741, 33.72107], [-117.97401, 33.72112], [-117.97398, 33.72121], [-117.97382, 33.72105], [-117.97371, 33.72092], [-117.97358, 33.72067], [-117.97355, 33.72054], [-117.97409, 33.72051], [-117.97576, 33.72048], [-117.97577, 33.72084]]]} | Open Access 1 | 8637 | Pleasant View Park | 23803 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.117 | Pleasant View Park | 0 | Local Park 2 | 4 | |
6824 | 6824 | 6823 | {"type": "Polygon", "coordinates": [[[-117.97583, 33.66579], [-117.97583, 33.66648], [-117.9743, 33.66637], [-117.97438, 33.66607], [-117.97442, 33.66579], [-117.97583, 33.66579]]]} | Open Access 1 | 5408 | Moffett Park | 22347 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/moffett-park.cfm | Orange 3 | 2.381 | Moffett Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);