Search Results

Search found 91 results on 4 pages for 'geography'.

Page 2/4 | < Previous Page | 1 2 3 4  | Next Page >

• How can I split a LINESTRING into two LINESTRINGs at a given point?

  - by sabbour

  Hello, I'm trying to write a function that will split a LINESTRING into two LINESTRINGs given the split point. What I'm trying to achieve is a function that given a LINESTRING and a distance, it will return N LINESTRINGS for the original linestring splitted at multiples of that distance. This is what I have so far (I'm using SQL Server Spatial…

  Read the article

• jQuery "Autcomplete" plugin is messing up the order of my data

  - by Max Williams

  I'm using Jorn Zaefferer's Autocomplete plugin on a couple of different pages. In both instances, the order of displayed strings is a little bit messed up. Example 1: array of strings: basically they are in alphabetical order except for General Knowledge which has been pushed to the top: General Knowledge,Art and Design,Business…

  Read the article

• SQL Spatial: Getting “nearest” calculations working properly

  - by Rob Farley

  If you’ve ever done spatial work with SQL Server, I hope you’ve come across the ‘nearest’ problem. You have five thousand stores around the world, and you want to identify the one that’s closest to a particular place. Maybe you want the store closest to the LobsterPot office in Adelaide, at -34.925806, 138.605073. Or our new US…

  Read the article

• jQuery "Autocomplete" plugin is messing up the order of my data

  - by Max Williams

  I'm using Jorn Zaefferer's Autocomplete plugin on a couple of different pages. In both instances, the order of displayed strings is a little bit messed up. Example 1: array of strings: basically they are in alphabetical order except for General Knowledge which has been pushed to the top: General Knowledge,Art and…

  Read the article

• How can I set PivotField.Calculation in Excel/VSTO?

  - by Kang Su

  I'm trying to set the Calculation property on an OLAP PivotField with VSTO 3.0. For example: pivotField.Calculation = XlPivotFieldCalculation.PercentOf; If I do the above, the value I assign does not stay (Excel appears to revert the change). I suspect the reason is that the BaseField property of the PivotField…

  Read the article

• Filtering documents against a dictionary key in MongoDB

  - by Thomas

  I have a collection of articles in MongoDB that has the following structure: { 'category': 'Legislature', 'updated': datetime.datetime(2010, 3, 19, 15, 32, 22, 107000), 'byline': None, 'tags': { 'party': ['Peter Hoekstra', 'Virg Bernero', 'Alma Smith', 'Mike Bouchard', 'Tom George',…

  Read the article

• Wordpress and Dynamic Programming Php

  - by user1675146

  I have geography pages for two types of business listings. Each page goes from state, county, city, but I need to have the same geography shared between two types of business. My two business types are dentist and chiropractors. I am trying to have a permalink structure like this: enter code here…

  Read the article

• Can I split a single SQL 2008 DB Table into multiple filegroups, based on a discriminator column?

  - by Pure.Krome

  Hi folks, I've got a SQL Server 2008 R2 database which has a number of tables. Two of these tables contains a lot of large data .. mainly because one of them is VARBINARY(MAX) and the sister table is GEOGRAPHY. (Why two tables? Read Below if you're interested***) The data in these tables are…

  Read the article

• SQL Server 2012 : Changes to system objects in RC0

  - by AaronBertrand

  As with every new major milestone, one of the first things I do is check out what has changed under the covers. Since RC0 was released yesterday, I've been poking around at some of the DMV and other system changes. Here is what I have noticed: New objects in RC0 that weren't in CTP3 Quick…

  Read the article

• The need for user-defined index types

  - by Greg Low

  Since the removal of the 8KB limit on serialization, the ability to define new data types using SQL CLR integration is now almost at a usable level, apart from one key omission: indexes. We have no ability to create our own types of index to support our data types. As a good example of…

  Read the article

• Behind the Code: The Analytics Mobile SDK

  Behind the Code: The Analytics Mobile SDK The new Google Analytics Mobile SDK empowers Android and iOS developers to effectively collect user engagement data from their applications to measure active user counts, user geography, new feature adoption and many other useful metrics. Join…

  Read the article

• T-SQL Tuesday #006 Round-up!

  - by Mike C

  T-SQL Tuesday this month was all about LOB (large object) data. Thanks to all the great bloggers out there who participated! The participants this month posted some very impressive articles with information running the gamut from Reporting Services to SQL Server spatial data types to…

  Read the article

• Achieve Spatial Data Support in SSIS

  Overview SQL Server 2008 introduced a new category of datatypes known as spatial datatypes which stores spatial information. The new spatial datatypes are geography and geometry. SQL Server Management Studio comes with good good support for these spatial data ... [Read Full Article]

  Read the article

• How to find the longitude and latitude of a location

  - by simonsabin

  Just found this really simple but very useful site to give you the latitude and longitude of a location http://www.getlatlon.com/ The great thing is that you can select from a map and it also gives you the WKT you can use to generate you geography in SQL Server. This is the location…

  Read the article

• SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spati

  - by pinaldave

  What is Spatial Database? A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs…

  Read the article

• Excel export displaying '#####...'

  - by Cypher

  I'm trying to export an Excel database into .txt (Tab Delimited), but some of my cells are quite large. When I export into a txt some of the cells are exported as '#######....' which is surprisingly useless. Has this happened to anyone else? Do you know an easy fix? Data from one…

  Read the article

• How to use MySQL geospatial extensions with spherical geometries

  - by Joshua

  Hi Everyone, I would like to store thousands of latitude/longitude points in a MySQL db. I was successful at setting up the tables and adding the data using the geospatial extensions where the column 'coord' is a Point(lat, lng). Problem: I want to quickly find the 'N'…

  Read the article

• Setting Up a Wordpress Function in theme's function.php File

  - by user1609391

  I am trying to create the below function in my theme's function.php file and call it from my taxonomy.php file via query_brands_geo('dealers', 'publish', '1', $taxtype, $geo, $brands); all variables are set in taxonomy.php. The below query works perfect if I put it…

  Read the article

• Desine time XAML serialization problem in VS2010 Designer

  - by Reporting Avatar

  The wired problem is, in VS 2008, everything works fine. In VS2010 while serializing, it is missing the "ReportDimensionElements" so I'm unable to get the values back from the serialized value back from the XAML. It says, "'ReportDimensionElements' is null" am I missing…

  Read the article

• WebLogic Server Virtual Developer Day and Upcoming Developer Webcasts

  - by james.bayer

  We have a series of Virtual Developer Days for WebLogic for different geographies coming up as well as developer-oriented webcasts focusing on building a sample application with popular modern technologies.  The first one is Feb 1st, 2011 for North America, but…

  Read the article

• SQL Azure maximum database size rises from 10GB to 50GB in June

  - by Eric Nelson

  At Mix we announced that we will be offering a new 50gb size option in June. If you would like to become an early adopter of this new size option before generally available, send an email to EngageSA@microsoft.com  and it will auto-reply with instructions to…

  Read the article

• New Procurement Report for Transportation Sourcing

  - by John Murphy

  Welcome to our fourth annual transportation procurement benchmark report. American Shipper, in partnership with the Council of Supply Chain Management Professionals (CSCMP) and the Retail Industry Leaders Association (RILA), surveyed roughly 275…

  Read the article

• Linq To Sql Concat() dropping fields in created TSQL

  - by user191468

  This is strange. I am moving a stored proc to a service. The TSQL unions multiple selects. To replicate this I created multiple queries resulting in a common new concrete type. Then I issue a return result.ToString(); and the resulting SQL selects have…

  Read the article

• Treeview inside DropDown in ASP.NET

  - by Pravin Kumar

  I have a hierarchial data ( like Geography -- Area- Country - State ) which need to be shown in a Treeview. This was done but the problem is it is occupying toooo much space on the web page. So i thought of using a drop down that would hold a treeview…

  Read the article

• Create a user-defined aggregate without SQL CLR

  - by David Pfeffer

  I am planning on deploying a database to SQL Azure, so I cannot use the SQL CLR. However, I have a need to create an aggregate function -- in my case, I need to STUnion a bunch of Geography objects together. (Azure is expected to support Spatial by…

  Read the article

< Previous Page | 1 2 3 4  | Next Page >