google maps api 3 - What is wrong in this Polygon in MYSQL 5.7.19? -

-



so, trying save polygon in mysql using geospatial functions... found several examples online following:

select st_geomfromtext('polygon(( 13.517837674890684 76.453857421875, 13.838079936422464 77.750244140625, 14.517837674890684 79.453857421875, 13.517837674890684 76.453857421875, 13.517837674890684 76.453857421875 ))');  select  st_geomfromtext('polygon(( -98.07697478272888 30.123832577126326, -98.07697478272888 30.535734310413392, -97.48302581787107 30.535734310413392, -97.48302581787107 30.123832577126326, -98.07697478272888 30.123832577126326 ))')

the problem when tried make own, returns following error: error code: 3037. invalid gis data provided function st_geometryfromtext.

this code used...

select st_geomfromtext('polygon(( -99.16939973831177 19.42468828496807, -99.16710376739502 19.424607339789876, -99.16712522506714 19.422907481732416, -99.168541431427 19.421996836172347, -99.16989326477051 19.422947954749972 ))');

these longitude-latitude pairs, think has order current order consecutive.

can give me hint, please?

thank you

edit: mention in comments section, definition polygon must closed.

i using google maps javascript api v3 draw polygon , using "overlaycomplete" event listener fires function when polygon closes. function fires print coordinates given api.

if polygon must close exactly, why api not giving exact coordinates? there work around?

the polygon should close way 

select st_geomfromtext('polygon(( -99.16939973831177 19.42468828496807, -99.16710376739502 19.424607339789876, -99.16712522506714 19.422907481732416, -99.168541431427 19.421996836172347, -99.16989326477051 19.422947954749972,  -99.16939973831177 19.42468828496807 ))');




wiki

Comments

Post a Comment

Popular posts from this blog

python - Read npy file directly from S3 StreamingBody -

-
i have many .npy (numpy) , .json files saved in s3, need download , load these files. for json files downloading files , loading dictionary using following code: obj = s3.object(bucket, key) response = obj.get() body = response['body'].read().decode('utf-8') data = json.loads(body) that way avoid writing .json file disk , reading it. now want same .npy files, equivalent? currently downloading file, saving temp file on disk , loading np.load avoid if possible. following https://stackoverflow.com/a/28196540/3509999 : obj = s3.object(bucket, key) io.bytesio(obj.get()["body"].read()) f: # rewind file f.seek(0) arr = np.load(f) wiki
Read more

kotlin - Out-projected type in generic interface prohibits the use of metod with generic parameter -

-
i start using kotlin , defined interface this: interface aadapter<vh : recyclerview.viewholder> { fun oncreateaviewholder(parent: viewgroup): vh fun onbindaviewholder(v: vh, position: int) } and when try use on code: class klasa ( private val adapter: aadapter<*> ) { fun dosth(){ //... val vh = this.adapter.oncreateaviewholder(parent) //on below line error adapter.onbindaviewholder(v, position) //... } } i error out-projected type 'aadapter<*>' prohibits use of 'public abstract fun onbindaviewholder(v: t, position: int): unit i tied add "in" or "out" definition i'm confused. how allow it. replace aadapter<*> aadapter<recyclerview.viewholder> . class klasa ( private val adapter: aadapter<recyclerview.viewholder> ) { // ... because have declared aadapter has type parameter vh type subclass of recyclerview....
Read more

Asterisk AGI Python Script to Dialplan does not work -

-
i'm stuck project have check database of sip extension incoming caller id , dial sip extension. below receive when run script on asterisk cli. -- registered sip '9125' @ 192.168.1.102:50142 > saved useragent "zoiper rv2.8.40" peer 9125 [2017-08-22 13:53:33] notice[5095]: chan_sip.c:24558 handle_response_peerpoke: peer '9125' reachable. (17ms / 2000ms) == using sip rtp tos bits 184 == using sip rtp cos mark 5 -- executing [0112617769@from-trunk:1] answer("sip/obitrunk1-0000000d", "") in new stack > 0x1ca50d0 -- probation passed - setting rtp source address 192.168.1.98:16834 -- executing [0112617769@from-trunk:2] agi("sip/obitrunk1-0000000d", "test.py") in new stack -- launched agi script /var/lib/asterisk/agi-bin/test.py args: ['/var/lib/asterisk/agi-bin/test.py'] env line: agi_request: test.py env line: agi_channel: sip/obitrunk1-0000000d env line: agi_language: en env line: a...
Read more