Viewing 15 posts - 16 through 30 (of 34 total)
Hey SPiff,
there are a few issues. First the data that was provided had an incorrect column in rowID. If you filter out Willy and 2005, you will find that it...
August 3, 2016 at 9:16 am
I will talk about the first attempt.
So the first image just combines two columns into one
UPDATE [dbo].[hurracane]
SET COORDS = [Latitude]+' '+[Longitude]
The second image combines...
August 2, 2016 at 6:46 pm
This is what I am supposed to do:
https://msdn.microsoft.com/en-us/library/ee240828.aspx#LineLayer
The example they provide works in Visual Studio without having to go through Management Studio see attached file:
SELECT N'Path' AS Name,...
August 1, 2016 at 4:41 pm
J Livingston SQL (8/1/2016)
Nusc (8/1/2016)
August 1, 2016 at 3:21 pm
I prefer to update the table in management studio. the idea is the provide as very little code in the sql query wizard for map services in SSRS.
August 1, 2016 at 2:53 pm
drew.allen (8/1/2016)
Since you are on SQL 2012, have you considered using LEAD/LAG instead of doing a self-join?Drew
No. I will look at it later but since I've gotten this far I...
August 1, 2016 at 2:51 pm
Yes I am.
THe datetime data is unique. I guess I could have done it that way.
I want to update the table with the spatial data so that when I load...
August 1, 2016 at 1:36 pm
J Livingston SQL (8/1/2016)
LEFT OUTER JOIN
hurracane b
ON
b.rowid = a.rowid + 1
AND...
August 1, 2016 at 1:17 pm
J Livingston SQL (8/1/2016)
Nusc (8/1/2016)
J Livingston SQL (8/1/2016)
suggest you change
indexid = ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [Name])to this
ROW_NUMBER() OVER(PARTITION BY NAME, YEAR ORDER BY Latitude)
I still get the...
August 1, 2016 at 11:46 am
J Livingston SQL (8/1/2016)
suggest you change
indexid = ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [Name])to this
ROW_NUMBER() OVER(PARTITION BY NAME, YEAR ORDER BY Latitude)
I still get the following error:
(88407 row(s) affected)
Msg...
August 1, 2016 at 11:34 am
why are you changing to decimals?
Because of this working example which reads in lat and long as decimal:
This is precisely what I need to do.
August 1, 2016 at 11:29 am
No. If you open the csv file and sort by year and name that's still not true.
That's something I need to fix. Furthermore, I need to change the data type...
August 1, 2016 at 10:32 am
J Livingston SQL (8/1/2016)
here is your spread sheet data for "Emily" setup for others to use.you will see that "Emily" does have a rowid of 1`......
No, not for year...
August 1, 2016 at 9:31 am
IF you don't mind saving that xlsx as a csv file and importing as a flat file source so there are no differences would be great.
Year , name, latitude, longitude,...
July 31, 2016 at 10:00 pm
Why? Just import the xlsx file. There's too many entries.
I also reuploaded the file to include headers.
July 31, 2016 at 6:20 pm
Viewing 15 posts - 16 through 30 (of 34 total)