Advertisement
Guest User

Untitled

a guest
Jul 28th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. mydb = dbConnect(MySQL(), user='root', password='mrwolf',dbname='jtw_schema', host='localhost')
  2. strSQL = "select sa2_main11, astext(shape) as geom from centroids
  3. where (gcc_name11 = 'Greater Sydney')
  4. and (sa4_name11 != 'Central Coast')
  5. and (sa4_name11 not like '%Outer West%' )
  6. and (sa4_name11 not like '%Baulkham Hills%')
  7. and (sa4_name11 not like '%Outer South West%')"
  8.  
  9.  
  10. dfCord = dbGetQuery(mydb, strSQL)
  11.  
  12. sa2_main11 geom
  13. 1 116011303 POINT(150.911550090995 -33.7568493603359)
  14. 2 116011304 POINT(150.889312296536 -33.7485997378428)
  15. 3 116011305 POINT(150.898781823296 -33.7817496751367)
  16. 4 116011306 POINT(150.872046414103 -33.7649465663774)
  17. ....
  18.  
  19. sa2_main11 Lat Long
  20. 1 116011303 150.911550090995 -33.7568493603359
  21. 2 116011304 150.889312296536 -33.7485997378428
  22. 3 116011305 150.898781823296 -33.7817496751367
  23. 4 116011306 150.872046414103 -33.7649465663774
  24. ....
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement