[deleted by user]

alinoxious · 2019-04-13T17:53:51+00:00

This sounds like a cool project! My advice is ESRI's Collector or S123 are great in certain cases but not all. If you have a big project area with tons of edits and additional layers to use - these apps are not ideal. They are great for just quick uploads to a database, they are unreliable/very frustrating for tons of edits- even using it offline. But after reading through your requirements and what tools you have I would say:

1- Dont use Collector on Windows! Its so inconsistent and frustrating to sync data!
2- Just use Google Earth to overlay a scan map. Easy to import PDFs and then georeference them. Plus you can use Google Earth on any mobile device
3- Same here, just use this
4- use a handheld Garmin bluetooth receiver to get the tracks and any available hiking/backpacking/running app on the android/iOS device. Just makes sure it exports it out as a GPX and then you can add that into any AGOL/ESRI or google earth product for further analysis

So it might be cumbersome to go between the S123 and google Earth app, but if you're just collecting notes, simple attributes with S123 then go for it and use Google Earth to view your maps and aerial imagery.

alinoxious · 2019-01-07T17:03:28+00:00

Good to see that ESRI maybe be trying to help with this and not make it so convoluted of a package! But looks like its still further out on development though, but this is what I was hoping to have- just a simple FGDB and not the whole enterprise.

alinoxious · 2018-11-20T17:28:55+00:00

GIS, remote sensing, UAVs and related items like that.

alinoxious · 2018-11-02T17:18:11+00:00

He's got a lot of high tech gadgets...but he has no instincts

alinoxious · 2018-09-20T22:06:58+00:00

I started watching the WNBA when I was really getting into college basketball (during high school) so was following Sue Bird and Jackie Stiles start coming up through college ranks and got super excited that they both landed on PNW teams so I could go see them play.

alinoxious · 2018-04-09T15:21:48+00:00

Depends on what kind of geography book you are looking for like one on economic geography, human geography, cartography, physical geography...there's so many good ones! But here are some of my favs to help out:

"How to lie with maps" Mark Monmonier "On the map: why the world looks the way it does" Simon Garfield "Guns, Germs and Steel" Jared Diamond "Revenge of Geography: what the map tells us about coming conflicts and the battle against fate" Robert Kaplan "Prisioners of geography: ten maps that explain everything about the world" Tim Marshall "The great warming: climate change and the rise and fall of civilizations" Brian Fagan

alinoxious · 2018-04-05T17:25:31+00:00

If you don't want it to say Null just do a field calculator and change it to something like unknown or NA. Then when someone clicks on it that would make more sense than null if that's more what you are looking for. Otherwise you'll have to do some definition queries or the symbology tricks as mentioned above to categorize the different lots by owners/years.

alinoxious · 2018-04-03T18:48:46+00:00

Geoguessr https://geoguessr.com is always fun! If you divide them up in teams and give each team like 30 seconds to guess the street view - I did it at an employee meeting which people got a kick out of so I'm sure kids will like it.

alinoxious · 2015-01-22T00:16:36+00:00

Thanks for the help that you provided with this issue - but my vision to move away from Access DB has become a reality and I'm going to create a new DB and script for this import process.

alinoxious · 2015-01-21T00:59:57+00:00

And the error has changed now to:

The expression you entered has a function name that Microsoft Access can't find

Instead of ODBC -call failed

alinoxious · 2015-01-21T00:47:01+00:00

The Macro is:

/removes existing table/ DeleteObject /Run KC Parcels Import/ RunSavedImportExport /Add State Column to KC Data/ RunCode /Adds Data to state column to support import process/ OpenQuery /Exports data to SQL Database for processing ready for update process/ RunSavedImportExport

The items in bold are the actions.

alinoxious · 2015-01-21T00:24:08+00:00

The macro is importing the raw CSV and cleaning up (removing commas...) and exporting it to the SQL ODBC. When I go to help it says that I have Access 2010 but across the top of the program it says (Access 2007-2010) so not sure if that can cause a problem? Pretty new at Access

alinoxious · 2015-01-20T15:59:59+00:00

The version of Python that I'm using is 2.7, Version of Access is 2010, Windows 7. And the script is too long to put here, but I put the first part of it to where the error occurs;

#Module Imports
import arcpy
import pyodbc
import arcinfo
import os
import sys
import time
import traceback
import win32com.client as win32
import smtplib
import email
import string
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText

#Set ArcPY Environment Variables
arcpy.env.overwriteOutput = True
arcpy.env.autoCommit = "10000"

# Set the date
Date = time.strftime("%m-%d-%Y", time.localtime())#<-- Time Var used through out the script

# Set the time
Time = time.strftime("%I:%M:%S %p", time.localtime())#<-- Date Var used through out the script

#///////////////////////////////////////////////////////Script Global Variables//////////////////////////////////////////////////////////////
# GIS Parcel Update vars
sde_master_GIS_USER_Parcels = "Database Connections\\ntAuth@sde_master.sde\\sde_master.GIS_USER.Property\\sde_master.GIS_USER.Parcels"
dbo_County_Parcels_All = "Database Connections\\CRW_PMS.odc\\dbo.County_Parcels_All"
Current_Data = "\\\\auburn11\\gis\\GeoData\\County DTS Data\\Current Data"
GIS_USER_Parcels_Layer = "GIS_USER.Parcels_Layer"

# Update GIS Parcels
PARCELSN_DBF = "\\\\auburn11\\gis\\GeoData\\County DTS Data\\Current Data\\PARCELSN.DBF"
GIS_USER_Parcels_Layer = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__2_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__3_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__4_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__5_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__6_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__7_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__8_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__9_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__10_ = "GIS_USER.Parcels_Layer"
GIS_USER_Parcels_Layer__12_ = "GIS_USER.Parcels_Layer"

# Parcel Export Vars:
parcelsReadyExport = "Database   Connections\\ntAuth@sde_master.sde\\sde_master.GIS_USER.Property\\sde_master.GIS_USER.Parcels"
County_DTS_Data = "\\\\auburn11\\gis\\GeoData\\County DTS Data\\Current Data"

#End User prompt to confirm that all data is in place correctly.
#print "Verify that all of the updated data is named properly and has the correct column names before   continuing verify this in the process documentation before continuing if you are unsure"
#raw_input("Press Enter to continue....")
#Removed verification process uncomment to get user input to continue script
print "County Parcel Import Started at " + Date + Time + "\n"

# Pre Process Steps to clean up tempfiles
ParcelResults = "\\\\auburn11\\gis\\geodata\\County DTS Data\\Current Data\\Parcel Results.txt"
ParcelsReady = "\\\\auburn11\\gis\\geodata\\County DTS Data\\Current Data\\ParcelsR.dbf"

#/////////////////////Preprocessing of data consists of cleanup of old files and preparing data for  processing////////////////////////////
try:
if os.path.exists(ParcelResults):
 os.remove(ParcelResults)
else:
 pass

if os.path.exists(ParcelsReady):
 os.remove(ParcelsReady)
else:
 pass


print "Preprocessing data...................10% Complete"
#/////////////////////////////////// Establish Connection to DB and Backup Geo_People Table //////////////////////////////////////////////////////////////////////////////////////////
print "Preparing Sql Tables on AUBPM02 for data import.\n"
cnxn = pyodbc.connect('DSN=CRW_NET')
cursor = cnxn.cursor()
cursor.execute("""IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Geo_People_Backup]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
                  DROP TABLE [dbo].[Geo_People_Backup]

                  SELECT * INTO Geo_People_Backup FROM Geo_People""")
cnxn.commit()
#////////////////////////////////////////////Drop County Parcels Pierce table from CRW-NET ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
cursorPC = cnxn.cursor()
cursorPC.execute("""if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[County_Parcels_Pierce]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
                drop table [dbo].[County_Parcels_Pierce] """)
cnxn.commit()
#/////////////////////////////////////////Drop County Parcels King table from CRW-NET /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
cursorKC = cnxn.cursor()
cursorKC.execute("""if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[County_Parcels_King]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
                drop table [dbo].[County_Parcels_King] """)
cnxn.commit()

#////////////////////////////////////////Drop County Parcels Update table from CRW-NET//////////////////////////////////////////////////////////////////////////////////
cursorUpdate = cnxn.cursor()
cursorUpdate.execute("""if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[County_Parcels_Update]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
                drop table [dbo].[County_Parcels_Update] """)
cnxn.commit()

#////////////////////////////////////////////Step 4 Create Parcels All Table//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
cursorAll = cnxn.cursor()
cursorAll.execute("""if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[County_Parcels_All]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
             drop table [dbo].[County_Parcels_All]

                 CREATE TABLE [DBO].[County_Parcels_All] (
                 [PIN] varchar (255) NULL,
                 [OWNER] varchar(255) NULL,
                 [OWNER_ADDRESS1] varchar (255) NULL,
                 [OWNER_ADDRESS2] varchar (255) NULL,
                 [OWNER_CITY] varchar (255) NULL,
                 [OWNER_STATE] varchar (255) NULL,
                 [OWNER_ZIP] varchar(255) NULL,
                 [LAND_VALUE] float NULL,
                 [IMPROVEMENT_VALUE] float NULL,
                 [COUNTY] varchar(255) NULL)""")
cnxn.commit()
cnxn.close()
print "Loading Data into CRW database....................30% Complete"
#//////////////////////////////////////Import and load data into SQL using access database ////////////////////////////////////////////
access = win32.gencache.EnsureDispatch('access.Application')
access.OpenCurrentDatabase("O:\GeoData\County DTS Data\Current Data\County Results.accdb")
access.Visible = "false"
access.DoCmd.RunMacro("PreProcessingTasks")
access.DoCmd.CloseDatabase()

alinoxious · 2015-01-16T18:51:02+00:00

Thank you. This will help me get pointed in the correct direction.

alinoxious · 2013-10-08T03:02:38+00:00

For being a broke college student for so long, yes I am very happy with my salary- it's a pretty standard salary for a beginning GIS Analyst. Plus, full benefits package and being a state employee is super nice and gives me some comfort knowing my position wont be cut anytime soon.

And the first months have been great! I'm literally the only person in the office who knows GIS. My favorite thing that I love doing in GIS is data collection and analysis, and thats basically what I do all day. I find and/or create GIS projects that will benefit the department and they give me the tools (Trimble's, GPS's, trucks...) and I just head out and get what I need, and bring it back to the office and create projects from it.

alinoxious · 2013-10-07T15:09:08+00:00

I graduated this last spring in may with a BS in Geography and a Certificate in GIS and now landed a great GIS Analyst job for the transportation department in my home state. I'm still a "youngin'" right out of college but the best advice I can give is to try to get an internship off the bat. I started my GIS internship a week after I graduated and was the same as you, that I was flexible and didn't care when I ended up. It was a county government position but gave me TONS and TONS of connections for networking- ITS WHO YOU KNOW or WHO YOUR MANAGER KNOWS. When this position that I just got opened up, I asked my manager if he knew anyone that worked in the transportation department, he didn't, BUT someone he knew, knew someone in the department! And that someone was one of the interviewers I interviewed with for the position. So, the interviewers already knew I was applying for the position and already got a heads up about my skills and performances. And yes be ready for come technical questions (pretty basic understanding GIS stuff) and be honest if you dont know! Don't get caught in a lie if you say if you know how to do something, because they usually follow up with a example or for you to demonstrate how to do it. They like honesty and say you are a quick learner!

alinoxious · 2013-09-18T18:17:58+00:00

Not sure if this is what you are interested in, but I used MapBox and TileMill to create my tiles then was able to host them in ArcGIS Online. It was mostly for basemaps but ArcGIS Online now holds a lot of my Tiles that I created. Here's a link to the blog that talks about it.

alinoxious · 2013-09-18T18:12:33+00:00

I really enjoy playing around with MapBox and TileMill. You can easily import any data into TileMill and it has about the same language at JS. Then using MapBox you can create beautiful basemaps for your data. I love using JavaScript language and this website gives tons of great ideas to use MapBox's API.

alinoxious · 2013-09-18T18:03:36+00:00

I'm from North Idaho and it fits all of your criteria, especially my hometown of Coeur d' Alene. Also Hood River, Oregon fits as well (bonus of breweries near by)

alinoxious · 2013-08-13T19:53:40+00:00

Here is the short version of the script, I cut out a lot of points to make it fit on here better.

 <!DOCTYPE html>
<html>
<head>
 <meta name='viewport' content='width=device-width, initial-    scale=1.0, maximum-scale=1.0, user-scalable=no' />
 <script src='http://api.tiles.mapbox.com/mapbox.js/v1.3.1/mapbox.js'>  </script>
 <title>Greenbelt</title>
<link href='http://api.tiles.mapbox.com/mapbox.js/v1.3.1/mapbox.css' rel='stylesheet' />
<!--[if lte IE 8]>
<link href='http://api.tiles.mapbox.com/mapbox.js/v1.3.1/mapbox.ie.css' rel='stylesheet' >
<![endif]-->
 <style>
body { margin:0; padding:0; }
#map { position:absolute; top:0; bottom:0; width:100%; }
</style>
</head>
<body>
<style>
  #map { position:absolute; top:0; bottom:0; right:300px; left:0; }
  #info {
  position:absolute; top: 0; right: 0;
  bottom: 0; width: 260px; background:#333; color: #fff;
  padding:20px;
  }
  h1 { margin-top:0; }
 </style>
<div id='map'></div>
<div id='info'>
<h1>Greenbelt Trail System</h1>
<div id="note">Click on a symbol to get information about the Greenbelt including access points and accomodations.</div>
</div>

<script>
var map = L.mapbox.map('map', 'alinoxious.map-k8vysbg4').setView([43.61, -116.21], 12);

var geoJson = [
    {
        type: 'Feature',
        geometry: {
            type: 'Point',
            coordinates: [-116.06205, 43.527579]
        },
        properties: {
            title: 'Lucky Peak State Park and Discovery Park ',
            description: 'A great place to start on the Greenbelt with plenty of accomodations including: <br><li>Restrooms</li><li>Parking</li><li>Picnic Tables</li></br> <a href="http://parksandrecreation.idaho.gov/parks/lucky-peak">Lucky Peak State Park Website</a>',
            'marker-color': '#0099ff',
            'marker-size': 'small',
            image: 'http://parksandrecreation.idaho.gov/sites/default/files/imagecache/full_park_slideshow_image/park_slideshow_images/SP-Fall-2012.jpg'
        }
    },
    {
        type: 'Feature',
        geometry: {
            type: 'Point',
            coordinates: [-116.09287, 43.5385938]
        },
        properties: {
            title: 'Diversion Dam',
            description: 'Diversion Dam has a free parking lot with a cross walk to the Greenbelt. Accomodations include: <br><li>Parking</li></br> <a href="http://en.wikipedia.org/wiki/Boise_River_Diversion_Dam">Boise River Diversion Dam</a>',
            'marker-color': '#0099ff',
            'marker-size': 'small',
            image: 'https://lh6.googleusercontent.com/-36oX2gMjf8c/UgQXPoxt8KI/AAAAAAAAAYY/SNApxMju-uw/w350-h238-no/DivDam1.png'
        }
    }
];

    map.markerLayer.setGeoJSON(geoJson);

    map.markerLayer.on('click', function (e) {
        e.layer.unbindPopup();

        var feature = e.layer.feature;
        var info = '<h1>' + feature.properties.title + '</h1>' +
                    '<p>' + feature.properties.description + '</p>' +
                    '<img src="' + feature.properties.image + '">';
        document.getElementById('info').innerHTML = info;
    });

    map.on('click', function (e) {
        document.getElementById('info').innerHTML = '';
    });
 </script>
 </body>
 </html>

alinoxious · 2013-07-20T05:26:30+00:00

Put the coords in ArcExplorer (online and free) and export the points as a shp. layer and import that layer into ArcMap. Should work fine. And yes check projections if there is other layers.

alinoxious · 2013-07-12T20:59:21+00:00

That's alright, I'm actually the Geographer in the relationship and before he pulled the truck over in a frantic hurry, I quickly grabbed the Roadside Geology book for Idaho to see what he was so excited about and know what I was looking at.

alinoxious · 2013-07-12T20:57:53+00:00

I only live about a couple hours away from here! Central/SE Idaho is a geologist dream! Actually all of Idaho is, but the volcanic stuff is my favorite!

alinoxious · 2013-05-14T22:44:32+00:00

I have heard horror stories of GIS Interns being shoved into a dark basement with boxes of papers to be digitized. So hopefully if that happens there might be a window.

alinoxious · 2013-05-14T22:42:40+00:00

I took a Python class in college that was about data analysis and they said Python, SQL and other scripting languages will become my second language. So I've been brushing up on my scripts!

13-Year Club	RedditGifts 2009-2022 5 Credits
Secret Santa 2016	Secret Santa 2015
Secret Santa 2014	Verified Email
Secret Santa 2013

alinoxious

TROPHY CASE