sql - MYSQL CSV Import - Cannot get geometry object from data you send to the GEOMETRY field -

-

i have csv file on server in data looks follows;

16777216,17039359,"apnic debogon project" 17367040,17432575,"tmnet, telekom malaysia bhd." 17435136,17435391,"apnic debogon project" 17498112,17563647,"cj-hellovision" 17563648,17825791,"beijing founder broadband network technology co.,l" 17825792,18087935,"allocated krnic member." 18153984,18154239,"double cast" 18157056,18163711,"family net japan incorporated"

i'm trying insert table structured follows;

ipoid    integer  11 not null primary key beginip  integer  14 not null unsigned endip    integer  14 not null unsigned org      varchar  255 ip_poly  polygon

i have spatial index created on ip_poly field

i'm trying insert csv data following code

load data infile "/home/geoiporg.csv" table crm_geo_org fields terminated "," enclosed "\"" lines terminated "\n" (@beginip,@endip,@org) set ipoid      := null, beginip := @beginip, endip   := @endip, ip_poly := geomfromwkb(polygon(linestring( /* clockwise, 4 points , 0 */ point(@beginip, -1), /* 0, top left */ point(@endip,   -1), /* 1, top right */ point(@endip,    1), /* 2, bottom right */ point(@beginip,  1), /* 3, bottom left */ point(@beginip, -1)  /* 0, start */ ))), org:= @org;

however when try error

error 1416 (22003): cannot geometry object data send geometry field

any ideas?

in later versions of mysql don't need wkb/ wkt transformations build geometry objects.

also, polygon overkill here: mbr can built single linestring well.

change ip_poly iprange linestring not null , use this:

load data infile "/home/geoiporg.csv" table         crm_geo_org fields         terminated                 ","         enclosed                 "\"" lines         terminated "\n"         (@beginip, @endip, @org) set     ipoid   := null,         beginip := @beginip,         endip   := @endip,         iprange := geomfromwkb(                         linestring(                                 point(@beginip, -1),                                 point(@endip, 1)                                 )                         ),         org     := @org;

Comments

Post a Comment

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

-
my group , running server based upon django , uses mod_wsgi run apache server. not working on project after over, attempting set cronjob similar functionality check if apache server has shut down(system restart or power failure), , if has, restart server me. i've found documentation on how check if apache server down , restart server if is, our server uses https , our start command pretty verbose. can use functionality provided in these examples: https://askubuntu.com/questions/277389/cron-job-to-restart-apache https://www.digitalocean.com/community/tutorials/how-to-use-a-simple-bash-script-to-restart-server-programs or need more complicated process make happen? the command use start server is python manage.py runmodwsgi --host 0.0.0.0 --port 8001 --https-port 8000 --ssl-certificate (certificate location) --server-name (domain name) i'm pretty new linux , using both mod-wsgi apache appreciated. you better off using --setup-only option mod_wsgi-expres...
Read more

actionscript 3 - TweenLite does not work with object -

-
i got following problem: i have object called tempscore game. this object blitted canvas renderer via copypixels method. object not display object. it's score-object (self made). score-object extends object called basicblitarrayobject. basicblitarrayobject extends eventdispatcher (therefore no display object). i tried apply several different tweenlite-plugins tempscore-object (i.e. transformaroundcenter, colormatrixfilter, etc.). nothing happens. absolutely nothing. sometimes error messages (when plugin requires display object , object not display object). far good. according greensock (maker of tweenlite) engine can tween numeric property of object. when plugin transformaroundcenter requires display object tweening have modify plugin working non-display object (tempscore). can't because it's way hard me. my game rests upon code: http://www.8bitrocket.com/book/ch11_blastermines.zip try apply tweenlite object called tempmine inside game class blastermines. ...
Read more

jQuery Ajax Render Fragments OR Whole Page -

-
i'm in throes of building application wraps mess of legacy code. page working on, need substitute fragment divs constructed on back-end -- or else need replace entire page altogether. idea there dynamically controlled flow needs satisfied before can forward legacy product. substituting fragments works fine, seen in below my_body_content swap. trouble comes when i'm trying render not fragment, whole page, in "body" swap. @ point page goes blank. i want similar errors returned server. want nice rest 404 error messages displayed on screen, legacy-product 404s show in legacy-product 404 page. yes, requirements project weird. that's not problem can fix. here's jquery invocation, names changed protect guilty: $.ajax({ url: "places/things", type: "post", data: json.stringify(somebadassobject), datatype: "text", accepts: "text/html", contenttype: "application/json; charset=...
Read more