Member Avatar for sakhi kul

Hi,

how to import/include Spatial Data format (Geometry and Geography) in Sql Server 2008 ?

  • 2 Contributors
  • 8 Replies
  • 163 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by sakhi kul
Member Avatar for sakhi kul

Thank you for reply!
I go through many articles related to this , one question in my mind , is shape files are necessary to import ? means how to set longitude , latitude on map?
I am new in this area so little bit confused:-O

will you tell me steps to draw map. because I want to add/ edit map to show further deatils.

please help!

Member Avatar for kvprajapati

>is shape files are necessary to import ? means how to set longitude , latitude on map?

From bobb's article - Spatial reference data can either be downloaded from public Web sites or purchased from companies such as Environmental Systems Research Institute (ESRI). Note that the availability of free public spatial reference data varies widely depending on local custom.

>will you tell me steps to draw map. because I want to add/ edit map to show further deatils.

I would suggest to read - http://www.conceptdevelopment.net/Database/Geoquery/

Member Avatar for sakhi kul

Thanks for reply!!

I want to develop web application for real estate agent (Admin) who will edit map and set deatil information of flat like rent, charges, address, owner name etc.

when user want to search flat in particular area ,by clicking on that area the information will appear in popup.

with this functionality, I want to show yahoo map of that area.
Is it possible? (I want to do all this stuff in asp.net MVC 2.0)

Member Avatar for sakhi kul

thank you sir,

I am trying various ways to implement yahoo map in my page,
Sir but finally i want to do it using MVC architecture.

is it possible?
because MVC is little bit confusing.
kindly tell me , the way to implement mapping in MVC:'(

Member Avatar for kvprajapati

>is it possible?.

Yes.

>.. because MVC is little bit confusing

I agree but MVC has its own place.

Member Avatar for sakhi kul

Hello,

Sir I tried a lot.
I have Yahoo API ID to access Yahoo map in my page, but i haven't got any maping control on net like virtual earth or bing map.
i viewed some projects but when i am trying in my page that giving me error.
I have tried very very simple code to dispaly map in my page-

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="YahooMP._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <script type="text/javascript" src="http://local.yahooapis.com/MapsService/V1/geocode?appid="(I wrote my api ID)">
        </script>
    <style type="text/css">  
#map{   
  height: 75%;   
  width: 100%;   
}   
</style>
</head>
<body>
    <form id="form1" runat="server">
    <div id="map">
    
    </div>
    </form>
</body>
</html>

here the problem is they told to include Yahoo!map AJAX API library.
I searched a lot but I havent found it.

again I tried another example using geocode-
given on following link-
http://magmainteractive.net/tutorials/post/Yahoo-Geocode2c-SQL-Server-2008-and-ASPNET-AJAX.aspx

in this code Virtual earth library giving error.

I am trying but I think somewhere I am missing to do .

please help!!!

(firstly I am trying to do in simple asp.net not in MVC)

Edited by sakhi kul because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.