https://community.esri.com/t5/python-questions/python-method-to-change-spatial-reference-of-query/m-p/1290195#M67670 <P>I am using ArcGIS Pro 3.04. I have a bunch of maps in several APRX files which contain query layers, each based on a different SQL database view. Those maps are published to an ArcGIS Portal site. The data behind the database views is changing: the spatial reference is currently a state plane system but is being converted to web mercator. The query used for these layers is just one line, selecting everything that's in the database view.</P><P>I already have a process to update all the SQL views, but I need to update the query layers to the new spatial reference. In the GUI, I can do this in the layer properties, Source tab: When I re-validate the query (the query doesn't need to change), Pro re-examines the view and selects the correct SRID.</P><P>Is there any way to automate the process of changing a query layer's SRID? I've done some searching and it doesn't look like it's possible. I know I can change the connection properties using arcpy, but as far as I've seen it's not possible to update the details of a query layer (either changing the query text, or changing the SRID).</P> Wed, 17 May 2023 17:17:38 GMT DanCall1 2023-05-17T17:17:38Z https://community.esri.com/t5/python-questions/python-method-to-change-spatial-reference-of-query/m-p/1290195#M67670 <P>I am using ArcGIS Pro 3.04. I have a bunch of maps in several APRX files which contain query layers, each based on a different SQL database view. Those maps are published to an ArcGIS Portal site. The data behind the database views is changing: the spatial reference is currently a state plane system but is being converted to web mercator. The query used for these layers is just one line, selecting everything that's in the database view.</P><P>I already have a process to update all the SQL views, but I need to update the query layers to the new spatial reference. In the GUI, I can do this in the layer properties, Source tab: When I re-validate the query (the query doesn't need to change), Pro re-examines the view and selects the correct SRID.</P><P>Is there any way to automate the process of changing a query layer's SRID? I've done some searching and it doesn't look like it's possible. I know I can change the connection properties using arcpy, but as far as I've seen it's not possible to update the details of a query layer (either changing the query text, or changing the SRID).</P> Wed, 17 May 2023 17:17:38 GMT https://community.esri.com/t5/python-questions/python-method-to-change-spatial-reference-of-query/m-p/1290195#M67670 DanCall1 2023-05-17T17:17:38Z https://community.esri.com/t5/python-questions/python-method-to-change-spatial-reference-of-query/m-p/1330357#M68694 <P>I'm curious on one point.&nbsp; How do you know that it's being converted?&nbsp; Online maps and ArcGIS Pro will try to project-on-the-fly, and they usually try to match a map's basemap layer's coordinate system.&nbsp; That's where I'm curious.</P> Tue, 19 Sep 2023 19:32:44 GMT https://community.esri.com/t5/python-questions/python-method-to-change-spatial-reference-of-query/m-p/1330357#M68694 RogerDunnGIS 2023-09-19T19:32:44Z