https://community.esri.com/t5/arcgis-pro-questions/non-spatial-database-tables-in-arcgis-pro/m-p/1637834#M97702 <P><SPAN>Is there a way to pull information from non spatial database query as Query Layer in arcGis pro and publish it as service without adding view or table in spatial database ?</SPAN></P> Wed, 30 Jul 2025 21:35:18 GMT vijaybadugu 2025-07-30T21:35:18Z https://community.esri.com/t5/arcgis-pro-questions/non-spatial-database-tables-in-arcgis-pro/m-p/1637834#M97702 <P><SPAN>Is there a way to pull information from non spatial database query as Query Layer in arcGis pro and publish it as service without adding view or table in spatial database ?</SPAN></P> Wed, 30 Jul 2025 21:35:18 GMT https://community.esri.com/t5/arcgis-pro-questions/non-spatial-database-tables-in-arcgis-pro/m-p/1637834#M97702 vijaybadugu 2025-07-30T21:35:18Z https://community.esri.com/t5/arcgis-pro-questions/non-spatial-database-tables-in-arcgis-pro/m-p/1637857#M97706 <P>There's currently no way to have a service with zero feature layers. If you can add your query layer to an existing service that's ideal. If not, you can use your database's geometry functions to add an extra column to make it spatial. An example for SQL Server:</P><LI-CODE lang="sql">SELECT a.*, geometry::STGeomFromText('POINT (0 0)', 3857) [Shape] FROM [user].[table] a</LI-CODE><P>&nbsp;</P> Wed, 30 Jul 2025 23:59:52 GMT https://community.esri.com/t5/arcgis-pro-questions/non-spatial-database-tables-in-arcgis-pro/m-p/1637857#M97706 DavidSolari 2025-07-30T23:59:52Z