|
I'm creating a Google map mashup and am using SQL 2008.
I will have a large number of points on the earth and will want to perform various calculations on them in SQL - such as selecting all points contained within a particular polygone, or select all...
Started by Mr. Flibble on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The ....
Geometry should I use geometry or geography?
Short Answer: geography is a new data type that supports long range is not.
Most likely you want the geography type since it accounts for the curvature of the earth.
|
|
Hi there,
i'm currently working on a project where i have to deal with sql server 2008 geography types. As big parts of the projects uses NHibernate as ORM i wonder how much work it will be to use/extend NHibernate.Spatial with this type (as far as i ...
Started by Joachim Kerschbaumer on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
So basically, the answer: No NHSpatial doesn't support Geography, but you can use Geometry types is that you have....
Check the thread at NHUsers below, you can 'sort of' use Geometry in SQL.
Limited support for geography types.
|
|
I am using sql express 2008 and vs2008, writing in c#.
I have a db table with a Geography column in it, into which I need to put gps data I collected. When I tried creating an Entity-Framework mapping for this table, it just ignored the column with some...
Answer Snippets (Read the full thread at stackoverflow):
I've successfully used this to create a type for that uses XmlSerialization to an Xml field, based on ... .
There's a bit about it on Ray Houston's Blog.
I don't know much about EF, but NHibernate allows you to extend it's type framework using IUserType .
|
Ask your Facebook Friends
|
I am trying to build a query, but I am having some difficulty.
I have a SQL Server 2008 database with a table that includes, among other fields, a geography field that describes road segments. (This data has been imported from TIGER/Line data from the...
Started by David Pfeffer on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Instead, you'll have to make a query similar to this:
DECLARE @mypoint GEOGRAPHY SET @mypoint = geography::STGeomFromText('....
You can store your objects in a GEOGRAPHY column and create a SPATIAL INDEX over this column the index).
|
|
So, Linq does not support the Geography data type, which throws a major spanner in the works in the lovely 'drag table onto the Linq design surface' developemnt model.
Is there any way that I can extend Linq to work with the Geography datatype? Or will...
Started by Mr. Flibble on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
As I know, this is the only working solution if you need to work with any CLR type, including geography, geometry, hierarchyid, and any custom types - Linq doesn't "natively" support any of them.
|
|
Hi there,
today i ran into a possible size limitation of geography type Linestrings within Sql Server 2008. when i create a Linestring with STGeomFromText that contains 567 points containing Long,Lat and Z coordinates, everything works fine.
However, ...
Started by Joachim Kerschbaumer on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
However, i can select the geometry and display....
This might be worth a try:
...able to get the geometry to convert to a geography using the following cannot be read into a geography type, but it works using geometry type.
|
|
I am trying to use Nhibernate with the Sql 2008 Geography type and am having difficulty. I am using Fluent Nhibernate to configure which I am fairly new to so that may be the problem as well.
First, the class I am trying to persist looks something like...
Started by lfoust on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
0 is not a valid SRID ....
On the GisSharpBlog.NetTopologySuite.Geometries.Point object? The default (since the point is a geometry) is 0 and will give you a SQL error when trying to persist the LocationLog.Location property as a geography.
|
|
I've got an existing advanced search method in a repository that checks a FormCollection for the existence of search criteria, and if present, adds a criterion to the search e.g.
public IList<Residence> GetForAdvancedSearch(FormCollection collection...
Started by harriyott on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The alternative is to create your own implementation of ICriterion - this is not too tricky if you derive from AbstractCriterion and you target your particular... .
Have you seen the NHibernate.Spatial project ? This may provide an easy solution to your problem .
|
|
I'm playing with the new geography column in SQL Server 2008 and the STGeomFromText function. Here is my code (works with AdventureWorks2008)
DECLARE @region geography; set @region = geography::STGeomFromText('POLYGON(( -80.0 50.0, -90.0 50.0, -90.0 2...
Started by Chris Brandsma on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The problem is that the earth is not a perfect sphere (it bulges in the middle), and SRID .
geography.
|
|
My dd is sick of history and wants to do something different. She's done very well in Alg I & Phys Science (96 avg in both). I've watched her interests change a lot and her skills improve with more maturity. Science & math are now favorite classes for...
Started by Jen the RD on
, 8 posts
by 5 people.
Answer Snippets (Read the full thread at welltrainedmind):
Though we've always integrated geography into....
I find that it's interesting that CU Boulder *requires* geography.
Also CU Boulder expects to see 1 semester of geography on transcript, solid school).
Science and is a 9th grade class.
|
