span8
span4
span8
span4
Greetings people,
I need to fill three tables in SQL Server Non-Spatial.Tables are point,line and polygon.I read data from GML.Now,I need to insert all points,points from lines and from polygons,lines and lines from polygons and polygons,but they must fill some condition.All of them have attribute LAYER and GEOMETRY (WKB format).I need to write just these who has minimal value of LAYER (integer) and with distinct GEOMETRY.This minimal value of LAYER is minimal for each group of features with same GEOMETRY. This rule is same for all feature types.
E.g.I have
WKB1,1
WKB1,2
WKB2,2
and only need to write the last two.
Can someone give me an idea?I hope you know what I asked.:D
Takashi,very sorry,my mistake.First and last feature,not second one.
I have problem with point order in lines.When I break polygons to lines,it creates (almost allways) two lines with reverse point order for two neighbor polygons (e.g.line (1 1,2 2) and line (2 2,1 1)).I don't know how to solve this.
One more problem that appears: I already have table with lines.How to select which features to insert and which to update (based on same criteria).
LineJoiner outputs more lies than it has to0 Answers
Connecting to SQL Server Analysis Services Tabular1 Answer
IDENTITY_INSERT for several tables1 Answer
SQL - Index columns3 Answers
SQL Executor DateTime issue2 Answers
© 2019 亚搏在线Safe Software Inc |Legal