superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where MNG_AGENCY = 54 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4937 | 4937 | 4936 | {"type": "Polygon", "coordinates": [[[-121.67534, 36.66893], [-121.67465, 36.67012], [-121.6732, 36.66958], [-121.67441, 36.66858], [-121.67534, 36.66893]]]} | Open Access 1 | Hartnell Park | 19713 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 4.222 | Hartnell Park | ||
9117 | 9117 | 9116 | {"type": "Polygon", "coordinates": [[[-121.66749, 36.67701], [-121.66553, 36.67727], [-121.6652, 36.67569], [-121.66716, 36.67543], [-121.66749, 36.67701]]]} | Open Access 1 | Salinas Central Park | 24797 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 7.776 | Salinas Central Park | ||
11406 | 11406 | 11405 | {"type": "Polygon", "coordinates": [[[-121.66677, 36.66216], [-121.66653, 36.6623], [-121.66633, 36.66247], [-121.66617, 36.66266], [-121.66606, 36.66289], [-121.66475, 36.66239], [-121.66498, 36.66174], [-121.66677, 36.66216]]]} | Open Access 1 | Woodside Park | 27742 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 2.977 | Woodside Park | ||
9118 | 9118 | 9117 | {"type": "Polygon", "coordinates": [[[-121.66339, 36.71025], [-121.66325, 36.71055], [-121.66286, 36.71042], [-121.66285, 36.71032], [-121.66281, 36.71021], [-121.66295, 36.7101], [-121.66339, 36.71025]]]} | Open Access 1 | Salinas holding 1 | 24799 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 0.402 | Salinas holding 1 | ||
6053 | 6053 | 6052 | {"type": "Polygon", "coordinates": [[[-121.66291, 36.69015], [-121.66181, 36.69081], [-121.66142, 36.69038], [-121.66121, 36.69018], [-121.66121, 36.69015], [-121.6614, 36.68998], [-121.66155, 36.68988], [-121.66171, 36.68979], [-121.662, 36.68969], [-121.66264, 36.68952], [-121.66291, 36.69015]]]} | Open Access 1 | Laurelwood Park | 21107 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 2.965 | Laurelwood Park | ||
7058 | 7058 | 7057 | {"type": "Polygon", "coordinates": [[[-121.662, 36.66355], [-121.662, 36.66364], [-121.66192, 36.66372], [-121.66177, 36.66376], [-121.66155, 36.66379], [-121.66134, 36.66378], [-121.66043, 36.66356], [-121.66021, 36.66344], [-121.66006, 36.66329], [-121.66004, 36.66324], [-121.66004, 36.66318], [-121.66007, 36.66313], [-121.66011, 36.66309], [-121.66034, 36.66303], [-121.66054, 36.66301], [-121.66077, 36.66303], [-121.66153, 36.66321], [-121.66164, 36.66325], [-121.6618, 36.66334], [-121.66194, 36.66346], [-121.662, 36.66355]]]} | Open Access 1 | Mission Park | 22304 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 2.468 | Mission Park | ||
7483 | 7483 | 7482 | {"type": "Polygon", "coordinates": [[[-121.65964, 36.70897], [-121.65953, 36.709], [-121.65927, 36.70942], [-121.65928, 36.70947], [-121.65919, 36.70953], [-121.65893, 36.70994], [-121.65892, 36.71003], [-121.65888, 36.71005], [-121.65865, 36.71042], [-121.65865, 36.71047], [-121.65835, 36.71041], [-121.658, 36.71039], [-121.65769, 36.71043], [-121.65735, 36.71053], [-121.65797, 36.70943], [-121.65802, 36.70926], [-121.65802, 36.70908], [-121.65817, 36.70906], [-121.65822, 36.709], [-121.65907, 36.70888], [-121.65946, 36.7088], [-121.6596, 36.70883], [-121.65964, 36.70897]]]} | Open Access 1 | Northgate Park | 22875 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 4.862 | Northgate Park | ||
3017 | 3017 | 3016 | {"type": "Polygon", "coordinates": [[[-121.6595, 36.67057], [-121.65909, 36.67063], [-121.659, 36.67022], [-121.65942, 36.67016], [-121.6595, 36.67057]]]} | Open Access 1 | Clay Park | 17397 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 0.426 | Clay Park | ||
6048 | 6048 | 6047 | {"type": "Polygon", "coordinates": [[[-121.65771, 36.69962], [-121.65743, 36.69999], [-121.65723, 36.69997], [-121.65658, 36.70005], [-121.65635, 36.69887], [-121.65758, 36.69871], [-121.65771, 36.69962]]]} | Open Access 1 | Laurel Park | 21101 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 3.487 | Laurel Park | ||
9785 | 9785 | 9784 | {"type": "Polygon", "coordinates": [[[-121.65616, 36.72516], [-121.65615, 36.7258], [-121.65563, 36.7258], [-121.65567, 36.72576], [-121.65568, 36.72571], [-121.65567, 36.72566], [-121.65564, 36.72561], [-121.6556, 36.72559], [-121.65553, 36.72558], [-121.65543, 36.7256], [-121.65542, 36.72514], [-121.65612, 36.72513], [-121.65616, 36.72516]]]} | Open Access 1 | Soto Square Park | 25632 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1.073 | Soto Square Park | ||
9124 | 9124 | 9123 | {"type": "Polygon", "coordinates": [[[-121.65536, 36.6777], [-121.655, 36.67846], [-121.65496, 36.67849], [-121.65491, 36.67849], [-121.65489, 36.67846], [-121.65466, 36.6778], [-121.65536, 36.6777]]]} | Open Access 1 | Salinas holding 3 | 24801 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 0.711 | Salinas holding 3 | ||
9607 | 9607 | 9606 | {"type": "Polygon", "coordinates": [[[-121.65217, 36.69015], [-121.65159, 36.69783], [-121.64807, 36.6977], [-121.64676, 36.69741], [-121.64651, 36.69696], [-121.64646, 36.69678], [-121.64645, 36.6966], [-121.64683, 36.69195], [-121.6462, 36.69108], [-121.64785, 36.69036], [-121.64948, 36.69], [-121.6521, 36.69007], [-121.65215, 36.6901], [-121.65217, 36.69015]]]} | Open Access 1 | Sherwood Park | 25403 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 96.824 | Sherwood Park | ||
7925 | 7925 | 7924 | {"type": "Polygon", "coordinates": [[[-121.65097, 36.72554], [-121.65096, 36.72568], [-121.65085, 36.72602], [-121.6503, 36.72616], [-121.64992, 36.72621], [-121.64989, 36.7262], [-121.64984, 36.72593], [-121.64986, 36.72575], [-121.65001, 36.72574], [-121.65097, 36.72554]]]} | Open Access 1 | Santa Rita Park | 25125 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1.227 | Santa Rita Park | ||
3010 | 3010 | 3009 | {"type": "Polygon", "coordinates": [[[-121.64974, 36.65505], [-121.64922, 36.65654], [-121.64854, 36.65624], [-121.64808, 36.65611], [-121.64804, 36.65608], [-121.64804, 36.65605], [-121.6485, 36.65476], [-121.64974, 36.65505]]]} | Open Access 1 | Claremont Manor Park | 17382 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 4.607 | Claremont Manor Park | ||
3189 | 3189 | 3188 | {"type": "Polygon", "coordinates": [[[-121.6483, 36.67085], [-121.648, 36.67068], [-121.648, 36.67068], [-121.64825, 36.6706], [-121.6483, 36.67085]]]} | Open Access 1 | Cornell Park | 17639 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 0.084 | Cornell Park | ||
4117 | 4117 | 4116 | {"type": "Polygon", "coordinates": [[[-121.64685, 36.68137], [-121.64545, 36.68299], [-121.64495, 36.68271], [-121.64449, 36.68241], [-121.64405, 36.68208], [-121.64362, 36.68172], [-121.6463, 36.68102], [-121.64634, 36.68112], [-121.64685, 36.68137]]]} | Open Access 1 | Exposition Grounds | 18776 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 7.605 | Exposition Grounds | ||
9119 | 9119 | 9118 | {"type": "Polygon", "coordinates": [[[-121.6464, 36.69999], [-121.6463, 36.70028], [-121.64573, 36.70014], [-121.64571, 36.70012], [-121.64572, 36.69982], [-121.6464, 36.69999]]]} | Open Access 1 | Salinas holding 2 | 24800 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 0.492 | Salinas holding 2 | ||
6622 | 6622 | 6621 | {"type": "Polygon", "coordinates": [[[-121.64451, 36.66158], [-121.64444, 36.66168], [-121.64442, 36.66176], [-121.64412, 36.66174], [-121.64372, 36.66184], [-121.64365, 36.66153], [-121.64388, 36.66138], [-121.6441, 36.66119], [-121.64451, 36.66158]]]} | Open Access 1 | Maple Recreation Area | 21782 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 0.786 | Maple Rec. Area | ||
6847 | 6847 | 6846 | {"type": "Polygon", "coordinates": [[[-121.64403, 36.71378], [-121.64397, 36.71373], [-121.64282, 36.7136], [-121.64272, 36.71364], [-121.6426, 36.71362], [-121.64265, 36.71343], [-121.64272, 36.71297], [-121.64239, 36.71286], [-121.64241, 36.71261], [-121.64236, 36.71255], [-121.6423, 36.71251], [-121.64236, 36.71223], [-121.6433, 36.71223], [-121.64374, 36.71225], [-121.64398, 36.71238], [-121.64397, 36.71297], [-121.64403, 36.71378]]]} | Open Access 1 | Mckinnon Park | 22052 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 5.069 | Mckinnon Park | ||
3899 | 3899 | 3898 | {"type": "Polygon", "coordinates": [[[-121.63983, 36.71043], [-121.63971, 36.71072], [-121.6395, 36.71079], [-121.63948, 36.71087], [-121.6396, 36.71101], [-121.63942, 36.71147], [-121.6385, 36.71111], [-121.63788, 36.71092], [-121.63724, 36.71077], [-121.63624, 36.71061], [-121.6362, 36.71058], [-121.63686, 36.70851], [-121.6369, 36.70848], [-121.63892, 36.70897], [-121.63896, 36.7089], [-121.63939, 36.709], [-121.63935, 36.70916], [-121.63938, 36.70931], [-121.6397, 36.70941], [-121.63967, 36.70948], [-121.63961, 36.71013], [-121.63983, 36.71043]]]} | Open Access 1 | El Dorado Park | 18507 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 17.017 | El Dorado Park |
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]);