Hi, I'm pretty confused about that SDO Ordinate Array - I sure thought that was supposed to be a list of coordinates.
Are you confident that the import from shapefiles worked okay? Regards, Rich On 1/13/06, hemendra <[EMAIL PROTECTED]> wrote: > this is another mail to rich sir..... > WGS 84 is 8307 srid > i tried with it > i m pasting the sql prompt result... > please help me out in deducing the lat and long which google takes > > SQL> select * from parcel where rownum=1; > > AREA PERIMETER PARCEL_ PARCEL_ID PARCEL_NO > ---------- ---------- ---------- ---------- ----------------------- > GEOM(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES) > -------------------------------------------------------------------------------- > 1402171.41 4765.59944 2 1 0303060000004000 > SDO_GEOMETRY(2003, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), > SDO_ORDINATE_ARR > AY(-68.71, .21, 51.55, -71.41, -125.66, 11.63, 32.22, -15.36, 108.17, 58.21, > 109 > .95, -26.06, -68.71, .21)) > > > > what method or stored proc i shud execute to get lat and long > > here (-68.71, .21, 51.55, -71.41, -125.66, 11.63, 32.22, -15.36, 108.17, > 58.21, 109 > .95, -26.06, -68.71, .21)) > this cant be the geographical data > > with regards > hemendra > > > ----- Original Message ----- > From: "Rich Gibson" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Friday, January 13, 2006 11:42 AM > Subject: Re: [Geowanking] hii everybody > > > Hi Hermendra, > > I guess Sophia's questions are still relevant...what are you trying to do? > > > i reely dont wanna purchase any book > > Well, that sort of leaves me and Schuyler out of the loop :-) > http://www.amazon.com/gp/product/0596101619/sr=1-1/qid=1137132060/ref=pd_bbs_1/104-8123079-7599959?%5Fencoding=UTF8 > > > actually how is this google map working...... > > like how is the data format.... > > This is an example of adding one point: > marker[0] = new GMarker( new GPoint(-119.236454, 40.754798) ); > GEvent.addListener(marker[0], "click", function() { > marker[0].openInfoWindowHtml("BMAN /CRTD 10:46 > 28-AUG-03<br>(40.754798, -119.236454)"); > }); > map.addOverlay(marker[0]); > > marker[0] means this is the first element in a javascript array. > > The GEvent.addListener is to support a clickable info window. > > > wat form is data coming in the client side......????? > > The data that you use when you want to add points to a map is in > WGS84, long, lat. > > > is it a control.........or an image ????? > > The map is made up of multiple individual images, called tiles. But > you don't really have to mess with that because the AJAX interface > does the work of fetching the right tiles for you. > > > > ajax is the work of google right...we are not implementing it..... > > Right. > > Cheers, > Rich > > > > > with regards > > hemendra > > ************************************************* > > > > Hemendra Vyas > > Senior Software Engineer, > > GISbiz Technologies Pvt. Ltd., > > 44, Eldams Road, > > Tynampaet, > > Chennai-18 > > > > > > ************************************************* > > ----- Original Message ----- > > From: "Scott Davis" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Friday, January 13, 2006 12:24 AM > > Subject: Re: [Geowanking] hii everybody > > > > > > > Hemendra, > > > > > > You understand that the Google Maps API doesn't officially support > > > overlaying external layers, right? That doesn't mean it can't be done > > > -- it just means you are firmly in "hack it, hope it works" territory. > > > > > > I've written a book on the Google Maps API available at http:// > > > www.pragmaticprogrammer.com/titles/sdgmapi . (Shameless plug: at US > > > $8.50, it's a steal!) You can also browse the examples and supporting > > > material (like Javadocs for the API) for free at http:// > > > www.mapmap.org/googlemaps/ . > > > > > > In the excellent book Mapping Hacks (O'Reilly), the authors talk > > > about pseudo-georeferencing Plain Old Image Files (POIFs??) using > > > JavaScript. You might have some luck with that if you disable panning/ > > > dragging/zooming of the Google Map. > > > > > > This link (http://www.dasnet.org/node/100) talks about one person's > > > adventures with figuring out what the real projections of the GM maps > > > are and overlaying his own data. Unfortunately, it's not as simple as > > > gmap.addMyOwnLayerToTheMap(url). > > > > > > I think what you might want is something that offers the Google Maps > > > *user experience* with the ability to add your own layers. The OGC > > > (Open Geospatial Consortium -- http://www.opengeospatial.org/) solves > > > the second part of the equation. They offer a nice rich set of APIs > > > that allow you to dynamically create maps with any set of arbitrary > > > layers. A WFS server can serve up your vector data. A WMS server can > > > render them along with any raster (imagery) data you have. > > > > > > There are a couple of good open source OGC server implementations out > > > there -- MapServer (http://mapserver.gis.umn.edu/) if you're > > > comfortable with PHP. GeoServer (http://geoserver.org) if you are > > > more comfortable with Java. > > > > > > For a great (but not cheap) commercial solution, I'd check out Ionic > > > RedSpider (http://www.ionicsoft.com/). I've worked closely with these > > > guys in the past, and they really get the OGC solution space. > > > > > > None of these offer the GoogleMaps "drag'n'drop" UI out of the box. > > > If you go with MapServer, ka-map (http://ka-map.maptools.org/) gives > > > you the rich UI. Another solution is to pick up a copy of Pragmatic > > > AJAX (http://www.pragmaticprogrammer.com/titles/ajax/) -- they have a > > > whole chapter, with sample code, on how to roll your own Google Maps > > > implementation from scratch. > > > > > > HTH, > > > s > > > > > > Scott Davis > > > [EMAIL PROTECTED] > > > > > >> Ask a generic question, get a generic answer. Perhaps a bit more > > >> explanation of your problem would facilitate communication. > > >> > > >> sophia > > >> > > >> hemendra wrote: > > >> > > >> > > >>> i have already been to this link.. > > >>> not that much use... > > >>> frst thing i m not getting is i have sdo_geometry type of column > > >>> and i > > >>> m not getting lat and long for that > > >>> but when i converted my shape file to sdo i specified 8307 SRID > > >>> hope to get some feedback > > >>> with regards > > >>> hemendra > > >>> [EMAIL PROTECTED] > > >>> > > >>> ----- Original Message ----- > > >>> > > >>> *From:* Sophia Parafina <mailto:[EMAIL PROTECTED]> > > >>> *To:* [email protected] > > >>> <mailto:[email protected]> > > >>> *Sent:* Thursday, January 12, 2006 5:50 PM > > >>> *Subject:* Re: [Geowanking] hii everybody > > >>> > > >>> http://www.orablogs.com/oragis/archives/001156.html > > >>> > > >>> > > >>> > > >>> > > > > > > > > > > > > > > > _______________________________________________ > > > Geowanking mailing list > > > [email protected] > > > http://lists.burri.to/mailman/listinfo/geowanking > > > > > > > _______________________________________________ > > Geowanking mailing list > > [email protected] > > http://lists.burri.to/mailman/listinfo/geowanking > > > _______________________________________________ > Geowanking mailing list > [email protected] > http://lists.burri.to/mailman/listinfo/geowanking > > > _______________________________________________ > Geowanking mailing list > [email protected] > http://lists.burri.to/mailman/listinfo/geowanking > _______________________________________________ Geowanking mailing list [email protected] http://lists.burri.to/mailman/listinfo/geowanking
