Advertisement
Guest User

Untitled

a guest
Jan 12th, 2017
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. from qgis.core import *
  2. from qgis.gui import *
  3. from qgis.utils import *
  4. from PyQt4.QtCore import *
  5. from PyQt4.QtGui import *
  6.  
  7. import processing
  8. from processing.core.Processing import Processing
  9.  
  10. uri = QgsDataSourceURI()
  11.  
  12. uri.setConnection("localhost", "5432", "dbName", "user", "pass")
  13.  
  14. uri.setDataSource("public", "Dzialki", "geom")
  15. layer1 = QgsVectorLayer(uri.uri(), "tbName", "postgres")
  16.  
  17. uri.setDataSource("public", "inwentaryzacja RD3 - 2015", "geom")
  18. layer2 = QgsVectorLayer(uri.uri(), "tbName", "postgres")
  19.  
  20. processing.runalg("qgis:joinattributesbylocation",{
  21. "TARGET": inwentarizationLayer,
  22. "JOIN": plotsLayer,
  23. "PREDICATE":u'intersects',
  24. "SUMMARY":0,
  25. "KEEP":0,
  26. "OUTPUT":"path"})
  27.  
  28. vl = QgsVectorLayer("path", "name", "ogr")
  29.  
  30. #QgsMapLayerRegistry.instance().addMapLayers([layer1, layer2, vl])
  31.  
  32. saveUri = "dbname='dbname' host=localhost port=5432 user='user' password='pass' key=gid type=POINT table="public"."test" (geom) sql="
  33. crs_id = 4326
  34. crs = QgsCoordinateReferenceSystem(crs_id, QgsCoordinateReferenceSystem.EpsgCrsId)
  35. error = QgsVectorLayerImport.importLayer(vl, saveUri, "postgres", crs, False, False)
  36.  
  37. imports
  38.  
  39. qgs = QgsApplication([], True)
  40. qgs.setPrefixPath("path", True)
  41. qgs.initQgis()
  42.  
  43. code..
  44.  
  45. QgsApplication.exitQgis()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement