Geographic Information Systems Weekly Newsletter - Tuesday, September 30, 2014

Top new questions this week: Using Label classes vs Definition queries - which performs the best? Which would provide the best performance for working within ArcMap with very large datasets stored in an ArcSDE geodatabase? Multiple label classes using complex SQL queries to label specific … arcgis-desktop labeling performance definition-query   asked by ian 7 votes answered by Craig Williams 1 vote GIS analysis to find duplicate geometries I have a big shapefile that contains all the buildings and houses of the town that I work in (approx. 90,000 features). The data of the buildings/houses are saved by the town's surveying engineers and … qgis arcgis-desktop shapefile sql analysis   asked by AmmarSh 6 votes answered by Aaron 3 votes What is the Pick tool in ArcGIS's Spatial Analyst commonly used for? I have recently encountered the Pick tool in the Spatial Analyst of ArcGIS. I understand what the tool does; it creates an output raster using a list of input rasters and a 'position' raster which … arcgis-desktop spatial-analyst conditional   asked by WhiteboxDev 6 votes answered by whuber 2 votes Can PostGIS and QGIS provide dependable multi-user editing? After considering a few options, I'm trying to give my 15-20 QGIS 2.2 users the ability to concurrently view/edit one or two basic point PostGIS layers, largest one has just 16,000 records. I've … qgis postgis postgresql qgis-2.0 editing   asked by mike 6 votes answered by Paul Ramsey 2 votes Good Things To Highlight About GIS on a Company Website? I'm in the process for creating the GIS content for our new company website. So far, I am having some serious issues. GIS is a complicated subject. First off, most people coming to our website won't … web   asked by Cody Brown 6 votes Do I need ArcGIS for server to edit my MS SQL Server database? Here is what I have: ArcGIS Desktop Advanced (10.2) & MS SQL Server 2008 R2 Here is my problem: I need to be able to connect to the ms sql server and import, export, create, and edit spatial … arcgis-desktop arcgis-server sql-server   asked by Brain 5 votes answered by Alex Tereshenkov 2 votes How do I extract partial data from one field to another? Answer Below I am attempting to extract a date stamp that is contained in one field and insert it into another field. The issue is that the date (in bold below) is not in the same location in each … field-calculator table fields   asked by T.Holland 5 votes answered by Dan C 6 votes Greatest hits from previous weeks: What's the difference between a projection and a datum? What's the difference between a projection and a datum? projection datum definitions introductory-level theory   asked by fmark 126 votes answered by wwnick 84 votes What ratio scales do Google Maps zoom levels correspond to? Can anyone provide me with a link (or some details) on the actual ratio to "zoom level" figures for Google Maps? e.g. Google Maps Level 13 = 1:20000 google-maps scale zoom   asked by mlo55 27 votes answered by CaptDragon 24 votes Can you answer these? Convert KML to an Attribute table So I was wondering if it's possible to convert the KML files to an CSV attribute table (of those geometric features). So I've found this code that converts the KML to CSV, but really just prints the … kml attribute-table   asked by santoznma 3 votes How to use real time data (traffic) for network analyst in ArcGIS? I have a problem with using traffic data for routing. I'll describe the scenario: There is a local traffic service (real time) that has the speed of each segment in the network. This information is … arcgis-10.1 arcgis-server network-analyst real-time traffic   asked by wetland 3 votes How to determine the optimal raster resolution when interpolating a surface from points? I'm looking for guidance on how to determine the desired output resolution, when interpolating a surface from irregularly-spaced point samples. I have a series of boreholes taken across a city, and … raster interpolation grids spatial-interpolation   asked by Stephen Lead 4 votes

Subscribe to more Stack Exchange newsletters Unsubscribe from this newsletter or change your email preferences by visiting your subscriptions page on stackexchange.com. Questions? Comments? Let us know on our feedback site. If you no longer want to receive mail from Stack Exchange, unsubscribe from all stackexchange.com emails. Stack Exchange, Inc. 110 William St, 28th Floor, NY NY 10038 <3