Hfrhyu

Sort in WP_Query(), not filter? Is it possible?

How do you conduct xenoanthropology after first contact?

Why was the "bread communication" in the arena of Catching Fire left out in the movie?

Latin words with no plurals in English

Check if two datetimes are between two others

How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)

Symmetry in quantum mechanics

Imbalanced dataset binary classification

Finding files for which a command fails

LM317 - Calculate dissipation due to voltage drop

Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?

How to move the player while also allowing forces to affect it

Are objects structures and/or vice versa?

New order #4: World

Is Fable (1996) connected in any way to the Fable franchise from Lionhead Studios?

Does the average primeness of natural numbers tend to zero?

Ideas for colorfully and clearly highlighting graph edges according to weights

Does a dangling wire really electrocute me if I'm standing in water?

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

Can I find out the caloric content of bread by dehydrating it?

Crop image to path created in TikZ?

Eliminate empty elements from a list with a specific pattern

Weird behaviour when using querySelector

How to make payment on the internet without leaving a money trail?

Creating Polygons from Points in Carto

Creating collection of polygons from collection of points?Creating polygons from points in MapinfoTool for Creating PolygonsRebuilding a Polygon from the points within it, in PostGISCreating voronoi polygons from polygons?Convert ETRS89 points to CARTO Lat LongCreating Polygons from black/white map or points using QGIS?How to use ST_SymDifference for polygons from the same table having the same name value in CARTO?Dissolve/merge polygons using ST_Union in CARTOSt_Segmentize on CARTO

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

Using Carto, I am trying to create shapefiles of regions using points(Link to Dataset in Carto ) with a shared column value to group by. I've included 3 photographs. 1st photograph of the points outlining the shape. the second photo is my desired result which I have drawn out by hand. The third photo is an attempt that doesnt meet my desired result..

I am using the analysis tool provided by Carto, running a concave hull and have tried various target percent values and without the desired results. For this example I've included a target percent of 80 and the result is shown in a photograph at the bottom. The code is provided below

 SELECT row_number() over() as cartodb_id,
 territoryid as category,
 ST_ConcaveHull(
 ST_Collect(the_geom), 
 0.8, 
 false
 ) AS the_geom,
 count(1) as count_vals
 FROM (
 SELECT *
 FROM ( SELECT * FROM "st-braund".bd_regions_1 ) _camshaft_category_filter
 WHERE territoryid IN (3)
 ) _analysis_source
GROUP BY territoryid

postgis postgresql carto polygon-creation

share|improve this question

edited Aug 21 '18 at 1:20

Sbraund

asked Aug 17 '18 at 18:02

SbraundSbraund

104

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Can you elaborate on your question? I can see two concave polygons the second with a higher percent value, so I don't understand where the issue is. What do you mean by poor results? What were you expecting?
  
  – Jorge Sanz
  Aug 20 '18 at 8:28
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  how's the result in the range between 0.99 and 0.90?
  
  – ThingumaBob
  Aug 20 '18 at 20:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks for the input @ThingumaBob! at 99 seemed to have closest to the desired result.
  
  – Sbraund
  Sep 12 '18 at 0:45
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JorgeSanz is it possible to write an order by statement after the group by statement?
  
  – Sbraund
  Sep 12 '18 at 1:00
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yep @Sbraund, you can always wrap your query and put your ordering outside WITH a AS (myquery) SELECT * FROM a ORDER BY b
  
  – Jorge Sanz
  Sep 13 '18 at 7:02
  

  
  
  
  

add a comment | 

0

Using Carto, I am trying to create shapefiles of regions using points(Link to Dataset in Carto ) with a shared column value to group by. I've included 3 photographs. 1st photograph of the points outlining the shape. the second photo is my desired result which I have drawn out by hand. The third photo is an attempt that doesnt meet my desired result..

I am using the analysis tool provided by Carto, running a concave hull and have tried various target percent values and without the desired results. For this example I've included a target percent of 80 and the result is shown in a photograph at the bottom. The code is provided below

 SELECT row_number() over() as cartodb_id,
 territoryid as category,
 ST_ConcaveHull(
 ST_Collect(the_geom), 
 0.8, 
 false
 ) AS the_geom,
 count(1) as count_vals
 FROM (
 SELECT *
 FROM ( SELECT * FROM "st-braund".bd_regions_1 ) _camshaft_category_filter
 WHERE territoryid IN (3)
 ) _analysis_source
GROUP BY territoryid

postgis postgresql carto polygon-creation

share|improve this question

edited Aug 21 '18 at 1:20

Sbraund

asked Aug 17 '18 at 18:02

SbraundSbraund

104

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Can you elaborate on your question? I can see two concave polygons the second with a higher percent value, so I don't understand where the issue is. What do you mean by poor results? What were you expecting?
  
  – Jorge Sanz
  Aug 20 '18 at 8:28
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  how's the result in the range between 0.99 and 0.90?
  
  – ThingumaBob
  Aug 20 '18 at 20:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks for the input @ThingumaBob! at 99 seemed to have closest to the desired result.
  
  – Sbraund
  Sep 12 '18 at 0:45
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JorgeSanz is it possible to write an order by statement after the group by statement?
  
  – Sbraund
  Sep 12 '18 at 1:00
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yep @Sbraund, you can always wrap your query and put your ordering outside WITH a AS (myquery) SELECT * FROM a ORDER BY b
  
  – Jorge Sanz
  Sep 13 '18 at 7:02
  

  
  
  
  

add a comment | 

Using Carto, I am trying to create shapefiles of regions using points(Link to Dataset in Carto ) with a shared column value to group by. I've included 3 photographs. 1st photograph of the points outlining the shape. the second photo is my desired result which I have drawn out by hand. The third photo is an attempt that doesnt meet my desired result..

I am using the analysis tool provided by Carto, running a concave hull and have tried various target percent values and without the desired results. For this example I've included a target percent of 80 and the result is shown in a photograph at the bottom. The code is provided below

 SELECT row_number() over() as cartodb_id,
 territoryid as category,
 ST_ConcaveHull(
 ST_Collect(the_geom), 
 0.8, 
 false
 ) AS the_geom,
 count(1) as count_vals
 FROM (
 SELECT *
 FROM ( SELECT * FROM "st-braund".bd_regions_1 ) _camshaft_category_filter
 WHERE territoryid IN (3)
 ) _analysis_source
GROUP BY territoryid

postgis postgresql carto polygon-creation

share|improve this question

edited Aug 21 '18 at 1:20

Sbraund

asked Aug 17 '18 at 18:02

SbraundSbraund

104

 SELECT row_number() over() as cartodb_id,
 territoryid as category,
 ST_ConcaveHull(
 ST_Collect(the_geom), 
 0.8, 
 false
 ) AS the_geom,
 count(1) as count_vals
 FROM (
 SELECT *
 FROM ( SELECT * FROM "st-braund".bd_regions_1 ) _camshaft_category_filter
 WHERE territoryid IN (3)
 ) _analysis_source
GROUP BY territoryid

share|improve this question

edited Aug 21 '18 at 1:20

Sbraund

asked Aug 17 '18 at 18:02

SbraundSbraund

104

share|improve this question

edited Aug 21 '18 at 1:20

Sbraund

asked Aug 17 '18 at 18:02

SbraundSbraund

104

asked Aug 17 '18 at 18:02

SbraundSbraund

104

asked Aug 17 '18 at 18:02

SbraundSbraund

104

1 Answer
1

active

oldest

votes

0

The solution I found for the above problem was to

Create Lines from the points --> Close the Lines --> then make a polygon from closed lines.

SELECT row_number() over() AS cartodb_id, *,
 ST_Length(the_geom_webmercator::geography) as length FROM (
 SELECT territoryid as category
 , ST_MakeLine(the_geom ORDER BY bd_territories_coords_id asc) AS the_geom_webmercator 
 FROM (
 SELECT * FROM "st-braund".template_localities_1 ) _line_sequential
 GROUP BY territoryid ) _cdb_analysis_line_sequential

---

share|improve this answer

edited Mar 5 at 0:35

tinlyx

5,38163374

answered Mar 4 at 23:42

SbraundSbraund

104

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f293185%2fcreating-polygons-from-points-in-carto%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

The solution I found for the above problem was to

Create Lines from the points --> Close the Lines --> then make a polygon from closed lines.

SELECT row_number() over() AS cartodb_id, *,
 ST_Length(the_geom_webmercator::geography) as length FROM (
 SELECT territoryid as category
 , ST_MakeLine(the_geom ORDER BY bd_territories_coords_id asc) AS the_geom_webmercator 
 FROM (
 SELECT * FROM "st-braund".template_localities_1 ) _line_sequential
 GROUP BY territoryid ) _cdb_analysis_line_sequential

---

share|improve this answer

edited Mar 5 at 0:35

tinlyx

5,38163374

answered Mar 4 at 23:42

SbraundSbraund

104

add a comment | 

0

The solution I found for the above problem was to

Create Lines from the points --> Close the Lines --> then make a polygon from closed lines.

SELECT row_number() over() AS cartodb_id, *,
 ST_Length(the_geom_webmercator::geography) as length FROM (
 SELECT territoryid as category
 , ST_MakeLine(the_geom ORDER BY bd_territories_coords_id asc) AS the_geom_webmercator 
 FROM (
 SELECT * FROM "st-braund".template_localities_1 ) _line_sequential
 GROUP BY territoryid ) _cdb_analysis_line_sequential

---

share|improve this answer

edited Mar 5 at 0:35

tinlyx

5,38163374

answered Mar 4 at 23:42

SbraundSbraund

104

add a comment | 

The solution I found for the above problem was to

Create Lines from the points --> Close the Lines --> then make a polygon from closed lines.

SELECT row_number() over() AS cartodb_id, *,
 ST_Length(the_geom_webmercator::geography) as length FROM (
 SELECT territoryid as category
 , ST_MakeLine(the_geom ORDER BY bd_territories_coords_id asc) AS the_geom_webmercator 
 FROM (
 SELECT * FROM "st-braund".template_localities_1 ) _line_sequential
 GROUP BY territoryid ) _cdb_analysis_line_sequential

---

share|improve this answer

edited Mar 5 at 0:35

tinlyx

5,38163374

answered Mar 4 at 23:42

SbraundSbraund

104

SELECT row_number() over() AS cartodb_id, *,
 ST_Length(the_geom_webmercator::geography) as length FROM (
 SELECT territoryid as category
 , ST_MakeLine(the_geom ORDER BY bd_territories_coords_id asc) AS the_geom_webmercator 
 FROM (
 SELECT * FROM "st-braund".template_localities_1 ) _line_sequential
 GROUP BY territoryid ) _cdb_analysis_line_sequential

share|improve this answer

edited Mar 5 at 0:35

tinlyx

5,38163374

answered Mar 4 at 23:42

SbraundSbraund

104

edited Mar 5 at 0:35

tinlyx

5,38163374

edited Mar 5 at 0:35

tinlyx

5,38163374

answered Mar 4 at 23:42

SbraundSbraund

104

answered Mar 4 at 23:42

SbraundSbraund

104