topic how to directly overlay sqlserver spatial data in ArcGIS JavaScript Maps SDK Questions https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551001#M51372 <HTML><HEAD></HEAD><BODY><SPAN>can anybody help me to show sqlserver spatial data without the help of any arcgis sde and all. I mean by using json or something alse</SPAN></BODY></HTML> Fri, 02 Mar 2012 09:52:59 GMT SolidSmoke 2012-03-02T09:52:59Z how to directly overlay sqlserver spatial data https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551001#M51372 <HTML><HEAD></HEAD><BODY><SPAN>can anybody help me to show sqlserver spatial data without the help of any arcgis sde and all. I mean by using json or something alse</SPAN></BODY></HTML> Fri, 02 Mar 2012 09:52:59 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551001#M51372 SolidSmoke 2012-03-02T09:52:59Z Re: how to directly overlay sqlserver spatial data https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551002#M51373 <HTML><HEAD></HEAD><BODY><SPAN>There is an arcgis data server produce that does not require SDE. It serves SQL 2008 geometry directly. </SPAN><BR /><SPAN>If you do not mind writing code, check out the sql server 2008 add on package which include the .NET library for spatial type.</SPAN></BODY></HTML> Fri, 02 Mar 2012 13:19:24 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551002#M51373 NianweiLiu 2012-03-02T13:19:24Z Re: how to directly overlay sqlserver spatial data https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551003#M51374 <HTML><HEAD></HEAD><BODY><SPAN>I know how to bring sql spatial data as sqlgeometry type.....but my problem is how to show this on map using arcgis javascript api</SPAN></BODY></HTML> Fri, 02 Mar 2012 14:07:35 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551003#M51374 SolidSmoke 2012-03-02T14:07:35Z Re: how to directly overlay sqlserver spatial data https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551004#M51375 <HTML><HEAD></HEAD><BODY><SPAN>You need something server side to serve your data from MSSQL on the web. Ideally, this would be ArcGIS Server.</SPAN></BODY></HTML> Fri, 02 Mar 2012 14:34:59 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551004#M51375 derekswingley1 2012-03-02T14:34:59Z Re: how to directly overlay sqlserver spatial data https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551005#M51376 <HTML><HEAD></HEAD><BODY><SPAN>You will first need to get the data into a web browser. You can write a simple .NET Webservice or PHP script that will server features. What you will want to do is to 'massage' the data returned by SQL into the ESRI Rest format. Check out the ESRI Rest Specification, if you can serve data in the same format you can feed it straight into a feature layer, using a feature collection or maybe straight from the url if you want to implement Query,Identify etc in your little map service.</SPAN><BR /><BR /><SPAN>ESRI Rest Spec. - </SPAN><A href="http://www.esri.com/library/whitepapers/pdfs/geoservices-rest-spec.pdf">http://www.esri.com/library/whitepapers/pdfs/geoservices-rest-spec.pdf</A></BODY></HTML> Fri, 02 Mar 2012 15:38:11 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551005#M51376 MattMoyles 2012-03-02T15:38:11Z Re: how to directly overlay sqlserver spatial data https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551006#M51377 <HTML><HEAD></HEAD><BODY><SPAN>thank you mmoyles......do you have any sample code for doing this</SPAN></BODY></HTML> Sat, 03 Mar 2012 03:58:31 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551006#M51377 SolidSmoke 2012-03-03T03:58:31Z Re: how to directly overlay sqlserver spatial data https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551007#M51378 <HTML><HEAD></HEAD><BODY><SPAN>it isn't direct but you can easily add in mxd a query layer (see my video </SPAN><A href="http://www.youtube.com/watch?v=JSDt0Mi5vHE">http://www.youtube.com/watch?v=JSDt0Mi5vHE</A><SPAN> )</SPAN><BR /><BR /><SPAN>you can see also this code (Morten Nielsen (ESRI)) shows how expose your SQL Server 2008 Geometries directly with ASP.NET as a FeatureService ready to use with any ArcGIS WebAPI Client FeatureLayer</SPAN><BR /><A href="http://www.arcgis.com/home/item.html?id=6d28a606369c43fd9a6f929541ae7c93">http://www.arcgis.com/home/item.html?id=6d28a606369c43fd9a6f929541ae7c93</A></BODY></HTML> Sat, 03 Mar 2012 11:40:56 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551007#M51378 nicogis 2012-03-03T11:40:56Z Re: how to directly overlay sqlserver spatial data https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551008#M51379 <HTML><HEAD></HEAD><BODY><SPAN>oh ciava.....that was rocking.....u saved my balls man.....thanks a lot....and a big thanks to Morten Nielsen....he s the best....always....</SPAN></BODY></HTML> Sun, 04 Mar 2012 05:03:30 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/how-to-directly-overlay-sqlserver-spatial-data/m-p/551008#M51379 SolidSmoke 2012-03-04T05:03:30Z