tag:blogger.com,1999:blog-8198098748055412162024-03-12T19:05:06.758-04:00GeographygeekBlog about GIS, maps, and other geographical things.geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-819809874805541216.post-18670430185689657162011-03-07T15:20:00.001-05:002011-03-07T15:28:00.208-05:00ArcSDE error: Cannot insert duplicate key row in object<p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;" lang="EN-CA">I am at my wits' end on this error message.</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;" lang="EN-CA">-I am trying to update a ‘NAME’ field in ‘CONTENT_POINTS’ SDE Feature Class</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;" lang="EN-CA">-I’ve used Attribute Creator to create a fme_db_operation = UPDATE</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;" lang="EN-CA">-Update Key Fields in Feature Type Properties>Parameters is set to NAME</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;" lang="EN-CA">-</span></span><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;">ArcSDE Mode Of Operation is UPDATE</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;">Error:</span></span></p> <p class="MsoNormal"><span style="font-size:78%;color:black;"><span style="font-family: 'Courier New'; color: black; font-size: 9pt;">Error while executing stream update operation for table 'PROFILING.CONTENT_POINTS'.:SDE_ERROR_CODE(-51) Underlying DBMS error. SDE_EXT_ERROR(2601) SDE_ERROR_MSG1(Microsoft SQL Native Client: Cannot insert duplicate key row in object 'PROFILING.CONTENT_POINTS' with unique index 'CID'.) SDE_EXT_ERROR_MSG2()</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;"> If I understand this correctly it is saying that I am trying to insert a duplicate key row in the CONTENT_POINTS featureclass.</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;">‘CID’ is the unique ID</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;"> I am trying to update, not insert, and so of course there will be the same ‘CID’ because that is the unique ID I am using to update the NAME field with the new NAME form the source file.</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;"> I have tried what feels like a million different things to do what should be simple, something I have done many times before.</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;"> </span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;">Any suggestions or help would be greatly appreciated.</span></span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="font-family: Arial; font-size: 10pt;">Thanks</span></span></p>Anonymousnoreply@blogger.com3tag:blogger.com,1999:blog-819809874805541216.post-75992212357668965262010-03-07T11:54:00.000-05:002010-03-07T11:54:06.112-05:00Spatial Views and SDE - VersioningRecently, I've been looking into versioning an SDE database. The issue I have is that in my workflow, I need to have spatial views. In the past, we have been told from ESRI that spatial views will not work with a versioned database. <br />
<br />
It seems that the real truth to this matter is that spatial views WILL work with a versioned database BUT the spatial view will only read the base tables (not the delta tables that have not been reconciled with the database). <br />
<br />
I think this will work for my needs. Once I have implemented a workflow that works, I will be happy to share the details of my experience.<br />
<br />
I also recently attended an ESRI training on Multiuser Geodatabases. I wish the course had more information on versioning because this is the next project that I'm excited about. I think there is another Multiuser Geodatabase course offered that goes into more detail about versioning. I'm looking forward to the upcoming challenges. <br />
<br />
If you have successfully implemented a versioned database with spatial views, please contact me!geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-7369148275343807952009-07-28T13:38:00.006-04:002009-07-28T13:57:34.345-04:00GIS CareersI just came back from doing a delightful presentation on GIS and Careers, what to watch for, how to develop a career, etc. to an enthusiatic group of interns. I've uploaded the presentation below so be sure to take a look at it. It has a lot of information that would be useful for both new GIS professionals and for those that have been in the field for longer. <br /><br /><object codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" id="doc_624266726229771" name="doc_624266726229771" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" align="middle" height="500" width="450" > <param name="movie" value="http://d.scribd.com/ScribdViewer.swf?document_id=17749715&access_key=key-4vbt95v8pydqbwigsy1&page=1&version=1&viewMode=slideshow"> <param name="quality" value="high"> <param name="play" value="true"> <param name="loop" value="true"> <param name="scale" value="showall"> <param name="wmode" value="opaque"> <param name="devicefont" value="false"> <param name="bgcolor" value="#ffffff"> <param name="menu" value="true"> <param name="allowFullScreen" value="true"> <param name="allowScriptAccess" value="always"> <param name="salign" value=""> <param name="mode" value="slideshow"> <embed src="http://d.scribd.com/ScribdViewer.swf?document_id=17749715&access_key=key-4vbt95v8pydqbwigsy1&page=1&version=1&viewMode=slideshow" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" play="true" loop="true" scale="showall" wmode="opaque" devicefont="false" bgcolor="#ffffff" name="doc_624266726229771_object" menu="true" allowfullscreen="true" allowscriptaccess="always" salign="" type="application/x-shockwave-flash" align="middle" mode="slideshow" height="500" width="450"></embed> </object>geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com2tag:blogger.com,1999:blog-819809874805541216.post-22606692872985735782009-07-22T13:09:00.002-04:002009-07-23T15:37:57.580-04:00Career Development - GISI was asked to do a presentation on GIS and careers, etc. for a group of interns. Having never done this type of a presentation before, I wanted to make sure not to bore them to death and to include content that would allow them to know what's happening in the industry. I've decided to focus more on the GIS industry, who to follow, what to read and how to keep skills updated instead of "how to find a job" or "what's required in a GIS job".<br /><br />I look forward to posting how this disucssion goes. I've compiled a list of slides that I'll post next week after the presentation.geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-51608588116950003042009-07-10T18:45:00.001-04:002009-07-10T18:46:24.271-04:00I'm still here - slowly down for the summerThe summer months have triggered my extreme laziness. I will try to keep updating as regularly as possible but I hope to get back into full force in September.<br /><br />Thanks for dropping by!geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-58090704702562106112009-05-30T21:35:00.000-04:002009-05-30T21:36:07.112-04:00ESRI Spatial Statistics - Six tests to perform on OLS resultsI've been quite busy lately - so I haven't had time to post. I hope that this review of spatial statistics will make up for my recent absenteeism!<br /><br />Earlier this week, I attended a Spatial Statistics seminar hosted by ESRI. What I expected to be a veiled attempt to get users to buy more ESRI extensions was really a review of functions already readily available in ArcView. I was pleasantly surprised and felt that the seminar was worthwhile.<br /><br />Dr. Lauren Scott was the speaker. She works for ESRI Redlands and has a passion for spatial statistics. It's always refreshing to hear a speaker who has a passion for what she does.<br /><br />The core spatial tools that were presented were the standard deviation ellipse, hot spot analysis and regression. Most of the seminar focused on spatial regression including ordinary least square (OLS) and geographical weighted regression.<br /><br />Dr. Scott went over the six quick tests to perform to know if your OLS model is complete; that is, if the model is explaining the dependant variable in the most effective way possible. Once you perform OLS on a variable, these are the six things to examine.<br /><br />a) coefficients have the correct sign. If the relationship between the explanatory variable and the dependant variable is positive, the coefficient for that explanatory variable should be positive in the final results table. If it is not, the results should be checked.<br /><br />b) all variables are statistically significant (both probability and robust probability). If the variables are not statistically significant, they should be removed from the analysis because they are not working to explain the dependant variable. The Koenker (BP) test should be significant - this will mean that geographically weighted regression can be performed on the data.<br /><br />c) the VIF should be below 7.5. If VIF is above 7.5, this means that some of the explanatory variables are redundant and there could be variables that are being double counted in the analysis. The lower the VIF, the better.<br /><br />d) the adjusted R2 should be high (the closer to one the better), the AIC should be low (the AIC allows multiple models that have the same dependent variable to be compared to one another - if you have two models that for the same dependent variable, the one with the lower AIC is the better model).<br /><br />e) Jarques-Bera test should NOT be statistically significant. If this value is statistically significant, you are missing an explanatory variable in the analysis.<br /><br />f) the residuals from the regression should have a random distribution. The more clustered these variables, the poorer the model. Clustered residuals point to explanatory variables that are missing in the analysis.geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-3530855707890684602009-05-27T22:03:00.003-04:002009-05-27T22:25:48.984-04:00ESRI Spatial Statistic (Toronto)Lauren from Redland ESRI has done a great job today by providing easy to understand presentation with the hardest thing to explain in the world. Highly recommend to view the spatial statistic tool that they implement for 9.3 (<a href="http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=An_overview_of_the_Spatial_Statistics_toolbox">ArcGIS 9.3 Online help</a>)<br /><br />GIS can widely use by other field such as Crime (Pocket Men Analysis - to see the pattern of the criminal and provide general area where they will commit the crime), and Health(Try to find out the pattern of disease that spread in the study area) and much more other fields that I would like to explore to. Demonstration in the presentation has open my mind to others in the GIS field how they use the tool smartly :) Can't wait to view the presentation video again!Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-85719173863794658522009-05-12T10:32:00.001-04:002009-05-12T10:32:46.921-04:00US police chief leads way on new software<p>As some of you may know, I’m a big crime buff and I love seeing GIS used to aid law enforcement. I watch cop dramas on television and hope to see a glimpse of GIS used to help solve a big caper.</p> <p>Police in Edinburgh have received some help from Jim Bueermann, the chief of Redlands Police in California to look at how GIS can be used to find crime hotspots. This will help Edinburgh police focus resources on this area. </p> <p>I’ve contacted my local police department and I’m hoping to gain further insights on how GIS is used in policing. Watch this blog for further updates of my personal quest!</p> <p><a href="http://edinburghnews.scotsman.com/edinburgh/US-police-chief-leads-way.5256802.jp">US police chief leads way on new software - Edinburgh Evening News</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-34444185325431909012009-05-05T09:49:00.001-04:002009-05-05T09:54:41.588-04:00ZoomProspector – Business Location Tool<p>ZoomProspector is a site devoted to aiding businesses in determining site selection for relocation or expansion and helping start-ups find properties. </p> <p>The site is easy to use and free so it’s a very valuable research tool. As a user, the business would define the information that is important to them (general location, size of market, characteristics of property, labour force information, etc). </p> <p>When I typed in Cincinnati, Ohio, I was given a map of the location (of course) in addition to some basic demographics about the area including population, labour force activity, and income information. However, the site also provided information about entrepreneurs and innovation (number of patents, venture captial, etc) which could be very important to a start up. Finally, there is information about transportation and travel times. All of these parameters can also be specified in the initial search for a location.</p> <p><a href="http://lh5.ggpht.com/_SBlR7NK9Cwo/SgBFHoFyeyI/AAAAAAAAACU/yxAuJvCOlpA/s1600-h/image%5B3%5D.png"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/_SBlR7NK9Cwo/SgBFHwZCA-I/AAAAAAAAACY/SSII-9XL4-A/image_thumb%5B1%5D.png?imgmax=800" width="385" height="368" /></a> </p> <p>Once a location has been selected, I viewed properties for sale in the area and there were many options to choose from, make the tool flexible and comprehensive. I found a building available for lease on Vine Street and was able to see it on a Google map to get a good idea of the surroundings and was able to find out the lease rate and the amount of space available. </p> <p>There were so many ways to search on the site and it was quick and performed very well. I think this tool will be very useful to businesses in the US looking to find properties – it would be great to see this type of application for Canada too!</p> <p><a href="http://zoomprospector.com/">ZoomProspector - Search best communities for business</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-87850905408644156782009-04-30T12:49:00.001-04:002009-04-30T12:49:19.809-04:00Challenges in Spatial Database Interoperability<p>Yesterday’s post on the <a href="http://blog.safe.com/2009/04/challenges-in-spatial-database-interoperability/">It's All About Data</a> blog was about spatial databases and interoperability issues. Anyone who has worked with multiple spatial databases will know that there are issues moving data in or out of database. There can be different formats, coordinate systems, and requirements between systems or for clients that the entire process can be overwhelming.</p> <p>In the <a href="http://blog.safe.com/2009/04/challenges-in-spatial-database-interoperability/">It's All About Data</a> post today by Paul Nalos, he discusses these issues and even tackles the need for data validation.</p> <p>I find that data validation can be very tricky. There are so many parameters to consider. FME has the ability to do a lot of data validation but it still comes down to knowing your data. For me, the most important aspect of validating data is having a solid understanding of the data and it use.</p> <p><a href="http://blog.safe.com/2009/04/challenges-in-spatial-database-interoperability/">Challenges in Spatial Database Interoperability | It's All About Data</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-17318275039180328782009-04-29T22:38:00.000-04:002009-04-30T09:28:21.221-04:00Swine FluThis is very proud to see media start to use geographic map to display the spreads of the swine disease using Google map or you can view it in Google Earth. When SARS (another influenza disease) discovered from Asia two years ago, media was listing name of the cities/countries which most of the people didn't know where those places located. Now we can click on Google and know exact where the confirmed case and a general description with it.<br /><br /><a href="http://www.cbc.ca/world/story/2009/04/27/f-swine-flu-map.html">Swine Flu Map</a> - Actual reporter update whenever the case confirm.<br /><br />Everyone please use the sanitizer if available, and wash your hands often! ~oink oink~Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-819809874805541216.post-16117515805366232182009-04-29T14:58:00.001-04:002009-04-29T14:58:27.141-04:00Everyscape – Tour “inside” facilities<p>Today I came across a very interesting website, Everyscape. This site allows users to drive down streets (similar to Google street view) BUT it brings something new to the picture. Users can virtually tour inside facilities. I took a tour of Crobar in Miami Florida. It was great to see inside the building and get a feel for the place. The place was packed and while some of the faces and images were blurred, overall, it really gave me an impression of what it would be like to party at Crobar.</p> <p>I think that tourism applications would benefit greatly from this tool.  Before taking a trip, users could look on the site for popular places and find places they can experience “inside” before leaving the living room. I’m planning my next trip now!</p> <p><a title="http://www1.everyscape.com/miami-fl.us.aspx?" href="http://www1.everyscape.com/miami-fl.us.aspx">http://www1.everyscape.com/miami-fl.us.aspx?</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com5tag:blogger.com,1999:blog-819809874805541216.post-25369569678404557092009-04-29T09:07:00.001-04:002009-04-29T09:07:54.172-04:00GIS Maps Track Foreclosures in California and Kansas<p>Counties is California and Kansas are using GIS to obtain funds from the Department of Housing and Urban Development (HUD). Based on real estate information from DataQuick and HUD, San Bernardino developed a point system to rank those homes in the most danger of foreclosure. Using this data, they were able to focus only on the most severe areas. They would that all 24 cities in San Bernardino County had buildings that were in higher danger of foreclosure.</p> <p><a href="http://www.govtech.com/gt/649520?topic=117676">GIS Maps Track Foreclosures in California and Kansas</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-55806250436553476192009-04-27T17:00:00.001-04:002009-04-27T17:00:01.696-04:00Crime Maps Online<p>People who know me know that I’m a bit of a crime buff (is that the right term?). I’m really interested in using GIS to solve crime and crime mapping. I have what some may call a “sick fascination” with GIS and crimes. I think this might be why I watch Num3ers on a regular basis (always hoping that they will do geographical analysis and frequently rewarded with some type of spatial analysis).</p> <p><a href="http://www.safecitymississauga.on.ca/crimeIncidents.html#mapView">Safe City Mississauga</a> has crime maps available for the City of Mississauga. I look at this site about once a month to see if there are any crimes of note in my area. I can find out that there was a B&E (Break & Enter) at a home not far from mine near the end of March. This type of information fascinates me and I hope to get the opportunity to find our more about crime tracking and mapping one day – who knows, maybe I can become a spy. Personally, I think it’s very important to know about all the crime occurring in your own neighbourhood – it’s where you live after all!</p> <p>Today I came across an article for <a href="http://www.battlecreekenquirer.com/article/20090427/NEIGHBORHOODS01/904270335">Battle Creek, MI</a> that connects crime in neighbourhoods but also allows residents to track the status of complaints in real time. I hope that Mississauga implement a more detailed mapping application soon. </p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-47615341304976243572009-04-27T16:03:00.001-04:002009-04-27T16:07:07.079-04:00An interactive map of vanishing employment across the country<p>It’s no secret that the United States has seen tremendous job losses since the economic crisis began. Slate Magazine has an interactive map that shows the job losses across the country and illustrates that job loss began in August 2007 (before the “official” start of the recession). </p><p>A picture is worth a thousand words…click on the link below for the article and map.</p><p><a href="http://www.slate.com/id/2216238/">An interactive map of vanishing employment across the country. - By Chris Wilson - Slate Magazine</a></p><p>(Thanks PJ for the link!)</p>geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-56297009457200862212009-04-27T10:48:00.000-04:002009-04-27T15:14:12.030-04:00Waiting for Google Street View in TorontoFor the past few weeks, there have been loads of google van sitings in Toronto. Now there are reports of google van sitings in Vancouver and Ottawa.<br /><br />A couple years ago, when google launched Street View, I remember virtually touring Palm Beach in Florida. It's a great tool if you're relocating to an area or if you are planning to visit an area and are searching for hotels in a scenic environment.<br /><br />I can't wait to virtually tour my neighbourhood. The need for high resolution imagery has exploded. When I was in school, we were amazed to see imagery at the 5-meter level, nowadays, that's not even close to the resolution readily available.<br /><br />In Canada, faces on Street View will be blurred but I wonder how much that will help my neighbour who is fond of naked yoga with the blinds opened...geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-47288391877963789202009-04-26T14:14:00.001-04:002009-04-26T14:16:57.153-04:00Local food map – Essex County, Ontario<p>About a week and a half ago, The Windsor Star published an article about the demand for the much anticipated local food map. </p><p>There has been a lot of press about the 100-mile diet and it seems that even in Windsor, Ontario, there is a strong demand from residents of the area to find local foods. </p><p>The 100-mile diet is supposed to reduce the environmental impact of our food – but I wonder how driving all around Essex county in the search of local produce will be good for the environment. </p><p>The map will be available May 1, but the link below will show a preview of the map.</p><p><a href="http://www.windsorstar.com/Health/Local+food+People+craving+this+info/1497532/story.html">Local food map: 'People are craving this info'</a></p>geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com1tag:blogger.com,1999:blog-819809874805541216.post-78254160419417704762009-04-24T10:37:00.001-04:002009-04-24T10:37:30.404-04:00Ohio InSite – Using GIS to Attract Capital Investment<p>Looking for a place to invest in Ohio? Look no further, Ohio InSite is here! Ohio InSite allows users to search for available land or buildings in the state. Base map information is from Google and there is a lot of thematic data that can be added to the map. </p> <p>Once the user finds a location of interest, a report can be generated based on the county of the selected location or based on the radius.</p> <p>There are several types of information that can be included in the report including demographic information and a business report (to see other businesses in the area). </p> <p>I generated a report to see how the system works. The output is a pdf file with the county of interest, followed by the demographic trends of the area. The report was clear and simple to follow – very useful for capital investors.</p> <p>I think this will be very useful to help attract capital investment in the State. </p> <p><a title="Ohio InSite" href="http://ohiomeansbusiness.com/ohioinsite/">Ohio InSite</a></p> <p><a href="http://www.redorbit.com/news/technology/1676614/ohio_makes_it_easy_to_find_perfect_location_for_capital/">redOrbit article</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com1tag:blogger.com,1999:blog-819809874805541216.post-4747796745741565982009-04-23T10:21:00.000-04:002009-04-23T13:22:25.767-04:00Joining Tables in ArcMap - Why does this take so long?I have to admit, I'm not the more patient person in the world. I have a fast computer and I still complain when things don't happen instantaneously on my machine. But one of the major things that irks to no end is waiting for <span class="blsp-spelling-error" id="SPELLING_ERROR_0">ArcMap</span> to join data.<br /><br />I have a <span class="blsp-spelling-error" id="SPELLING_ERROR_1">shapefile</span> that has over 1.5 million records and I need to join it to a text file with just a couple hundred records. When I perform the join in <span class="blsp-spelling-error" id="SPELLING_ERROR_2">ArcMap</span>, I find myself mindlessly staring at my computer screen willing it to complete. 10 minutes later and I'm still staring at the same computer screen but I'm pleading with <span class="blsp-spelling-error" id="SPELLING_ERROR_3">ArcMap</span> to finish the join so I can get on with my work.<br /><br />I know that if I reversed the order of the join, I could get my data faster, but the "big" file is the <span class="blsp-spelling-error" id="SPELLING_ERROR_4">shapefile</span> with all my geometry. So I am left to wait, hope, cry, and beg for <span class="blsp-spelling-error" id="SPELLING_ERROR_5">ArcMap</span> to finish this process.<br /><br />But then there comes a point in time when I just can't wait any longer. It's at this point that I give up trying to create my layer files (using definition queries) and resorted to creating a file <span class="blsp-spelling-error" id="SPELLING_ERROR_6">geodatabase</span> with all the data segmented out in separate feature classes. While I was doing this in <span class="blsp-spelling-error" id="SPELLING_ERROR_7">FME</span>, <span class="blsp-spelling-error" id="SPELLING_ERROR_8">ArcMap</span> stalled on me. When will I ever learn?<br /><br />I really do like <span class="blsp-spelling-error" id="SPELLING_ERROR_9">ArcMap</span>, but it frustrates me that simple joins and definition queries can take so long on large <span class="blsp-spelling-error" id="SPELLING_ERROR_10">datasets</span>.geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com1tag:blogger.com,1999:blog-819809874805541216.post-28923971945636054192009-04-21T19:27:00.001-04:002009-04-21T19:27:46.243-04:00GIS and Videogames Collide with CityScape 1.7<p>Personally, I’m not much into videogames, but this is where a lot of the current 3D imaging originated. PixelActive, a technology company focusing on video games, has launched CityScape 1.7 which allows users to integrate real geospatial imagery to build a 3D environment with simple point and click usability. This program will allow videogame programmers to incorporate real world settings into their games with the click of a button.</p> <p>I find this absolutely fascinating and I think the technology have far reaching potential outside the videogame world. </p> <p>All this kind of makes me want to go out and buy a gaming system…</p> <p><a href="http://www.directionsmag.com/press.releases/index.php?duty=Show&id=31727">PixelActive’s CityScape 1.7 Enables Automated Processing for Geospatial Visualization</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com1tag:blogger.com,1999:blog-819809874805541216.post-91607552679527809952009-04-21T11:44:00.000-04:002009-04-21T13:07:11.123-04:00FME - the Ultimate tool for GIS UsersFor the past few years, I have been using <span class="blsp-spelling-error" id="SPELLING_ERROR_0">FME</span> (Feature Manipulation Engine) in my daily <span class="blsp-spelling-error" id="SPELLING_ERROR_1">workflow</span>. The software is created by Safe <span class="blsp-spelling-corrected" id="SPELLING_ERROR_2">Software</span> (<a href="http://www.safe.com/">http://www.safe.com/</a>) who also produce add-on extensions for <span class="blsp-spelling-error" id="SPELLING_ERROR_3">ArcGIS</span> and <span class="blsp-spelling-error" id="SPELLING_ERROR_4">MapInfo</span>.<br /><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_5">FME</span> is a spatial <span class="blsp-spelling-error" id="SPELLING_ERROR_6">ETL</span> tool (<span class="blsp-spelling-error" id="SPELLING_ERROR_7">ETL</span> = Extract, Transform, Load). It allows users to create <span class="blsp-spelling-error" id="SPELLING_ERROR_8">workflows</span> (saved as <span class="blsp-spelling-error" id="SPELLING_ERROR_9">workspaces</span>) to work through and solve spatial problems, check for data errors, make data corrections, perform spatial analysis, and even easily populate databases. The power of the software comes from a combination of the sheer volume of formats that it can read and write and from the advanced tools that are easy to use yet very powerful.<br /><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_10">FME</span> is so powerful, I can't believe some of the things it can do. I use it to find nearest neighbours and to merge <span class="blsp-spelling-error" id="SPELLING_ERROR_11">datasets</span> together. I found in <span class="blsp-spelling-error" id="SPELLING_ERROR_12">ArcMap</span>, when doing a join on a large <span class="blsp-spelling-error" id="SPELLING_ERROR_13">dataset</span>, I could be waiting for eons. Now, I just pop the data into <span class="blsp-spelling-error" id="SPELLING_ERROR_14">FME</span> Workbench and within seconds, I have my joined <span class="blsp-spelling-error" id="SPELLING_ERROR_15">dataset</span>. This is just the tip of the iceberg on what the software can do.<br /><br />I recommend that everyone tries out this software. There were spatial manipulations that I wanted to do in model builder but required custom scripts. Most of this functionality is provided free in <span class="blsp-spelling-error" id="SPELLING_ERROR_16">FME</span>. You can get a free trial from their website. But be warned - this software is a little tricky to use at first - the documentation is cumbersome but there are some free tutorials that should get you started.<br /><br />There is an <span class="blsp-spelling-error" id="SPELLING_ERROR_17">FME</span> user group where you can post questions and the support from the company is also top notch.<br /><br />AND NO, I did not get paid to write this!geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com1tag:blogger.com,1999:blog-819809874805541216.post-60181102659218118652009-04-19T16:27:00.001-04:002009-04-19T16:27:30.185-04:00GIS technology starts a journey to help undo a Nazi crime<p>Two “historical” GIS posts in one day! It seems some enterprising students from the University of St. Thomas and helping a family reclaim property that was confiscated by the Nazis. </p> <p>This article is fairly long but basically these students searched old documents to build a probable case to return property to a family. What’s a little disappointing is that the records are not always very clear so it’s difficult to build a strong case.</p> <p>I wish I had been able to do something this interesting in my undergraduate days. </p> <p><a href="http://www.startribune.com/local/west/43211052.html?elr=KArks:DCiUHc3E7_V_nDaycUiD3aPc:_Yyc:aUU">GIS technology starts a journey to help undo a Nazi crime</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-73342152859019345102009-04-19T10:48:00.001-04:002009-04-19T15:56:15.449-04:00Historical Mysteries Solved with Maps?<p>When I was doing my undergraduate degree, one of the courses I took was Cartography. Part of the course offered an historical look at how maps have been used to help answer questions.</p><p>The one map that stands out in my mind from this course is the John Snow Cholera map. <a title="John Snow Cholera Map" href="http://upload.wikimedia.org/wikipedia/commons/2/27/Snow-cholera-map-1.jpg" target="_blank"><img style="DISPLAY: block; FLOAT: none; MARGIN-LEFT: auto; MARGIN-RIGHT: auto" height="318" alt="File:Snow-cholera-map-1.jpg" src="http://upload.wikimedia.org/wikipedia/commons/thumb/2/27/Snow-cholera-map-1.jpg/643px-Snow-cholera-map-1.jpg" width="341" border="0" /></a></p><p>When the cholera outbreak took place in Soho, London (1854), the initial belief about the spread of the disease was from pollution. John Snow spoke with residents and created a map plotting the cases of infection and proved that the source of the cholera was a contaminated water well. Until the distribution of the outbreak was mapped, the cause could not be determined. I think the reason this map stayed in my mind for so long was because is was a great example of how maps can be used to help solve mysteries. </p><p>But I digress. Yesterday, I came across an article in the Augusta Chronicle offering a new theory on the Black Plague. I don’t recall the exact image of this map from my studies but it seems likely that it graced the contents of the same cartography course.</p><p><img height="417" src="http://upload.wikimedia.org/wikipedia/commons/d/dc/Bubonic_plague_map.PNG" width="385" /></p><p>When most people hear of the Black Death, they think of the bubonic plague which is transferred by rats and other vermin. Two professors from Georgia Southern University suggest that the Black Death was viral in nature and spread through trade routes. Now, these professors are using GIS technology to compile data and create maps to test the theory. </p><p><a href="http://chronicle.augusta.com/stories/latest/lat_518382.shtml">Professors offer new theory on infamous Black Death plague 041809 - The Augusta Chronicle</a></p>geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com1tag:blogger.com,1999:blog-819809874805541216.post-37382870364356626052009-04-17T16:21:00.001-04:002009-04-17T16:21:02.749-04:00Encouraging Kids to Play outside – using GIS<p> While I certainly like the sound of Kalamazoo, the name just rolls off the tongue nicely, I’m happy to see GIS put to a good use. It’s well documented that kids these days spend hours and hours watching TV, playing video games and using the computer. Experts have said that this is a major contributing factor to childhood obesity. However, this report, hot off the presses from Kalamazoo, shows that more than 35,000 children in Kalamazoo County live more than 10 minutes (walking) from a park. This certainly doesn’t encourage children to get out and play.</p> <p>It will be interesting to see if this type of analysis catches on and encourages more green spaces for recreational purposes…”if you build it, they will come” (Field of dreams reference).</p> <p><a href="http://www.mlive.com/news/kalamazoo/index.ssf/2009/04/hightech_project_aims_to_get_k.html">High-tech project aims to get kids playing outside - Kalamazoo News - The Latest News, Blogs, Photos & Videos – MLive.com</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com0tag:blogger.com,1999:blog-819809874805541216.post-75593969416052751612009-04-16T10:20:00.001-04:002009-04-16T10:20:26.869-04:00Map of Starbucks – mmmm Coffee…<p>Findbyclick is an interesting website. It allows users a simple method to view places of interest and even add their own locations. <a href="http://lh5.ggpht.com/_SBlR7NK9Cwo/Sec-qdd4t5I/AAAAAAAAABg/Vm_SQ99za7o/s1600-h/image%5B3%5D.png"><img title="image" style="border-right: 0px; border-top: 0px; display: inline; margin-left: 0px; border-left: 0px; margin-right: 0px; border-bottom: 0px" height="178" alt="image" src="http://lh3.ggpht.com/_SBlR7NK9Cwo/Sec-qvBh02I/AAAAAAAAABk/tvs2onmqwTM/image_thumb%5B1%5D.png?imgmax=800" width="244" align="right" border="0" /></a>The site relies on information from local users to populate locations on Google maps. </p> <p>As an avid coffee drinker, I love this! I looked up my local Starbucks on the map and was pleased to see it. The quality and quantity of information on the site is based on the users who submit locations of interest to display on the maps. </p> <p>Findbyclick also has some coffee stats including the number of Tim Hortons and Starbucks by province/state.  I’m not sure of the accuracy of the numbers here, but it’s interesting to look at nonetheless.</p> <p>My only question now is, when will they have real-time line tracking to tell me the best time to avoid the long line-ups for my non-fat vanilla bean latte?</p> <p><a href="http://www.findbyclick.com/coffee_s.html">Findbyclick map of starbucks</a></p> geographygeekhttp://www.blogger.com/profile/14088486623423287532noreply@blogger.com1