6

I want to have a default style/symbology assigned to each layer in a PostGIS database so that whenever it is loaded in ArcMap/ArcGIS Pro, it will come up with the default style.

There is a way in QGIS to save styles to PostGIS DB so that whenever the layer is dropped to the canvas it will come with the default style, but the style saved in DB will be a qml file and hence will not work with ArcMap/ArcGIS Pro.

I am looking for a way to add style to DB such that they load in ArcMap and ArcGIS Pro as most of the users for the tool I am developing will be using ArcMap or ArcGIS Pro to connect to the DB. Is this possible?

  • support.esri.com/en/Technical-Article/000012539, check if this helps – Yogesh Chavan Jan 15 at 9:20
  • 1
    How about converting symbology to representation? – Yogesh Chavan Jan 15 at 9:32
  • @YogeshChavan can representations be stored inside PostGIS DB and will the symbology load by itself if there is representation attached with a layer in DB. Sorry I have never worked with representations before. – ar-siddiqui Jan 15 at 14:05
  • 1
    i attempted to write a few answers, but hit quite a few snags. technically this methodology of retrieving style settings from a database is implemented in other systems (other than QGIS) but I think one of the stumbling blocks in ArcMap will be lyr file, its very closed off. For ArcPro, have a look here pro.arcgis.com/en/pro-app/latest/arcpy/mapping/symbol-class.htm – nr_aus Jan 20 at 7:17
  • @nr_aus How can the methodology listed in the link for ArcPro work with a PostgreSQL database? I don't see that anywhere in the link. It talks about python scripts to apply symbology. – ar-siddiqui Jan 20 at 16:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.