I want to have a default style/symbology assigned to each layer in a PostGIS database so that whenever it is loaded in 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 ArcGIS Pro.

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

Is this possible?

  • 1
    support.esri.com/en/Technical-Article/000012539, check if this helps Commented Jan 15, 2021 at 9:20
  • 2
    How about converting symbology to representation? Commented Jan 15, 2021 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. Commented Jan 15, 2021 at 14:05
  • 2
    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
    Commented Jan 20, 2021 at 7:17
  • 1
    @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. Commented Jan 20, 2021 at 16:00


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.