Shape2SqlServer icon indicating copy to clipboard operation
Shape2SqlServer copied to clipboard

Number of points must be 0 or >3

Open cnsnet opened this issue 3 years ago • 3 comments

When I try to import a shp file with 1,440,000 records, it only imports about 10,000, and the log file is:

MapBind.IO Information: 0 : Trace file created on 6/30/2021 1:51:59 PM MapBind.IO Information: 0 : Trace started MapBind.IO Information: 0 : Checking shape files MapBind.IO Information: 0 : Trace started MapBind.IO Information: 0 : Checking shape files MapBind.IO Information: 1 : Worker started MapBind.IO Information: 1 : Writing 0 records MapBind.IO Information: 1 : Creating table Parcels_reprojected Number of points must be 0 or >3 MapBind.IO Information: 1 : Creating spatial index... MapBind.IO Information: 1 : Commit transaction MapBind.IO Verbose: 1 : SqlBulkCopy.Close() MapBind.IO Verbose: 1 : db.Close() MapBind.IO Information: 1 : Worker completed

cnsnet avatar Jun 30 '21 07:06 cnsnet

Hi @cnsnet, seems that the shapefile contains an invalid polygon. What would you expect the program to do ? Can you share the file somewhere ?

xfischer avatar Jun 30 '21 07:06 xfischer

@cnsnet any news ?

xfischer avatar Jul 07 '21 12:07 xfischer

sorry for delay, i download shape file from this link. https://download.hcad.org/data/GIS/Parcels.zip I was thinking if i hit this error, it can skip this record and continue importing.

Thank you.

cnsnet avatar Jul 08 '21 06:07 cnsnet