I had a dataset in CartoDB with a polygon on the_geom column. The format was like this one:
{"type":"MultiPolygon","coordinates":[[[[-69.028327,44.249039],[-69.108439,44.110099],[-69.043456,44.092144],[-69.192915,44.00673],[-69.215537,43.931009],[-69.261533,43.918143],[-69.275842,43.953535],[-69.163672,44.067604],[-69.303535,43.953578],[-69.291525,44.005242],[-69.367124,43.96462],[-69.337651,44.049979],[-69.37737,44.094688],[-69.504239,43.837422],[-69.544507,43.92172],[-69.596397,43.813072],[-69.691421,43.889666],[-69.836974,43.700355],[-69.868832,43.910896],[-69.939124,43.860203],[-69.960999,43.796744],[-70.025531,43.730907],[-69.945498,43.866834],[-70.099117,43.842502],[-70.310994,43.658242],[-70.223724,43.652438],[-70.197682,43.565517],[-70.373517,43.515618],[-70.333586,43.447388],[-70.558704,43.315862],[-70.688312,43.0655],[-70.826318,43.127199],[-70.817865,43.237912],[-70.976737,43.35851],[-70.962182,43.541033],[-71.111125,43.50684],[-71.127311,43.572699],[-71.257971,43.571],[-71.532755,43.764571],[-71.564748,43.893225],[-71.361755,43.915565],[-71.347515,44.07003],[-71.443976,44.249656],[-71.575507,44.255107],[-71.764746,44.406635],[-71.536252,44.588441],[-71.631843,44.750049],[-71.49639,44.904294],[-71.541198,44.984641],[-71.464556,45.013637],[-71.505778,45.051191],[-71.398522,45.202006],[-71.444164,45.236865],[-71.284073,45.302435],[-71.147067,45.239762],[-71.010782,45.347278],[-70.839351,45.234263],[-70.795436,45.428493],[-70.62133,45.40253],[-70.722024,45.515635],[-70.552794,45.667836],[-70.418866,45.144947],[-70.159584,45.128439],[-70.131669,44.851708],[-70.032781,44.864375],[-69.930547,44.610801],[-69.605734,44.577322],[-69.632993,44.700402],[-69.470471,44.718273],[-69.372374,44.544577],[-69.506767,44.342853],[-69.346239,44.308274],[-69.269373,44.364579],[-69.028327,44.249039]]],[[[-68.943105,44.109731],[-68.917796,44.147782],[-68.843836,44.185356],[-68.807051,44.158028],[-68.943105,44.109731]]],[[[-68.821932,44.031871],[-68.897521,44.115553],[-68.907749,44.094305],[-68.912577,44.096098],[-68.902167,44.121582],[-68.785543,44.093354],[-68.821932,44.031871]]],[[[-68.654812,44.00659],[-68.651894,44.064812],[-68.601265,44.086029],[-68.611622,44.012667],[-68.654812,44.00659]]],[[[-68.833405,44.033508],[-68.838193,44.036571],[-68.832521,44.041404],[-68.829748,44.040091],[-68.833405,44.033508]]],[[[-69.113578,43.994912],[-69.125213,43.996649],[-69.1273,44.001684],[-69.109888,44.000082],[-69.113578,43.994912]]],[[[-69.148529,43.985507],[-69.149828,43.996167],[-69.137147,44.000844],[-69.135225,43.997116],[-69.148529,43.985507]]],[[[-69.317362,43.941453],[-69.309012,43.953465],[-69.30284,43.95199],[-69.292713,43.956579],[-69.317362,43.941453]]],[[[-68.900214,43.848719],[-68.902112,43.869472],[-68.88966,43.875827],[-68.884042,43.856429],[-68.900214,43.848719]]],[[[-69.555162,43.833022],[-69.56729,43.84842],[-69.547894,43.867509],[-69.545396,43.858939],[-69.555162,43.833022]]],[[[-69.679309,43.856455],[-69.685043,43.859322],[-69.682512,43.866461],[-69.677786,43.862123],[-69.679309,43.856455]]],[[[-69.948386,43.766742],[-69.942539,43.832638],[-69.892465,43.857],[-69.890529,43.781826],[-69.913775,43.835821],[-69.948386,43.766742]]],[[[-69.707462,43.836061],[-69.713251,43.849428],[-69.702715,43.85197],[-69.704178,43.841752],[-69.707462,43.836061]]],[[[-69.661092,43.786566],[-69.680898,43.822916],[-69.690303,43.822697],[-69.668157,43.851475],[-69.661092,43.786566]]],[[[-69.565751,43.824252],[-69.565735,43.832384],[-69.56259,43.828413],[-69.565751,43.824252]]],[[[-70.014171,43.811235],[-70.013116,43.823258],[-69.995773,43.824955],[-70.004216,43.814956],[-70.014171,43.811235]]],[[[-69.646974,43.819088],[-69.649986,43.82644],[-69.647702,43.826456],[-69.646974,43.819088]]],[[[-69.886959,43.808395],[-69.884572,43.820419],[-69.881498,43.823129],[-69.880969,43.813798],[-69.886959,43.808395]]],[[[-69.684558,43.809216],[-69.685719,43.816307],[-69.682115,43.816363],[-69.683327,43.810176],[-69.684558,43.809216]]],[[[-69.631756,43.803344],[-69.636339,43.809047],[-69.629215,43.81515],[-69.626047,43.806459],[-69.631756,43.803344]]],[[[-70.074778,43.796087],[-70.07844,43.796864],[-70.06655,43.804568],[-70.066002,43.800821],[-70.074778,43.796087]]],[[[-70.006169,43.717289],[-69.974076,43.776005],[-69.94614,43.794227],[-69.993497,43.723605],[-70.006169,43.717289]]],[[[-69.914484,43.774659],[-69.922252,43.781315],[-69.912558,43.788609],[-69.910821,43.779684],[-69.914484,43.774659]]],[[[-70.152457,43.746328],[-70.14525,43.773591],[-70.122843,43.773624],[-70.134459,43.770022],[-70.152457,43.746328]]],[[[-69.322756,43.755899],[-69.315985,43.7717],[-69.300376,43.770478],[-69.313821,43.757142],[-69.322756,43.755899]]],[[[-70.134183,43.753669],[-70.129717,43.76341],[-70.116538,43.764849],[-70.121667,43.759529],[-70.134183,43.753669]]],[[[-70.127954,43.706757],[-70.127457,43.745247],[-70.09648,43.759146],[-70.107417,43.725677],[-70.127954,43.706757]]],[[[-70.117477,43.683915],[-70.110523,43.694332],[-70.093449,43.710294],[-70.094593,43.691984],[-70.117477,43.683915]]],[[[-70.168116,43.676038],[-70.165762,43.691693],[-70.134993,43.702408],[-70.152503,43.681905],[-70.168116,43.676038]]],[[[-70.234778,43.686264],[-70.232187,43.69181],[-70.226189,43.690192],[-70.228107,43.687491],[-70.234778,43.686264]]],[[[-70.204189,43.672573],[-70.199701,43.687123],[-70.190414,43.688446],[-70.195276,43.672903],[-70.204189,43.672573]]],[[[-70.193975,43.65088],[-70.199944,43.662167],[-70.182797,43.673547],[-70.176199,43.662856],[-70.193975,43.65088]]],[[[-70.210121,43.662963],[-70.212881,43.665408],[-70.205912,43.670573],[-70.203955,43.666651],[-70.210121,43.662963]]],[[[-70.206903,43.634313],[-70.209848,43.641529],[-70.202993,43.647384],[-70.190793,43.646684],[-70.206903,43.634313]]],[[[-70.737496,43.074627],[-70.747097,43.080789],[-70.722459,43.080083],[-70.72904,43.075682],[-70.737496,43.074627]]]]} I made an export to CSV and combine those rows with another file I have. The above format, turned to a HEX format. Then, when I tried to import it again, the column the_geom turned to point instead of polygon and I cannot make it show the old hex values.
أكثر...
{"type":"MultiPolygon","coordinates":[[[[-69.028327,44.249039],[-69.108439,44.110099],[-69.043456,44.092144],[-69.192915,44.00673],[-69.215537,43.931009],[-69.261533,43.918143],[-69.275842,43.953535],[-69.163672,44.067604],[-69.303535,43.953578],[-69.291525,44.005242],[-69.367124,43.96462],[-69.337651,44.049979],[-69.37737,44.094688],[-69.504239,43.837422],[-69.544507,43.92172],[-69.596397,43.813072],[-69.691421,43.889666],[-69.836974,43.700355],[-69.868832,43.910896],[-69.939124,43.860203],[-69.960999,43.796744],[-70.025531,43.730907],[-69.945498,43.866834],[-70.099117,43.842502],[-70.310994,43.658242],[-70.223724,43.652438],[-70.197682,43.565517],[-70.373517,43.515618],[-70.333586,43.447388],[-70.558704,43.315862],[-70.688312,43.0655],[-70.826318,43.127199],[-70.817865,43.237912],[-70.976737,43.35851],[-70.962182,43.541033],[-71.111125,43.50684],[-71.127311,43.572699],[-71.257971,43.571],[-71.532755,43.764571],[-71.564748,43.893225],[-71.361755,43.915565],[-71.347515,44.07003],[-71.443976,44.249656],[-71.575507,44.255107],[-71.764746,44.406635],[-71.536252,44.588441],[-71.631843,44.750049],[-71.49639,44.904294],[-71.541198,44.984641],[-71.464556,45.013637],[-71.505778,45.051191],[-71.398522,45.202006],[-71.444164,45.236865],[-71.284073,45.302435],[-71.147067,45.239762],[-71.010782,45.347278],[-70.839351,45.234263],[-70.795436,45.428493],[-70.62133,45.40253],[-70.722024,45.515635],[-70.552794,45.667836],[-70.418866,45.144947],[-70.159584,45.128439],[-70.131669,44.851708],[-70.032781,44.864375],[-69.930547,44.610801],[-69.605734,44.577322],[-69.632993,44.700402],[-69.470471,44.718273],[-69.372374,44.544577],[-69.506767,44.342853],[-69.346239,44.308274],[-69.269373,44.364579],[-69.028327,44.249039]]],[[[-68.943105,44.109731],[-68.917796,44.147782],[-68.843836,44.185356],[-68.807051,44.158028],[-68.943105,44.109731]]],[[[-68.821932,44.031871],[-68.897521,44.115553],[-68.907749,44.094305],[-68.912577,44.096098],[-68.902167,44.121582],[-68.785543,44.093354],[-68.821932,44.031871]]],[[[-68.654812,44.00659],[-68.651894,44.064812],[-68.601265,44.086029],[-68.611622,44.012667],[-68.654812,44.00659]]],[[[-68.833405,44.033508],[-68.838193,44.036571],[-68.832521,44.041404],[-68.829748,44.040091],[-68.833405,44.033508]]],[[[-69.113578,43.994912],[-69.125213,43.996649],[-69.1273,44.001684],[-69.109888,44.000082],[-69.113578,43.994912]]],[[[-69.148529,43.985507],[-69.149828,43.996167],[-69.137147,44.000844],[-69.135225,43.997116],[-69.148529,43.985507]]],[[[-69.317362,43.941453],[-69.309012,43.953465],[-69.30284,43.95199],[-69.292713,43.956579],[-69.317362,43.941453]]],[[[-68.900214,43.848719],[-68.902112,43.869472],[-68.88966,43.875827],[-68.884042,43.856429],[-68.900214,43.848719]]],[[[-69.555162,43.833022],[-69.56729,43.84842],[-69.547894,43.867509],[-69.545396,43.858939],[-69.555162,43.833022]]],[[[-69.679309,43.856455],[-69.685043,43.859322],[-69.682512,43.866461],[-69.677786,43.862123],[-69.679309,43.856455]]],[[[-69.948386,43.766742],[-69.942539,43.832638],[-69.892465,43.857],[-69.890529,43.781826],[-69.913775,43.835821],[-69.948386,43.766742]]],[[[-69.707462,43.836061],[-69.713251,43.849428],[-69.702715,43.85197],[-69.704178,43.841752],[-69.707462,43.836061]]],[[[-69.661092,43.786566],[-69.680898,43.822916],[-69.690303,43.822697],[-69.668157,43.851475],[-69.661092,43.786566]]],[[[-69.565751,43.824252],[-69.565735,43.832384],[-69.56259,43.828413],[-69.565751,43.824252]]],[[[-70.014171,43.811235],[-70.013116,43.823258],[-69.995773,43.824955],[-70.004216,43.814956],[-70.014171,43.811235]]],[[[-69.646974,43.819088],[-69.649986,43.82644],[-69.647702,43.826456],[-69.646974,43.819088]]],[[[-69.886959,43.808395],[-69.884572,43.820419],[-69.881498,43.823129],[-69.880969,43.813798],[-69.886959,43.808395]]],[[[-69.684558,43.809216],[-69.685719,43.816307],[-69.682115,43.816363],[-69.683327,43.810176],[-69.684558,43.809216]]],[[[-69.631756,43.803344],[-69.636339,43.809047],[-69.629215,43.81515],[-69.626047,43.806459],[-69.631756,43.803344]]],[[[-70.074778,43.796087],[-70.07844,43.796864],[-70.06655,43.804568],[-70.066002,43.800821],[-70.074778,43.796087]]],[[[-70.006169,43.717289],[-69.974076,43.776005],[-69.94614,43.794227],[-69.993497,43.723605],[-70.006169,43.717289]]],[[[-69.914484,43.774659],[-69.922252,43.781315],[-69.912558,43.788609],[-69.910821,43.779684],[-69.914484,43.774659]]],[[[-70.152457,43.746328],[-70.14525,43.773591],[-70.122843,43.773624],[-70.134459,43.770022],[-70.152457,43.746328]]],[[[-69.322756,43.755899],[-69.315985,43.7717],[-69.300376,43.770478],[-69.313821,43.757142],[-69.322756,43.755899]]],[[[-70.134183,43.753669],[-70.129717,43.76341],[-70.116538,43.764849],[-70.121667,43.759529],[-70.134183,43.753669]]],[[[-70.127954,43.706757],[-70.127457,43.745247],[-70.09648,43.759146],[-70.107417,43.725677],[-70.127954,43.706757]]],[[[-70.117477,43.683915],[-70.110523,43.694332],[-70.093449,43.710294],[-70.094593,43.691984],[-70.117477,43.683915]]],[[[-70.168116,43.676038],[-70.165762,43.691693],[-70.134993,43.702408],[-70.152503,43.681905],[-70.168116,43.676038]]],[[[-70.234778,43.686264],[-70.232187,43.69181],[-70.226189,43.690192],[-70.228107,43.687491],[-70.234778,43.686264]]],[[[-70.204189,43.672573],[-70.199701,43.687123],[-70.190414,43.688446],[-70.195276,43.672903],[-70.204189,43.672573]]],[[[-70.193975,43.65088],[-70.199944,43.662167],[-70.182797,43.673547],[-70.176199,43.662856],[-70.193975,43.65088]]],[[[-70.210121,43.662963],[-70.212881,43.665408],[-70.205912,43.670573],[-70.203955,43.666651],[-70.210121,43.662963]]],[[[-70.206903,43.634313],[-70.209848,43.641529],[-70.202993,43.647384],[-70.190793,43.646684],[-70.206903,43.634313]]],[[[-70.737496,43.074627],[-70.747097,43.080789],[-70.722459,43.080083],[-70.72904,43.075682],[-70.737496,43.074627]]]]} I made an export to CSV and combine those rows with another file I have. The above format, turned to a HEX format. Then, when I tried to import it again, the column the_geom turned to point instead of polygon and I cannot make it show the old hex values.
أكثر...