|
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.
|
|
Please pardon my ignorance in Spatial area.
With the help of this thread , I was able to convert a table with column definitions from :
Latitude(decimal(12,6), longitude(12,6) and Elevation(int) To Geography data type:
ALTER TABLE YourTable
ADD geog geography...
Answer Snippets (Read the full thread at microsoft):
The geometry datatype the geography and geometry datatype - it's a hardcoded limit as to the number of elements that can be placed with geography....
Geographic data, and the geography datatype is the correct datatype to use.
|
|
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.
|
Ask your Facebook Friends
|
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 .
|
|
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 .
|
|
Hi
Has any one know a way to use nHibernate with database tables that coontains ESRI's st_geometry columns?
This corrently prevents us the usage with nHibernate in our applications.
Thanks
Answer Snippets (Read the full thread at stackoverflow):
NHibernate.Spatial uses GeoAPI and NTS NetTopologySuite too as Cherian stated .
I successfully used nHibernate.Spatial with SQL Server 2008 and geometry/geography columns.
To work with those columns.
|
