[mapguide-users] RE: RE: RE: RE: ODBC Provider with SQL Server 2005: Doesit worksfor somebody?

pdtechguy patroam at gmail.com
Thu Feb 22 00:55:17 EST 2007


Yes that was probably a bit confusing..I remember the days when cad meant
design/drafting to me too. To answer you questions the gps data is captured
by our mobile dispatch software(gps units are trimble placer and they are
setup so they report every 50ft or 120 seconds whichever is first.) it is
then routed over our wireless IP network to a unix server which makes the
data available to our mapping software. from there I "steal"  it and feed it
into two sql tables - one for historical data and one for last known
location. the screen update is described in an earlier post.
This is not our primary map. for that we use a product called maverick
mapping. It has a mobile version as well as a dispatch version.  the latter
is pretty tightly coupled with our cad system and shows all vehicle
locations where the mobile shows only the units location it's installed in.
we do not use gps for recomendations.
My intent for Mapguide was/is a tool to replay AVL history for IA or
incident critique. Right now I'm kinda taking a break from it as I had
another project pop up that needed my attention. The next step for me is to
learn how the JS/HTML part of it works.

Pat


Brad Nesom wrote:
> 
> Ok,
>   the CAD is Computer aided dispatch. probably most of us thought you
> meant 
> computer aided drafting. That's ok it's still interesting to me. I don't 
> really need to see it or the data. just descriptions of what you did to
> make 
> the data flow work and are you displaying the points from sql serv? You
> have 
> gps data streaming into your cad via ? you load it into standard db tables 
> or sde? Then your screen update is done how?
> 
> BTW I would appreciate a contact offline. I am with a four county 911 
> agency.
> bnesomatacogokdotorg
> thanks
> 
> Well I'd love to show it to those interested but unfortunately the data
> points are Police & Fire vehicles…and I’ve got a house payment to
> make. 
> If
> someone wants the Mapguide package I’d be happy to put it on a ftp site
> somewhere. The interface would probably be of little use unless you have a
> Tiburon cad system.
> 
> Brad Nesom wrote:
>  >
>  > Very interesting. Can we hear more?
>  >
>  > -----Original Message-----
>  > From: mapguide-users-bounces at lists.osgeo.org
>  > [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of pdtechguy
>  > Sent: Tuesday, February 20, 2007 11:53 PM
>  > To: mapguide-users at lists.osgeo.org
>  > Subject: [mapguide-users] RE: RE: ODBC Provider with SQL Server 2005:
>  > Doesit
>  > worksfor somebody?
>  >
>  >
>  > What I did was really pretty simple... just not for me as I know very
>  > little
>  > about javascript or html(or maps for that matter)
>  >
>  > 1.Created the basemap with streets and such(used our county data)
>  > 2.wrote an interface to our cad system that parses out the gps data and
>  > unit
>  > info and populates the sql table(s)
>  > 3.Created a layer of points from that data (an odbc connection to a sql
>  > 2k5
>  > server)
>  >
>  > I had a lot of trouble with this part and would really like to hear
> from
>  > someone who's done it right -
>  >
>  > 4. loaded this page as the taskpane (it's narrow enough you can's see
>  > anything) it's just there for the code.
>  >
>  > <html>
>  > <head>
>  >    <title>Test App</title>
>  > </head>
>  > <script language="javascript">
>  >
>  > function reloadSpecificLayers(){
>  > parent.parent.Refresh();
>  > }
>  >
>  > </script>
>  > <script language="javascript">
>  >
>  > var initTimer = setInterval(reloadSpecificLayers, 10000);
>  > </script>
>  >
>  > </body>
>  > </html>
>  >
>  > IAs a whole it work great - much much better than I thought it would.
> The
>  > ajax client seems pretty intelligent and the refresh is imperceptible
>  > except
>  > that the points move.
>  >
>  > Hope this helps.
>  >
>  > Pat
>  >
>  >
>  >
>  >
>  > ctallman wrote:
>  >>
>  >> pdtechguy,
>  >>
>  >> I would be interested in seeing what you have done and how.  I'm
> working
>  >> on an application similar to this.  Anything you are willing to share
>  >> would be very helpful.
>  >>
>  >> Chris
>  >>
>  >> ________________________________
>  >>
>  >> From: mapguide-users-bounces at lists.osgeo.org
>  >> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Andrew
>  >> DeMerchant
>  >> Sent: Friday, February 16, 2007 8:03 AM
>  >> To: MapGuide Users Mail List
>  >> Subject: Re: [mapguide-users] RE: ODBC Provider with SQL Server 2005:
>  >> Doesit worksfor somebody?
>  >>
>  >>
>  >> Moving points, as in the locations move frequently? Do you have it set
>  >> up to refresh the points layer automatically?
>  >>
>  >> Andrew
>  >>
>  >>
>  >> pdtechguy wrote:
>  >>
>  >> 	It works very good for an avl map that I created as a tech demo.
>  >> It's is
>  >> 	displaying 30'ish moving points on a street level tiled base map
>  >> of our
>  >> 	county. Be happy to share any info you'd like.
>  >>
>  >> 	BTW thanks to all who participate in this project.
>  >>
>  >> 	Here is the sql table that contains the points I am using:
>  >>
>  >> 	USE [AVL_CAD]
>  >> 	GO
>  >> 	/****** Object:  Table [dbo].[avl_last_known]    Script Date:
>  >> 02/13/2007
>  >> 	22:26:43 ******/
>  >> 	SET ANSI_NULLS ON
>  >> 	GO
>  >> 	SET QUOTED_IDENTIFIER ON
>  >> 	GO
>  >> 	CREATE TABLE [dbo].[avl_last_known](
>  >> 		[servertimestamp] [datetime] NULL,
>  >> 		[cadunit1] [text] COLLATE SQL_Latin1_General_CP1_CI_AS
>  >> NULL,
>  >> 		[cadunit2] [text] COLLATE SQL_Latin1_General_CP1_CI_AS
>  >> NULL,
>  >> 		[caduser] [text] COLLATE SQL_Latin1_General_CP1_CI_AS
>  >> NULL,
>  >> 		[gpstimeofday] [text] COLLATE
>  >> SQL_Latin1_General_CP1_CI_AS NULL,
>  >> 		[lattitude] [float] NULL,
>  >> 		[longitude] [float] NULL,
>  >> 		[speed] [text] COLLATE SQL_Latin1_General_CP1_CI_AS
>  >> NULL,
>  >> 		[heading] [text] COLLATE SQL_Latin1_General_CP1_CI_AS
>  >> NULL,
>  >> 		[sourceofdata] [text] COLLATE
>  >> SQL_Latin1_General_CP1_CI_AS NULL,
>  >> 		[ageofdata] [text] COLLATE SQL_Latin1_General_CP1_CI_AS
>  >> NULL
>  >> 	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
>  >>
>  >>
>  >>
>  >>
>  >> 	FGoulet wrote:
>  >>
>  >>
>  >> 		Sure,
>  >>
>  >> 		Here's the script:
>  >>
>  >> 		USE [DredgingRegister]
>  >> 		GO
>  >> 		/****** Object:  Table [dbo].[Dredging_Activity]
>  >> Script Date:
>  >> 		01/31/2007 14:53:46 ******/
>  >> 		SET ANSI_NULLS ON
>  >> 		GO
>  >> 		SET QUOTED_IDENTIFIER ON
>  >> 		GO
>  >> 		CREATE TABLE [dbo].[Dredging_Activity](
>  >> 			[Activity_ID] [int] IDENTITY(1,1) NOT NULL,
>  >> 			[UserName] [nvarchar](256) COLLATE
>  >> SQL_Latin1_General_CP1_CI_AS NULL,
>  >> 			[Location_FR] [nvarchar](32) COLLATE
>  >> SQL_Latin1_General_CP1_CI_AS NULL,
>  >> 			[Location_EN] [nvarchar](32) COLLATE
>  >> SQL_Latin1_General_CP1_CI_AS NULL,
>  >> 			[Description_FR] [nvarchar](32) COLLATE
>  >> SQL_Latin1_General_CP1_CI_AS
>  >> 		NULL,
>  >> 			[Description_EN] [nvarchar](32) COLLATE
>  >> SQL_Latin1_General_CP1_CI_AS
>  >> 		NULL,
>  >> 			[Start_Date] [datetime] NULL,
>  >> 			[Finish_Date] [datetime] NULL,
>  >> 			[Dredging_Type_CD] [int] NULL,
>  >> 			[Material_Quantity] [numeric](9, 3) NULL,
>  >> 			[Material_Disposal] [nchar](10) COLLATE
>  >> SQL_Latin1_General_CP1_CI_AS
>  >> 		NULL,
>  >> 			[Longitude] [float] NULL,
>  >> 			[Latitude] [float] NULL,
>  >> 			[Registration_Date] [datetime] NULL,
>  >> 			[Approved] [bit] NULL,
>  >> 			[Proponent_ID] [int] NULL,
>  >> 			[Responsible_ID] [int] NULL,
>  >> 		 CONSTRAINT [PK_Dredging_Activity] PRIMARY KEY CLUSTERED
>  >>
>  >> 		(
>  >> 			[Activity_ID] ASC
>  >> 		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON
>  >> [PRIMARY]
>  >> 		) ON [PRIMARY]
>  >>
>  >> 		GO
>  >> 		ALTER TABLE [dbo].[Dredging_Activity]  WITH CHECK ADD
>  >> CONSTRAINT
>  >> 		[FK_Dredging_Activity_Contact] FOREIGN
>  >> KEY([Responsible_ID])
>  >> 		REFERENCES [dbo].[Contact] ([Contact_ID])
>  >> 		GO
>  >> 		ALTER TABLE [dbo].[Dredging_Activity] CHECK CONSTRAINT
>  >> 		[FK_Dredging_Activity_Contact]
>  >> 		GO
>  >> 		ALTER TABLE [dbo].[Dredging_Activity]  WITH CHECK ADD
>  >> CONSTRAINT
>  >> 		[FK_Dredging_Activity_Dredging_Type] FOREIGN
>  >> KEY([Dredging_Type_CD])
>  >> 		REFERENCES [dbo].[Dredging_Type] ([Dredging_Type_CD])
>  >> 		GO
>  >> 		ALTER TABLE [dbo].[Dredging_Activity] CHECK CONSTRAINT
>  >> 		[FK_Dredging_Activity_Dredging_Type]
>  >> 		GO
>  >> 		ALTER TABLE [dbo].[Dredging_Activity]  WITH CHECK ADD
>  >> CONSTRAINT
>  >> 		[FK_Dredging_Activity_Proponent] FOREIGN
>  >> KEY([Proponent_ID])
>  >> 		REFERENCES [dbo].[Proponent] ([Proponent_ID])
>  >> 		GO
>  >> 		ALTER TABLE [dbo].[Dredging_Activity] CHECK CONSTRAINT
>  >> 		[FK_Dredging_Activity_Proponent]
>  >>
>  >>
>  >> 		The columns mapped to X and Y in MG Studio are Longitude
>  >> and Latitude. I
>  >> 		tried with  others numeric type (real, decimal, numeric)
>  >> and I always get
>  >> 		that error.
>  >>
>  >>
>  >> 		Thanks
>  >>
>  >>
>  >>
>  >>
>  >> 		JasonBirch wrote:
>  >>
>  >>
>  >> 			Frederic wrote:
>  >>
>  >> 			        An exception occurred in FDO component.
>  >> 			        RDBMS: Incompatible column type
>  >>
>  >> 			Care to share the table definition?  The problem
>  >> with ODBC is that it's
>  >> 			not generic enough :)
>  >>
>  >> 			Jason
>  >>
>  >>
>  >>
>  >> 			_______________________________________________
>  >> 			mapguide-users mailing list
>  >> 			mapguide-users at lists.osgeo.org
>  >>
>  >> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>  >>
>  >>
>  >>
>  >>
>  >>
>  >>
>  >>
>  >>
>  >>
>  >>
>  >> --
>  >>
>  >>
>  >> Andrew DeMerchant
>  >> Computer Technologist
>  >> ph.1-877-2GEMTEC x.163
>  >> fax 506-453-9470
>  >>
>  >>
>  >> GEMTEC Limited <http://www.gemtec.ca>
>  >> 191 Doak Road
>  >> Fredericton, NB, Canada
>  >> E3C 2E6
>  >>
>  >>
>  >>
>  >> _______________________________________________
>  >> mapguide-users mailing list
>  >> mapguide-users at lists.osgeo.org
>  >> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>  >>
>  >>
>  >
>  > --
>  > View this message in context:
>  > 
> http://www.nabble.com/ODBC-Provider-with-SQL-Server-2005%3A-Does-it-works-fo
>  > r-somebody--tf3144880s16610.html#a9075760
>  > Sent from the MapGuide Users mailing list archive at Nabble.com.
>  >
>  > _______________________________________________
>  > mapguide-users mailing list
>  > mapguide-users at lists.osgeo.org
>  > http://lists.osgeo.org/mailman/listinfo/mapguide-users
>  >
>  > _______________________________________________
>  > mapguide-users mailing list
>  > mapguide-users at lists.osgeo.org
>  > http://lists.osgeo.org/mailman/listinfo/mapguide-users
>  >
>  >
> 
> --
> View this message in context: 
> http://www.nabble.com/ODBC-Provider-with-SQL-Server-2005%3A-Does-it-works-for-somebody--tf3144880s16610.html#a9093035
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> _________________________________________________________________
> Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a
> month. 
> Intro*Terms  http://www.NexTag.com
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/ODBC-Provider-with-SQL-Server-2005%3A-Does-it-works-for-somebody--tf3144880s16610.html#a9094851
Sent from the MapGuide Users mailing list archive at Nabble.com.



More information about the mapguide-users mailing list