superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 31 sorted by map
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5776 | 5776 | 5775 | {"type": "MultiPolygon", "coordinates": [[[[-121.86485, 37.65969], [-121.86436, 37.66029], [-121.86268, 37.65941], [-121.86144, 37.65906], [-121.86041, 37.65887], [-121.85917, 37.65829], [-121.85695, 37.65625], [-121.85736, 37.65603], [-121.85769, 37.656], [-121.85819, 37.6561], [-121.85944, 37.65643], [-121.85967, 37.65676], [-121.85967, 37.657], [-121.8596, 37.65735], [-121.85966, 37.6577], [-121.85988, 37.65806], [-121.86025, 37.6583], [-121.86059, 37.6584], [-121.86167, 37.65848], [-121.86245, 37.65865], [-121.86485, 37.65969]]], [[[-121.86892, 37.66161], [-121.86819, 37.66187], [-121.86792, 37.66173], [-121.86756, 37.66176], [-121.86728, 37.66195], [-121.8676, 37.6623], [-121.86806, 37.6625], [-121.86787, 37.66301], [-121.86671, 37.663], [-121.86685, 37.66151], [-121.86892, 37.66161]]]]} | Open Access 1 | Kottinger Park | 20720 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 20.031 | Kottinger Park | ||
7055 | 7055 | 7054 | {"type": "MultiPolygon", "coordinates": [[[[-121.87194, 37.64739], [-121.87184, 37.64769], [-121.87168, 37.64785], [-121.87161, 37.64812], [-121.87143, 37.64811], [-121.87124, 37.64811], [-121.87109, 37.64787], [-121.87092, 37.64767], [-121.87067, 37.64752], [-121.87044, 37.64734], [-121.86941, 37.64669], [-121.86909, 37.64642], [-121.86933, 37.64636], [-121.86961, 37.64634], [-121.87065, 37.64645], [-121.87061, 37.64677], [-121.87138, 37.64686], [-121.8716, 37.64691], [-121.8716, 37.64693], [-121.87176, 37.64705], [-121.87187, 37.64719], [-121.87194, 37.64739]]], [[[-121.87319, 37.65007], [-121.87297, 37.65046], [-121.87262, 37.65035], [-121.87256, 37.65055], [-121.87075, 37.64993], [-121.87068, 37.64995], [-121.87046, 37.65015], [-121.87027, 37.65039], [-121.8702, 37.65037], [-121.87017, 37.65033], [-121.87018, 37.65029], [-121.87068, 37.64963], [-121.87078, 37.64946], [-121.8709, 37.64906], [-121.87095, 37.64884], [-121.87097, 37.64865], [-121.87093, 37.64838], [-121.87098, 37.64834], [-121.87129, 37.64827], [-121.87147, 37.64827], [-121.87169, 37.64832], [-121.87189, 37.6484], [-121.87203, 37.6485], [-121.87211, 37.64859], [-121.87217, 37.64869], [-121.87225, 37.64898], [-121.87236, 37.64915], [-121.87246, 37.64923], [-121.87259, 37.6493], [-121.87274, 37.64935], [-121.87285, 37.64937], [-121.87276, 37.64976], [-121.87314, 37.64979], [-121.87313, 37.64985], [-121.87307, 37.64992], [-121.87306, 37.64997], [-121.87311, 37.65004], [-121.87319, 37.65007]]]]} | Open Access 1 | Mission Hills Park | 22300 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 13.731 | Mission Hills Park | 1999 | |
8253 | 8253 | 8252 | {"type": "Polygon", "coordinates": [[[-121.84934, 37.67753], [-121.84925, 37.67858], [-121.8483, 37.67911], [-121.84787, 37.67968], [-121.84777, 37.67993], [-121.84555, 37.67995], [-121.84497, 37.67734], [-121.84513, 37.67742], [-121.84562, 37.67737], [-121.84614, 37.67698], [-121.8464, 37.67694], [-121.84669, 37.67707], [-121.84666, 37.67735], [-121.84681, 37.67764], [-121.84772, 37.67721], [-121.84827, 37.67712], [-121.84934, 37.67753]]]} | Open Access 1 | Pleasanton holding 3 | 23806 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 22.766 | Pleasanton holding 3 | ||
8254 | 8254 | 8253 | {"type": "Polygon", "coordinates": [[[-121.85023, 37.68137], [-121.84817, 37.68139], [-121.84815, 37.67994], [-121.84777, 37.67993], [-121.84787, 37.67968], [-121.8483, 37.67911], [-121.84925, 37.67858], [-121.84933, 37.67753], [-121.84827, 37.67712], [-121.84772, 37.67721], [-121.8468, 37.67765], [-121.84666, 37.67735], [-121.84668, 37.67708], [-121.8464, 37.67694], [-121.84614, 37.67698], [-121.84562, 37.67737], [-121.84513, 37.67742], [-121.84497, 37.67734], [-121.84477, 37.67645], [-121.8468, 37.67577], [-121.85001, 37.67585], [-121.85023, 37.68137]]]} | Open Access 1 | Pleasanton holding 4 | 23807 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 32.779 | Pleasanton holding 4 | ||
10924 | 10924 | 10923 | {"type": "Polygon", "coordinates": [[[-121.85036, 37.65762], [-121.84964, 37.65799], [-121.84955, 37.65798], [-121.84914, 37.65787], [-121.84905, 37.6582], [-121.84875, 37.65815], [-121.84864, 37.65811], [-121.84855, 37.65812], [-121.84834, 37.65768], [-121.84763, 37.65711], [-121.84817, 37.65719], [-121.8486, 37.65721], [-121.84898, 37.65717], [-121.84946, 37.65708], [-121.84975, 37.65705], [-121.84979, 37.65744], [-121.85021, 37.65742], [-121.85036, 37.65762]]]} | Open Access 1 | Vintage Hills Park | 27146 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.866 | Vintage Hills Park | ||
10236 | 10236 | 10235 | {"type": "Polygon", "coordinates": [[[-121.85656, 37.66294], [-121.85641, 37.66331], [-121.85608, 37.66315], [-121.85568, 37.66323], [-121.85554, 37.66341], [-121.8556, 37.66364], [-121.85545, 37.66393], [-121.85512, 37.66409], [-121.85492, 37.66412], [-121.8546, 37.66419], [-121.85432, 37.66405], [-121.85418, 37.66405], [-121.85397, 37.66408], [-121.85398, 37.6634], [-121.85656, 37.66294]]]} | Open Access 1 | Tawny Park | 26198 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 3.543 | Tawny Park | ||
2093 | 2093 | 2092 | {"type": "Polygon", "coordinates": [[[-121.85913, 37.66996], [-121.85864, 37.67006], [-121.85845, 37.66932], [-121.85888, 37.66925], [-121.85913, 37.66996]]]} | Open Access 1 | BMX Facility | 16201 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.847 | BMX Facility | ||
6888 | 6888 | 6887 | {"type": "Polygon", "coordinates": [[[-121.85977, 37.69562], [-121.85969, 37.69728], [-121.85872, 37.6973], [-121.85841, 37.69714], [-121.85853, 37.69673], [-121.85848, 37.69604], [-121.85861, 37.69577], [-121.85907, 37.69559], [-121.85977, 37.69562]]]} | Open Access 1 | Meadows Park | 22098 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 4.868 | Meadows Park | ||
7020 | 7020 | 7019 | {"type": "Polygon", "coordinates": [[[-121.86242, 37.67993], [-121.86223, 37.67999], [-121.86182, 37.68021], [-121.86175, 37.68021], [-121.86156, 37.68003], [-121.86141, 37.67992], [-121.8612, 37.67984], [-121.86096, 37.67978], [-121.86097, 37.67923], [-121.86135, 37.67899], [-121.86162, 37.67876], [-121.86169, 37.67876], [-121.86172, 37.67878], [-121.8615, 37.67899], [-121.8621, 37.67943], [-121.86221, 37.67955], [-121.86234, 37.67985], [-121.86242, 37.67993]]]} | Open Access 1 | Pleasanton holding 1 | 23804 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.663 | Pleasanton holding 1 | ||
1116 | 1116 | 1115 | {"type": "Polygon", "coordinates": [[[-121.86303, 37.69199], [-121.8629, 37.6922], [-121.8628, 37.6923], [-121.86266, 37.69239], [-121.86203, 37.69274], [-121.86193, 37.69277], [-121.86118, 37.69275], [-121.8612, 37.69125], [-121.86234, 37.69122], [-121.86232, 37.69131], [-121.86236, 37.69137], [-121.86245, 37.69143], [-121.86241, 37.69195], [-121.86303, 37.69199]]]} | Open Access 1 | Amaral Park | 15436 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 4.921 | Amaral Park | ||
925 | 925 | 924 | {"type": "Polygon", "coordinates": [[[-121.86652, 37.65941], [-121.86612, 37.66004], [-121.86508, 37.65957], [-121.86553, 37.65894], [-121.86652, 37.65941]]]} | Open Access 1 | McKinley Park | 22047 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.046 | McKinley Park | ||
14603 | 14603 | 14602 | {"type": "Polygon", "coordinates": [[[-121.8681, 37.62662], [-121.86809, 37.62949], [-121.86746, 37.62949], [-121.86738, 37.62958], [-121.86719, 37.62974], [-121.86701, 37.62999], [-121.86704, 37.63011], [-121.86705, 37.63038], [-121.86702, 37.63046], [-121.86704, 37.63053], [-121.86733, 37.63117], [-121.86726, 37.63131], [-121.86735, 37.63136], [-121.86744, 37.63156], [-121.86696, 37.63156], [-121.86695, 37.63157], [-121.86761, 37.63321], [-121.86754, 37.63324], [-121.86752, 37.63323], [-121.86724, 37.63258], [-121.86693, 37.63267], [-121.86653, 37.63313], [-121.86542, 37.63362], [-121.86487, 37.63389], [-121.86502, 37.63417], [-121.86474, 37.63427], [-121.86444, 37.63433], [-121.86278, 37.63494], [-121.86129, 37.63491], [-121.86113, 37.63488], [-121.86098, 37.63481], [-121.86096, 37.63476], [-121.86101, 37.63462], [-121.86103, 37.6345], [-121.86102, 37.63427], [-121.86164, 37.63401], [-121.86159, 37.63348], [-121.86117, 37.63345], [-121.86142, 37.63313], [-121.86168, 37.63309], [-121.86172, 37.6331], [-121.86217, 37.63287], [-121.86227, 37.63264], [-121.86262, 37.63207], [-121.86196, 37.63105], [-121.86149, 37.6305], [-121.86094, 37.6296], [-121.8606, 37.62883], [-121.86034, 37.62882], [-121.8604, 37.62867], [-121.86041, 37.62853], [-121.86031, 37.62774], [-121.86034, 37.62758], [-121.86041, 37.6274], [-121.86029, 37.62735], [-121.8602, 37.6275], [-121.86012, 37.62748], [-121.85898, 37.62797], [-121.8579, 37.6265], [-121.85797, 37.62603], [-121.85819, 37.62589], [-121.85848, 37.62587], [-121.85881, 37.62593], [-121.85907, 37.62586], [-121.85927, 37.62573], [-121.86018, 37.62572], [-121.86054, 37.6257], [-121.86062, 37.62557], [-121.86053, 37.62523], [-121.86079, 37.62515], [-121.86085, 37.62494], [-121.861, 37.62492], [-121.86109, 37.62488], [-121.86128, 37.62499], [-121.8615, 37.62527], [-121.86166, 37.62542], [-121.86172, 37.62559], [-121.86173, 37.62574], [-121.86216, 37.62596], [-121.86288, 37.6265], [-121.8632, 37.6266], [-121.86336, 37.62669], [-121.86347, 37.62673], [-121.86363, 37.62674], [-121.8637, 37.62672], [-121.86373, 37.62667], [-121.8637, 37.62657], [-121.86319, 37.62626], [-121.86305, 37.626], [-121.863, 37.62595], [-121.86294, 37.62586], [-121.86297, 37.62583], [-121.86306, 37.62567], [-121.86313, 37.62561], [-121.8633, 37.6256], [-121.86351, 37.62565], [-121.86358, 37.62564], [-121.86364, 37.62561], [-121.86368, 37.62557], [-121.86372, 37.62542], [-121.86377, 37.62535], [-121.86395, 37.62528], [-121.86401, 37.62528], [-121.86409, 37.62533], [-121.86419, 37.62535], [-121.86429, 37.62545], [-121.86443, 37.62544], [-121.86454, 37.62545], [-121.86472, 37.62555], [-121.8648, 37.62584], [-121.86506, 37.62594], [-121.86517, 37.62602], [-121.86544, 37.62616], [-121.86554, 37.62628], [-121.86574, 37.62626], [-121.86579, 37.62627], [-121.86595, 37.62662], [-121.86595, 37.62664], [-121.86606, 37.6268], [-121.86624, 37.62694], [-121.86628, 37.627], [-121.86632, 37.62717], [-121.86635, 37.62719], [-121.86642, 37.6272], [-121.86662, 37.62711], [-121.86679, 37.62705], [-121.86685, 37.62702], [-121.86685, 37.62699], [-121.86696, 37.62693], [-121.86718, 37.62701], [-121.86712, 37.62739], [-121.86706, 37.62751], [-121.86716, 37.62766], [-121.86728, 37.62769], [-121.86727, 37.62785], [-121.86722, 37.62798], [-121.867, 37.62835], [-121.86686, 37.6285], [-121.86686, 37.62852], [-121.86691, 37.62854], [-121.86719, 37.6283], [-121.86731, 37.62822], [-121.86747, 37.62785], [-121.86763, 37.62771], [-121.86774, 37.62743], [-121.86791, 37.62731], [-121.868, 37.62701], [-121.86804, 37.62665], [-121.8681, 37.62662]], [[-121.86232, 37.63345], [-121.86168, 37.63343], [-121.8617, 37.63379], [-121.86179, 37.63397], [-121.8621, 37.63405], [-121.86235, 37.63398], [-121.86248, 37.6339], [-121.86248, 37.63351], [-121.86232, 37.63345]], [[-121.86638, 37.62877], [-121.86626, 37.62874], [-121.86603, 37.62888], [-121.86601, 37.62867], [-121.86589, 37.62847], [-121.86563, 37.62841], [-121.86527, 37.62842], [-121.86519, 37.62857], [-121.86521, 37.62865], [-121.86511, 37.62889], [-121.86535, 37.62917], [-121.86549, 37.6291], [-121.86562, 37.6291], [-121.86579, 37.62903], [-121.86585, 37.62931], [-121.866, 37.62918], [-121.86651, 37.62896], [-121.86638, 37.62877]]]} | Restricted Access 2 | Callippe Preserve Golf Course | 33079 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 130.102 | Callippe Preserve GC | ||
7380 | 7380 | 7379 | {"type": "Polygon", "coordinates": [[[-121.87206, 37.68809], [-121.87038, 37.68876], [-121.8697, 37.6881], [-121.87007, 37.68773], [-121.87022, 37.68738], [-121.87023, 37.68721], [-121.87084, 37.68715], [-121.87099, 37.68721], [-121.87112, 37.68723], [-121.87206, 37.68809]]]} | Open Access 1 | Nielsen Park | 22755 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 5.222 | Nielsen Park | ||
6261 | 6261 | 6260 | {"type": "Polygon", "coordinates": [[[-121.87403, 37.65996], [-121.87324, 37.66069], [-121.87298, 37.66051], [-121.87377, 37.65978], [-121.87403, 37.65996]]]} | Open Access 1 | Lions Wayside Park | 21328 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.803 | Lions Wayside Park | ||
7751 | 7751 | 7750 | {"type": "Polygon", "coordinates": [[[-121.87408, 37.67782], [-121.87375, 37.67788], [-121.8736, 37.6778], [-121.87339, 37.67784], [-121.87336, 37.67786], [-121.8733, 37.67785], [-121.87308, 37.67789], [-121.873, 37.67797], [-121.87297, 37.67802], [-121.87264, 37.67807], [-121.87261, 37.67805], [-121.87226, 37.67811], [-121.87219, 37.67808], [-121.87212, 37.67808], [-121.87182, 37.67814], [-121.87169, 37.67823], [-121.87165, 37.67824], [-121.87145, 37.67841], [-121.87145, 37.67844], [-121.8714, 37.67848], [-121.87136, 37.67849], [-121.87116, 37.67866], [-121.87115, 37.6787], [-121.87087, 37.67893], [-121.86969, 37.67807], [-121.86968, 37.67804], [-121.86969, 37.678], [-121.87006, 37.6777], [-121.87021, 37.67763], [-121.87036, 37.67759], [-121.87076, 37.6776], [-121.87091, 37.67768], [-121.87137, 37.6777], [-121.87152, 37.67761], [-121.87222, 37.67763], [-121.87227, 37.67761], [-121.87233, 37.67764], [-121.87244, 37.67766], [-121.87247, 37.67768], [-121.87277, 37.67769], [-121.8728, 37.67767], [-121.87294, 37.67765], [-121.87301, 37.6776], [-121.87304, 37.67753], [-121.87306, 37.67717], [-121.87303, 37.6771], [-121.87297, 37.67705], [-121.87306, 37.67679], [-121.8733, 37.67682], [-121.87362, 37.67683], [-121.87368, 37.67684], [-121.87372, 37.67687], [-121.87408, 37.67782]]]} | Open Access 1 | Orloff Park | 23205 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 7.691 | Orloff Park | ||
3555 | 3555 | 3554 | {"type": "Polygon", "coordinates": [[[-121.87494, 37.65914], [-121.87422, 37.6598], [-121.87396, 37.65962], [-121.87468, 37.65896], [-121.87494, 37.65914]]]} | Open Access 1 | Delucchi Park | 18079 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.731 | Delucchi Park | ||
10584 | 10584 | 10583 | {"type": "Polygon", "coordinates": [[[-121.87537, 37.65526], [-121.87412, 37.65639], [-121.87282, 37.6555], [-121.87259, 37.65569], [-121.87194, 37.65524], [-121.87305, 37.65422], [-121.87363, 37.65459], [-121.87398, 37.65478], [-121.87442, 37.65495], [-121.87537, 37.65526]]]} | Open Access 1 | Upper Pleasanton Field | 26734 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 8.261 | Upper Pleasanton Field | ||
4137 | 4137 | 4136 | {"type": "Polygon", "coordinates": [[[-121.87635, 37.69208], [-121.87563, 37.69288], [-121.87564, 37.69337], [-121.87559, 37.69353], [-121.87547, 37.6937], [-121.8738, 37.69474], [-121.87393, 37.69503], [-121.87355, 37.69523], [-121.87289, 37.69542], [-121.87251, 37.69486], [-121.87209, 37.69482], [-121.87166, 37.69507], [-121.87158, 37.69525], [-121.87212, 37.69579], [-121.8716, 37.69617], [-121.87091, 37.69587], [-121.87017, 37.69592], [-121.87008, 37.6963], [-121.87007, 37.69656], [-121.8699, 37.69673], [-121.86981, 37.69706], [-121.86998, 37.69734], [-121.87024, 37.69742], [-121.8706, 37.69737], [-121.87081, 37.69744], [-121.8704, 37.69789], [-121.86975, 37.69748], [-121.86966, 37.69676], [-121.86936, 37.69661], [-121.86885, 37.69673], [-121.86857, 37.69682], [-121.86816, 37.69684], [-121.86819, 37.69651], [-121.86806, 37.6963], [-121.86778, 37.69617], [-121.86738, 37.69625], [-121.867, 37.69651], [-121.86656, 37.69662], [-121.86596, 37.69661], [-121.86596, 37.69631], [-121.86674, 37.69624], [-121.86766, 37.69602], [-121.86817, 37.69605], [-121.86848, 37.69651], [-121.86895, 37.69654], [-121.86933, 37.69626], [-121.86943, 37.69582], [-121.86989, 37.69563], [-121.87036, 37.69566], [-121.87064, 37.69553], [-121.87091, 37.6952], [-121.8713, 37.69503], [-121.87162, 37.69482], [-121.87294, 37.69437], [-121.87335, 37.69412], [-121.87375, 37.69442], [-121.87406, 37.69442], [-121.87426, 37.69435], [-121.8744, 37.69422], [-121.87446, 37.69411], [-121.87444, 37.69391], [-121.8743, 37.69371], [-121.87489, 37.69344], [-121.87482, 37.6932], [-121.87504, 37.69311], [-121.8755, 37.69271], [-121.8754, 37.69178], [-121.87586, 37.69186], [-121.87635, 37.69208]]]} | Open Access 1 | Fairlands Park | 18801 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 15.603 | Fairlands Park | ||
966 | 966 | 965 | {"type": "Polygon", "coordinates": [[[-121.87721, 37.67438], [-121.87705, 37.67441], [-121.87693, 37.67448], [-121.87685, 37.67458], [-121.87492, 37.67454], [-121.87477, 37.67436], [-121.87417, 37.67454], [-121.87339, 37.67466], [-121.87279, 37.67288], [-121.87277, 37.67231], [-121.87485, 37.67227], [-121.87479, 37.67327], [-121.87616, 37.67386], [-121.87718, 37.67366], [-121.87721, 37.67438]]]} | Open Access 1 | Amador Valley Community Park | 15435 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 14.991 | Amador Valley Community Park | ||
10844 | 10844 | 10843 | {"type": "Polygon", "coordinates": [[[-121.87743, 37.66136], [-121.87705, 37.66208], [-121.87682, 37.66199], [-121.87683, 37.66197], [-121.87682, 37.66193], [-121.87705, 37.66136], [-121.87711, 37.66126], [-121.87743, 37.66136]]]} | Open Access 1 | Veterans Plaza | 27060 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 0.595 | Veterans Plaza |
Advanced export
JSON shape: default, array, newline-delimited
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]);