Tag Info

New answers tagged

2

They're well hidden! I found a directory with archives of shapefiles here. There's some documentation here. It looks like the polygons aren't updated regularly, but you can sign up to the mailing list to find out when they are, according to that document. If you download this archive (33MB), the forecast zones are in land_CLCBaseZone_detail_proj.shp. (The ...


0

The right answer is here: I forgot points 3 and 4. support_esri_33027


3

You can try the Sort Tool. It can be used to sort by attribute, or more importantly for you, spatially. It allows you to pick which corner (i.e. upper right) to give priority when sorting.


2

You can do this by evaluating the difference of a polygon's boundary to the symmetric difference between their boundaries, or symbolically expressed as: Difference(a, SymDifference(a, b)) Take geometries a and b, expressed as MultiLinestrings over the next two lines and images: MULTILINESTRING((0 300,50 300,50 250,0 250,0 300),(50 300,100 300,100 250,50 ...


1

As described in https://www.gaia-gis.it/gaia-sins/spatialite-sql-latest.html the function is used as ST_Line_Interpolate_Point( line Curve , fraction Double precision ) : Point An example that can be tested with SQL command line for example with spatialite-gui. Fraction=0.5 finds the midpoint. SELECT ST_AsText( ST_Line_Interpolate_Point ...


0

The Esri Geometry API for Java documentation states that it implements geometry for a plane, so will not take the Date Line into account: In geometry-api-java, the geometry is planar with the exception of GeometryEngine.geodesicDistanceOnWGS84. The X/Y values are considered on an infinite plane, and all operations are executed based on that assumption. ...


1

This is VB.net code for merging lines that share a common end point, the function to call is UnsplitAllLayer0 with utility functions fFlipPC and fJoinPC. First step is to find all the locations where two lines share an endpoint then using those locations go back through and merge both features (extend one and delete the other)... a line may be extended ...


1

This is my practice of removing 'parasite' nodes. Original network with links direction shown. Links labelled by FID: Decide where the sink is going to be and flip relevant link if necessary. In this case I picked No 2. Next step I call 'create network'. Script takes selected link, traces all upstream and flips them on the go if necessary. In case ...


0

Errors free algorithm. First set: Second set: Merge 2 sets and sort in descending order by area. Select rows in the table (top => down) until total of areas = total area (16 in this case) reached: Selected rows make your answer: The criteria is going to be a difference between accumulated areas and actual total.


1

Hope this works for anyone looking for something similar. This is just the tangent angle. Getting an actual line tangent with this angle is just a matter of using ST_Project(point_in_line, tangent_length, north_heading) or regular vector construction from an angle The inputs are the line you want to calculate the tangent from and a point to project into the ...


2

Just a little bit more of the Lunar Sea answer. Your query it's ok. The problem is that you didn't gave a nome to the geometry column so qgis don't like it. Specify ::geometry ecc... is important but not essential if you know what is it inside your table. It could be possible that you have to specify Multilinestring instead of Linestring. CREATE VIEW ...


1

EDIT: The geom column needs registering in the view public.geometry_columns. This is done by adding '::geometry(linestring, SRID)' to the query: ST_MakeLine(point1.geom, point2.geom)::geometry(linestring, SRID) Thanks @user30184 for the link to the docs



Top 50 recent answers are included