units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where AGNCY_ID = 1370, AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 314
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 11
MNG_AGENCY 1
- Walnut, City of · 11 ✖
DES_TP 1
- Local Park · 11 ✖
ACCESS_TYP 1
- Open Access 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1105 | 1105 | 1104 | {"type": "Polygon", "coordinates": [[[-117.87922, 34.01538], [-117.87903, 34.01569], [-117.87895, 34.01591], [-117.87853, 34.01582], [-117.87808, 34.01591], [-117.87806, 34.01583], [-117.878, 34.01572], [-117.87794, 34.01564], [-117.87785, 34.01557], [-117.87786, 34.0155], [-117.87824, 34.01522], [-117.87844, 34.01502], [-117.87922, 34.01538]]]} | Open Access 1 | 7062 | Walnut Hills Park | 27234 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 1.922 | Walnut Hills Park | 0 | Local Park 2 | 4 | |
1108 | 1108 | 1107 | {"type": "Polygon", "coordinates": [[[-117.8731, 34.02133], [-117.87255, 34.02166], [-117.87217, 34.02181], [-117.87142, 34.02188], [-117.87142, 34.02185], [-117.87131, 34.02164], [-117.87115, 34.02146], [-117.87151, 34.02124], [-117.87185, 34.02091], [-117.87297, 34.02127], [-117.8731, 34.02133]]]} | Open Access 1 | 7064 | Arroyo Park | 15620 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 2.705 | Arroyo Park | 0 | Local Park 2 | 4 | |
1109 | 1109 | 1108 | {"type": "Polygon", "coordinates": [[[-117.86661, 34.0147], [-117.86564, 34.01504], [-117.86545, 34.01473], [-117.86411, 34.01534], [-117.86408, 34.01531], [-117.8641, 34.01529], [-117.86403, 34.01519], [-117.86375, 34.01488], [-117.86402, 34.01478], [-117.86442, 34.01469], [-117.86483, 34.01466], [-117.86503, 34.01459], [-117.86516, 34.0145], [-117.86524, 34.01436], [-117.86525, 34.01415], [-117.86529, 34.01398], [-117.86542, 34.0138], [-117.86549, 34.0136], [-117.86547, 34.01333], [-117.86543, 34.01326], [-117.86541, 34.01317], [-117.86538, 34.01309], [-117.86491, 34.01233], [-117.86484, 34.01218], [-117.86479, 34.01213], [-117.86471, 34.0121], [-117.86463, 34.01171], [-117.86484, 34.01159], [-117.86477, 34.01134], [-117.86433, 34.01101], [-117.86414, 34.0106], [-117.8637, 34.00992], [-117.86386, 34.00983], [-117.86433, 34.01052], [-117.8645, 34.0109], [-117.86495, 34.01124], [-117.86503, 34.01148], [-117.86485, 34.01159], [-117.86501, 34.01206], [-117.86554, 34.0129], [-117.86576, 34.01348], [-117.86562, 34.0138], [-117.8663, 34.01372], [-117.86637, 34.014], [-117.86661, 34.01466], [-117.86661, 34.0147]]]} | Open Access 1 | 7065 | Lemon Creek Park | 21150 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 7.273 | Lemon Creek Park | 0 | Local Park 2 | 4 | |
1237 | 1237 | 1236 | {"type": "MultiPolygon", "coordinates": [[[[-117.83721, 34.04066], [-117.83646, 34.0409], [-117.83629, 34.04045], [-117.83637, 34.04038], [-117.83637, 34.0403], [-117.83604, 34.03922], [-117.83595, 34.03901], [-117.83583, 34.0388], [-117.83523, 34.03821], [-117.83547, 34.03806], [-117.83532, 34.03769], [-117.83556, 34.03745], [-117.83585, 34.03753], [-117.83604, 34.03754], [-117.83602, 34.0378], [-117.83608, 34.03822], [-117.83613, 34.03844], [-117.83627, 34.03884], [-117.83671, 34.03957], [-117.83721, 34.04066]]], [[[-117.837, 34.03542], [-117.83675, 34.03553], [-117.83609, 34.03718], [-117.83605, 34.03741], [-117.83576, 34.03737], [-117.8356, 34.03731], [-117.83559, 34.0373], [-117.83575, 34.03701], [-117.83591, 34.03682], [-117.83599, 34.03656], [-117.83597, 34.0365], [-117.83601, 34.03648], [-117.83613, 34.03616], [-117.83624, 34.03599], [-117.8363, 34.03575], [-117.8363, 34.03569], [-117.83628, 34.03566], [-117.83633, 34.03562], [-117.83645, 34.03532], [-117.83668, 34.03538], [-117.837, 34.03542]]], [[[-117.83951, 34.03538], [-117.839, 34.0355], [-117.83871, 34.03552], [-117.83662, 34.03522], [-117.83681, 34.03494], [-117.83672, 34.03484], [-117.83677, 34.0348], [-117.83678, 34.03476], [-117.83677, 34.03474], [-117.8369, 34.03471], [-117.83728, 34.03445], [-117.83745, 34.03423], [-117.83739, 34.03413], [-117.83743, 34.03409], [-117.83744, 34.03405], [-117.83829, 34.03353], [-117.83828, 34.03326], [-117.83816, 34.0332], [-117.83817, 34.03312], [-117.83815, 34.0331], [-117.83809, 34.03306], [-117.83812, 34.03301], [-117.83806, 34.03276], [-117.8378, 34.03271], [-117.83789, 34.03236], [-117.83778, 34.03229], [-117.8378, 34.03223], [-117.83778, 34.03217], [-117.8377, 34.03212], [-117.83765, 34.03212], [-117.83759, 34.03185], [-117.83739, 34.03177], [-117.8374, 34.0314], [-117.83728, 34.03133], [-117.8373, 34.03131], [-117.83731, 34.03124], [-117.83728, 34.0312], [-117.83723, 34.03117], [-117.83719, 34.03116], [-117.83719, 34.03105], [-117.83709, 34.03084], [-117.83668, 34.03097], [-117.83641, 34.03097], [-117.83642, 34.03072], [-117.83649, 34.03052], [-117.83655, 34.03041], [-117.83665, 34.0303], [-117.83672, 34.03024], [-117.83689, 34.03013], [-117.83708, 34.03007], [-117.8384, 34.03272], [-117.83843, 34.03285], [-117.83855, 34.03296], [-117.83863, 34.03313], [-117.83853, 34.03317], [-117.83855, 34.03321], [-117.83866, 34.03318], [-117.83899, 34.03386], [-117.83908, 34.03408], [-117.83905, 34.0341], [-117.83907, 34.03414], [-117.8391, 34.03413], [-117.8392, 34.03437], [-117.83944, 34.03504], [-117.83941, 34.03506], [-117.83951, 34.03538]]], [[[-117.84179, 34.03918], [-117.84065, 34.03955], [-117.84049, 34.03896], [-117.83992, 34.0385], [-117.83938, 34.03759], [-117.83924, 34.03723], [-117.83921, 34.03683], [-117.83899, 34.0359], [-117.83877, 34.03565], [-117.83909, 34.03565], [-117.83957, 34.03557], [-117.83963, 34.03558], [-117.83968, 34.03562], [-117.84, 34.03688], [-117.84014, 34.03723], [-117.84035, 34.03764], [-117.84065, 34.03809], [-117.84097, 34.03846], [-117.84115, 34.03863], [-117.84179, 34.03918]]]]} | Open Access 1 | 7063 | Snow Creek Park | 25583 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 29.667 | Snow Creek Park | 0 | Local Park 2 | 4 | |
7494 | 7494 | 7493 | {"type": "Polygon", "coordinates": [[[-117.85284, 34.02605], [-117.85283, 34.02662], [-117.85238, 34.02662], [-117.85237, 34.02772], [-117.84945, 34.02771], [-117.84938, 34.02769], [-117.84931, 34.02763], [-117.8493, 34.02752], [-117.84942, 34.02727], [-117.84945, 34.02717], [-117.84953, 34.02675], [-117.84952, 34.02661], [-117.84941, 34.02618], [-117.84941, 34.02596], [-117.8522, 34.02598], [-117.85238, 34.02592], [-117.85239, 34.02605], [-117.85284, 34.02605]]]} | Open Access 1 | 7067 | Suzanne Park | 26090 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 13.647 | Suzanne Park | 0 | Local Park 2 | 4 | |
7516 | 7516 | 7515 | {"type": "MultiPolygon", "coordinates": [[[[-117.87003, 34.04326], [-117.87, 34.04329], [-117.86985, 34.04317], [-117.86984, 34.04314], [-117.86968, 34.04301], [-117.86967, 34.04298], [-117.86949, 34.04284], [-117.86948, 34.04279], [-117.86931, 34.0427], [-117.86931, 34.04263], [-117.8691, 34.04251], [-117.8691, 34.04244], [-117.86889, 34.04233], [-117.86887, 34.04227], [-117.86872, 34.0422], [-117.86853, 34.04214], [-117.86849, 34.04209], [-117.8681, 34.04209], [-117.86798, 34.04193], [-117.86779, 34.0412], [-117.86594, 34.04022], [-117.86347, 34.04], [-117.86345, 34.04052], [-117.86265, 34.04049], [-117.86189, 34.04059], [-117.86175, 34.04062], [-117.86147, 34.04074], [-117.86123, 34.04091], [-117.86117, 34.0409], [-117.86108, 34.04084], [-117.86059, 34.04059], [-117.86051, 34.04054], [-117.86173, 34.03991], [-117.86124, 34.03925], [-117.86128, 34.03883], [-117.86095, 34.0388], [-117.86102, 34.03819], [-117.86277, 34.03832], [-117.86323, 34.0383], [-117.86371, 34.03826], [-117.86428, 34.03818], [-117.86496, 34.03802], [-117.86541, 34.03788], [-117.86573, 34.03776], [-117.86691, 34.03722], [-117.86729, 34.03708], [-117.86761, 34.03698], [-117.86801, 34.03689], [-117.86857, 34.03681], [-117.86859, 34.03689], [-117.86834, 34.03691], [-117.86803, 34.03697], [-117.86763, 34.03706], [-117.86728, 34.03718], [-117.86686, 34.03738], [-117.8662, 34.03776], [-117.86603, 34.03792], [-117.86577, 34.03832], [-117.86574, 34.03842], [-117.86575, 34.03854], [-117.86583, 34.03867], [-117.86599, 34.03883], [-117.86599, 34.0389], [-117.86593, 34.03899], [-117.86593, 34.03902], [-117.86596, 34.03903], [-117.86598, 34.03902], [-117.86637, 34.03876], [-117.86668, 34.03876], [-117.86635, 34.03896], [-117.86634, 34.03903], [-117.86636, 34.03906], [-117.8665, 34.03915], [-117.8667, 34.03924], [-117.86692, 34.03944], [-117.86738, 34.03979], [-117.86757, 34.0399], [-117.86781, 34.03997], [-117.86804, 34.04009], [-117.86851, 34.04023], [-117.86855, 34.04027], [-117.86856, 34.04032], [-117.8685, 34.04075], [-117.86828, 34.04048], [-117.86813, 34.04042], [-117.86812, 34.04044], [-117.86827, 34.04068], [-117.86845, 34.04115], [-117.86846, 34.04136], [-117.86849, 34.0414], [-117.86852, 34.04143], [-117.86866, 34.04149], [-117.86875, 34.04155], [-117.86885, 34.04167], [-117.86905, 34.04188], [-117.86913, 34.04191], [-117.86916, 34.04181], [-117.86918, 34.04136], [-117.86921, 34.04124], [-117.86924, 34.04118], [-117.86932, 34.04114], [-117.86941, 34.04113], [-117.86962, 34.04121], [-117.86952, 34.04125], [-117.86946, 34.0413], [-117.86941, 34.04141], [-117.86942, 34.04168], [-117.86947, 34.04195], [-117.8696, 34.04229], [-117.86963, 34.04231], [-117.86964, 34.04229], [-117.86967, 34.04207], [-117.86973, 34.04187], [-117.86978, 34.0418], [-117.86982, 34.04178], [-117.86989, 34.04178], [-117.86995, 34.04202], [-117.86991, 34.04269], [-117.87003, 34.04326]]], [[[-117.86989, 34.04176], [-117.86982, 34.04176], [-117.86977, 34.04177], [-117.8697, 34.04184], [-117.86964, 34.04207], [-117.86962, 34.04225], [-117.8695, 34.04195], [-117.86945, 34.04168], [-117.86944, 34.04141], [-117.86949, 34.04131], [-117.86956, 34.04126], [-117.86967, 34.04122], [-117.86967, 34.0412], [-117.86949, 34.04112], [-117.86942, 34.0411], [-117.86931, 34.04111], [-117.86921, 34.04118], [-117.86918, 34.04124], [-117.86915, 34.04136], [-117.86913, 34.04181], [-117.86911, 34.04187], [-117.86907, 34.04186], [-117.86872, 34.04149], [-117.86852, 34.0414], [-117.8685, 34.04136], [-117.86848, 34.04114], [-117.86831, 34.04066], [-117.86818, 34.04047], [-117.86826, 34.04051], [-117.86852, 34.0408], [-117.86859, 34.04032], [-117.86858, 34.04026], [-117.86851, 34.04021], [-117.86805, 34.04006], [-117.86782, 34.03994], [-117.86759, 34.03987], [-117.8674, 34.03977], [-117.86694, 34.03941], [-117.86672, 34.03922], [-117.86664, 34.03917], [-117.86649, 34.03912], [-117.86637, 34.03903], [-117.86638, 34.03897], [-117.8667, 34.03878], [-117.86671, 34.03874], [-117.86668, 34.03873], [-117.86634, 34.03874], [-117.86596, 34.03901], [-117.86602, 34.0389], [-117.86602, 34.03884], [-117.866, 34.0388], [-117.86584, 34.03864], [-117.86579, 34.03856], [-117.86577, 34.03849], [-117.86577, 34.03842], [-117.8658, 34.03833], [-117.86601, 34.038], [-117.86619, 34.0378], [-117.86687, 34.0374], [-117.8673, 34.0372], [-117.86764, 34.03709], [-117.86812, 34.03698], [-117.86852, 34.03692], [-117.8686, 34.03692], [-117.86989, 34.04176]]], [[[-117.87019, 34.04291], [-117.87012, 34.04307], [-117.87005, 34.04331], [-117.87003, 34.04334], [-117.86999, 34.04335], [-117.86998, 34.04333], [-117.87005, 34.04329], [-117.87006, 34.04324], [-117.86994, 34.04269], [-117.86998, 34.04212], [-117.87019, 34.04291]]], [[[-117.87036, 34.04353], [-117.87025, 34.04344], [-117.87007, 34.04335], [-117.87009, 34.04332], [-117.87015, 34.04308], [-117.8702, 34.04296], [-117.87036, 34.04353]]]]} | Open Access 1 | 7059 | Walnut Ranch Park | 27243 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 63.355 | Walnut Ranch Park | 0 | Local Park 2 | 4 | |
7517 | 7517 | 7516 | {"type": "Polygon", "coordinates": [[[-117.87362, 34.01572], [-117.8733, 34.01594], [-117.87336, 34.01623], [-117.87315, 34.01638], [-117.87301, 34.01659], [-117.87292, 34.0168], [-117.87284, 34.0172], [-117.87209, 34.01711], [-117.87195, 34.01711], [-117.8718, 34.01714], [-117.87144, 34.01673], [-117.87312, 34.01538], [-117.87319, 34.01538], [-117.87321, 34.0154], [-117.87294, 34.01563], [-117.87322, 34.01588], [-117.87352, 34.01565], [-117.87362, 34.01572]]]} | Open Access 1 | 7060 | Butterfield Park | 16608 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 4.435 | Butterfield Park | 0 | Local Park 2 | 4 | |
7519 | 7519 | 7518 | {"type": "Polygon", "coordinates": [[[-117.86172, 34.0419], [-117.86171, 34.04193], [-117.86136, 34.04229], [-117.86126, 34.04243], [-117.86121, 34.04255], [-117.86119, 34.04264], [-117.85989, 34.04243], [-117.86059, 34.04509], [-117.85973, 34.04485], [-117.85929, 34.04493], [-117.85904, 34.04537], [-117.85913, 34.0457], [-117.85863, 34.04579], [-117.85826, 34.04628], [-117.85836, 34.04656], [-117.85896, 34.04642], [-117.85931, 34.047], [-117.85943, 34.0473], [-117.85748, 34.04743], [-117.85764, 34.04683], [-117.85747, 34.04623], [-117.85714, 34.04627], [-117.85713, 34.04623], [-117.85708, 34.04618], [-117.8569, 34.04609], [-117.85679, 34.046], [-117.85678, 34.04594], [-117.85665, 34.04585], [-117.85652, 34.04596], [-117.85605, 34.0456], [-117.85882, 34.04302], [-117.85979, 34.04237], [-117.86012, 34.0422], [-117.86014, 34.04214], [-117.86013, 34.04209], [-117.8598, 34.04168], [-117.85966, 34.0414], [-117.86043, 34.04065], [-117.86057, 34.04074], [-117.86098, 34.04094], [-117.86121, 34.04112], [-117.86134, 34.04129], [-117.86145, 34.04154], [-117.86151, 34.04166], [-117.86172, 34.0419]]]} | Open Access 1 | 7066 | Country Hollow Park | 17700 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 31.682 | Country Hollow Park | 0 | Local Park 2 | 4 | |
7523 | 7523 | 7522 | {"type": "MultiPolygon", "coordinates": [[[[-117.86715, 34.01984], [-117.86703, 34.01994], [-117.86627, 34.02028], [-117.86715, 34.01984], [-117.86715, 34.01984]]], [[[-117.86604, 34.02113], [-117.86601, 34.02133], [-117.86593, 34.02159], [-117.86592, 34.02183], [-117.86552, 34.0218], [-117.86541, 34.02137], [-117.86604, 34.02113]]], [[[-117.87012, 34.02608], [-117.86975, 34.02622], [-117.86972, 34.02607], [-117.86936, 34.0255], [-117.86913, 34.02532], [-117.86859, 34.02498], [-117.86845, 34.02495], [-117.86845, 34.02497], [-117.86853, 34.02498], [-117.86911, 34.02534], [-117.86934, 34.02552], [-117.86968, 34.02608], [-117.86971, 34.02621], [-117.86969, 34.02621], [-117.86965, 34.02618], [-117.86946, 34.02581], [-117.86935, 34.02565], [-117.86924, 34.02553], [-117.86898, 34.02531], [-117.86884, 34.02522], [-117.86866, 34.02513], [-117.86846, 34.02506], [-117.86815, 34.02498], [-117.8679, 34.02485], [-117.86781, 34.0248], [-117.86766, 34.02467], [-117.86746, 34.02444], [-117.86737, 34.02428], [-117.86641, 34.02209], [-117.86631, 34.02177], [-117.86628, 34.02151], [-117.8663, 34.02098], [-117.86625, 34.02076], [-117.8663, 34.02074], [-117.86621, 34.02052], [-117.86615, 34.02041], [-117.86616, 34.02035], [-117.86663, 34.02016], [-117.86701, 34.01998], [-117.86686, 34.02027], [-117.86681, 34.02041], [-117.86677, 34.02066], [-117.86678, 34.02086], [-117.86661, 34.0213], [-117.86658, 34.02149], [-117.86658, 34.02159], [-117.86661, 34.02173], [-117.86665, 34.02186], [-117.86673, 34.022], [-117.86684, 34.0226], [-117.86692, 34.02266], [-117.86709, 34.02265], [-117.86717, 34.02272], [-117.86717, 34.0228], [-117.86713, 34.02285], [-117.86709, 34.02297], [-117.86708, 34.02312], [-117.8671, 34.02321], [-117.86739, 34.02393], [-117.86781, 34.02431], [-117.86763, 34.02441], [-117.86761, 34.02445], [-117.86762, 34.02451], [-117.86776, 34.02465], [-117.8681, 34.02489], [-117.86833, 34.02494], [-117.86832, 34.02492], [-117.86812, 34.02488], [-117.86778, 34.02463], [-117.86764, 34.02448], [-117.86764, 34.02445], [-117.86766, 34.02443], [-117.86783, 34.02433], [-117.86783, 34.02429], [-117.86742, 34.02392], [-117.86711, 34.02312], [-117.86712, 34.02297], [-117.86715, 34.02288], [-117.8672, 34.0228], [-117.8672, 34.02273], [-117.86718, 34.02269], [-117.86711, 34.02264], [-117.86708, 34.02263], [-117.86696, 34.02264], [-117.86692, 34.02263], [-117.86688, 34.02259], [-117.86676, 34.02199], [-117.86668, 34.02186], [-117.86663, 34.02168], [-117.86661, 34.02154], [-117.86663, 34.02141], [-117.86666, 34.02127], [-117.86681, 34.02086], [-117.8668, 34.02066], [-117.86684, 34.02041], [-117.86705, 34.01996], [-117.86718, 34.01985], [-117.86757, 34.02064], [-117.86719, 34.02094], [-117.86715, 34.02114], [-117.86725, 34.02143], [-117.86718, 34.02156], [-117.86708, 34.02181], [-117.86707, 34.02204], [-117.86709, 34.02226], [-117.86714, 34.02237], [-117.86729, 34.02241], [-117.8676, 34.02241], [-117.86775, 34.02236], [-117.86787, 34.0226], [-117.86768, 34.02267], [-117.86755, 34.02303], [-117.8676, 34.02321], [-117.86755, 34.02324], [-117.86748, 34.02338], [-117.86748, 34.02348], [-117.86751, 34.02356], [-117.86759, 34.02369], [-117.8677, 34.02376], [-117.86796, 34.02382], [-117.86806, 34.02368], [-117.8681, 34.02355], [-117.86809, 34.02349], [-117.86803, 34.02342], [-117.86803, 34.02337], [-117.86806, 34.02332], [-117.86814, 34.02328], [-117.8682, 34.02328], [-117.86828, 34.02332], [-117.86856, 34.02329], [-117.86862, 34.02325], [-117.86864, 34.02322], [-117.86864, 34.02317], [-117.86836, 34.02248], [-117.86808, 34.02199], [-117.86803, 34.02196], [-117.86794, 34.02197], [-117.86778, 34.02203], [-117.86764, 34.02212], [-117.86756, 34.02212], [-117.8675, 34.02207], [-117.8675, 34.022], [-117.86753, 34.02196], [-117.86757, 34.02194], [-117.86778, 34.02193], [-117.8679, 34.02188], [-117.86794, 34.02185], [-117.86794, 34.02175], [-117.86777, 34.0214], [-117.86768, 34.0213], [-117.86758, 34.02123], [-117.86757, 34.0212], [-117.86757, 34.02117], [-117.8676, 34.02111], [-117.86763, 34.02109], [-117.86772, 34.02109], [-117.86778, 34.02114], [-117.8678, 34.02114], [-117.86803, 34.0216], [-117.86835, 34.02202], [-117.86869, 34.02249], [-117.86888, 34.02332], [-117.86873, 34.02328], [-117.86868, 34.02334], [-117.8686, 34.02338], [-117.86825, 34.02343], [-117.86822, 34.02346], [-117.86821, 34.02358], [-117.86815, 34.02372], [-117.86808, 34.02384], [-117.86807, 34.02391], [-117.86808, 34.02397], [-117.86813, 34.02404], [-117.86818, 34.02409], [-117.86824, 34.02412], [-117.86843, 34.02417], [-117.86891, 34.02355], [-117.86901, 34.02406], [-117.86906, 34.02514], [-117.86995, 34.02556], [-117.87012, 34.02608]]], [[[-117.87018, 34.02627], [-117.86985, 34.0264], [-117.86983, 34.0264], [-117.86984, 34.02638], [-117.87017, 34.02625], [-117.87018, 34.02627]]], [[[-117.88084, 34.0293], [-117.88082, 34.02933], [-117.88046, 34.02951], [-117.88028, 34.02958], [-117.88006, 34.02964], [-117.87962, 34.02972], [-117.8795, 34.02933], [-117.87903, 34.02946], [-117.87865, 34.02962], [-117.8782, 34.02969], [-117.8781, 34.0297], [-117.87764, 34.02963], [-117.8767, 34.02976], [-117.87682, 34.03014], [-117.87674, 34.03015], [-117.87664, 34.03021], [-117.87661, 34.03028], [-117.87661, 34.03038], [-117.87627, 34.03036], [-117.87621, 34.03104], [-117.87624, 34.03129], [-117.87618, 34.03148], [-117.87599, 34.03181], [-117.87592, 34.03204], [-117.87583, 34.03251], [-117.87584, 34.03309], [-117.87567, 34.03353], [-117.87554, 34.0338], [-117.87551, 34.03399], [-117.87558, 34.03419], [-117.87575, 34.03443], [-117.87591, 34.03512], [-117.87501, 34.03523], [-117.87496, 34.03519], [-117.87466, 34.03416], [-117.87463, 34.03397], [-117.87463, 34.03377], [-117.87465, 34.03361], [-117.87469, 34.03347], [-117.87479, 34.03323], [-117.87545, 34.03223], [-117.87553, 34.03208], [-117.87561, 34.03185], [-117.87566, 34.03154], [-117.87565, 34.03123], [-117.87557, 34.03093], [-117.87543, 34.03063], [-117.87523, 34.03037], [-117.87498, 34.03014], [-117.8748, 34.03002], [-117.87452, 34.02987], [-117.87416, 34.02975], [-117.87199, 34.02919], [-117.87162, 34.02904], [-117.87135, 34.02888], [-117.87111, 34.02869], [-117.87081, 34.02833], [-117.87052, 34.02778], [-117.8703, 34.02742], [-117.86985, 34.02656], [-117.86981, 34.02647], [-117.86981, 34.02642], [-117.86986, 34.02642], [-117.86993, 34.02652], [-117.87016, 34.02691], [-117.87034, 34.02726], [-117.87045, 34.0274], [-117.87047, 34.02738], [-117.87037, 34.02724], [-117.87019, 34.0269], [-117.86996, 34.02651], [-117.86988, 34.02642], [-117.87018, 34.0263], [-117.8702, 34.02632], [-117.87152, 34.0267], [-117.87138, 34.02698], [-117.87141, 34.02714], [-117.8716, 34.02729], [-117.87193, 34.02723], [-117.87199, 34.0274], [-117.87214, 34.02758], [-117.87186, 34.02799], [-117.872, 34.02817], [-117.87282, 34.02857], [-117.87311, 34.02863], [-117.87347, 34.02857], [-117.87368, 34.02857], [-117.87384, 34.0286], [-117.87437, 34.0289], [-117.87455, 34.02903], [-117.8755, 34.02935], [-117.87572, 34.02893], [-117.87578, 34.0289], [-117.87587, 34.02876], [-117.87656, 34.0281], [-117.87681, 34.02779], [-117.8769, 34.02764], [-117.87698, 34.02747], [-117.87705, 34.02724], [-117.87709, 34.02701], [-117.87713, 34.02691], [-117.87728, 34.0267], [-117.8773, 34.02668], [-117.87737, 34.02668], [-117.87877, 34.02742], [-117.87905, 34.02758], [-117.87948, 34.02788], [-117.87989, 34.02821], [-117.8802, 34.02852], [-117.88054, 34.02889], [-117.88084, 34.02926], [-117.88084, 34.0293]]]]} | Open Access 1 | 7061 | Creekside Park | 17781 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 67.979 | Creekside Park | 0 | Local Park 2 | 4 | |
9647 | 9647 | 9646 | {"type": "Polygon", "coordinates": [[[-117.85599, 34.04303], [-117.85581, 34.04275], [-117.85603, 34.04269], [-117.85608, 34.04272], [-117.8562, 34.04292], [-117.85618, 34.04295], [-117.85599, 34.04303]]]} | Open Access 1 | 47854 | Heidelberg Park | 31800 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | http://www.cityofwalnut.org/for-visitors/parks/heidelberg-park | Los Angeles 6 | 0.186 | Heidelberg Park | 1964 | Local Park 2 | 4 |
11925 | 11925 | 11924 | {"type": "Polygon", "coordinates": [[[-117.87168, 34.00416], [-117.87165, 34.00419], [-117.87157, 34.00422], [-117.87107, 34.0034], [-117.87124, 34.00333], [-117.8715, 34.00327], [-117.87157, 34.00332], [-117.87168, 34.00416]]]} | Open Access 1 | 24530 | Norman Ashley Park | 32651 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=161 | Los Angeles 6 | 0.744 | Norman Ashley 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]);