Latest Contributions by ChrisSmith7

Wouldn't it be better to create a relational db in SQL with PKs/FKs, look-up tables, etc., tuned and optimized with proper indexing and clustering? You could write some stored procedures and udfs to generate/process all of your tax info... Just kidding! I like Excel for things like finances - works well for me, too, but it does drive me nuts when I see data in Excel that probably would live happier in a db. ... View more

Here's a technical article on Make Query Table - 37544 - Create a one-to-many join in ArcMap ... View more

You could also store date and time together, unless you need it split-up - e.g. something like "1900-01-01 00:00:00" Word of caution, Excel isn't really a database, it's a spreadsheet. If you want to really make a database, I would skip over Access and go right to SQL Server - you can get the "express" version for free: SQL Server Express Edition | Microsoft Here's a basic tutorial: Tutorial: SQL Server Management Studio In SQL, you could store this as datetime (or datetime2) or date only as date and time only as time (split-up). ... View more

If you save as a flat file (csv/txt), you can use a schema.ini file to specify data types, which ArcGIS will honor. This is something that is created automatically when you open a flat file in ArcGIS; here's more info for you to consult: Schema.ini File (Text File Driver) You can edit the schema.ini driver file with a text edit (right click, edit with notepad if it doesn't open with a text editor on double-click). Make sure the .ini file is in the same directory as your flat file. Regarding you zero division error, you can fix this in Excel before saving as a flat file: Correct a #DIV/0! error - Excel It's basically an inline if statement, something like: =IF(A2=0,"",A1/A2) This would probably even fix the issue with using Excel as the source in ArcGIS, so it would be recognized as a double. Also, worst case scenario, you could you could copy your column with division errors, then right click an Excel column, then "paste special", then choose "value only" - this should allow you to find/replace the division error values and replace with null. ... View more

I had an issue with this while publishing an xy event table from a view on a SQL Server direct connection. I'm not sure what worked in particular, but here are the actions taken to resolve: 1) Saved and closed MXD 2) Restarted MXD 3) Allowed full layer to render in ArcMap 4) File >> Share as >> Service 5) Elected to use an existing folder rather than create a new one 6) Analyzed service 7) Registered SQL db so data weren't copied to the server 😎 Published service It worked well the second time around! ... View more

Dojo makes it easy: Deferred and Promise chaining tests - JSFiddle Here's another example for chaining using Mootools: Chaining Javascript functions with callbacks - JSFiddle And jQuery: jsdeferred chain - JSFiddle http://stackoverflow.com/questions/5230333/how-to-avoid-callback-chains Note, the jsfiddles aren't mine! Additionally, regarding jQuery, here's some info on queue vs deferred objects: http://stackoverflow.com/questions/8119208/how-to-use-queue-or-deferred-in-what-condition-what-are-their-designing-pur ... View more

Dan mentioned there's many ways to do this - I thought I'd share another! >>> myVars = ["spam","eggs"] >>> " ".join(myVars) 'spam eggs' ... View more

Evelyn, I can confirm this works - I do it as a local failover in case of problems with the CDN. I suspect it might be your value in [HOSTNAME_AND_PATH_TO_JSAPI]. Here's what I have: 'http:' : location.protocol) + '//' + "myserver/arcgis_js_api/library/3.15/3.15/dojo/" In directories like so: ../arcgis_js_api/library/3.15/3.15 and ../arcgis_js_api/library/3.15/3.15compact ... View more

To add some more resources, you should probably learn a bit about JavaScript and Dojo (a JavaScript library used by the ArcGIS JavaScript API): JavaScript Tutorial Dojo Tutorials - Dojo Toolkit You'll probably want to go through the W3 tutorial before hitting anything Dojo related. Also, keep in mind prototyping sites, like jsfiddle: Create a new fiddle - JSFiddle A basic sample - Basic ArcGIS JS Slippy Map - JSFiddle Here are some quick-start maps from Esri's github: Esri/quickstart-map-js · GitHub ... View more

I'm not really familiar with AppStudio, but at least for the web map APIs, I know that KMLs must be public/forward-facing. ... View more

Are you sure your bootstrap module is sourced correctly? It seems to be throwing a 404 for me. ... View more

Are you trying to compare each data type individually, or are you looking to compare them against one another, e.g. male to female ratio? ... View more

Do you have the rest of your code that will highlight your issue? Right off the bat, I do see the href links aren't complete... The browser might resolve them, though. ... View more

Carol, Here's some info on number 1... If you have a table containing address info for your classmates, you can batch geocode (at least 2500 records) for free using the Texas A&M geocoder service: Texas A&M Geocoder - Free online geocoding You'll want to save your data in a .csv format to process on TAMU. Once you get the lat/long data, you can insert into ArcMap. The output from TAMU, if I remember, is a flat file. ArcMap can work with this, but to make it easier for you, you may want to load the flat file data into Excel first. Here's a tutorial on how to both load and save flat files: Import or export text (.txt or .csv) files - Excel Here are some youtube tutorials on how to add your points to ArcMap: How to make a shape file for Arcmap GIS using latitude longitude coordinates in an excel table - YouTube Adding XY Data - YouTube Importing GPS Coordinates from Excel into ArcMap - YouTube TAMU should return lat/longs in decimal degree format, which is good. It should also correctly label lat/long, and ArcMap will pick-up on this by the "lat" and "long" column names. In the event they do not look right, try flipping them... this is a common mistake - just remember, lat = y; long = x for our purposes. ... View more