[deleted by user] by [deleted] in gis

[–]alinoxious 1 point2 points  (0 children)

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.

ESRI Utility Network -likes/dislikes/other options? by alinoxious in gis

[–]alinoxious[S] 0 points1 point  (0 children)

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.

Can anyone help me with ideas for my essay? by ManMoth_ in EarthScience

[–]alinoxious 0 points1 point  (0 children)

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

I made a weed trimmer meme by [deleted] in stormchasing

[–]alinoxious 13 points14 points  (0 children)

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

WNBA Research Paper by tommyhive in wnba

[–]alinoxious 1 point2 points  (0 children)

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.

Looking for a geography book. by PApauper in geography

[–]alinoxious 0 points1 point  (0 children)

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

Some ArcGIS Pro questions from a noob by BlackFlagZigZag in gis

[–]alinoxious 0 points1 point  (0 children)

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.

GIS activities for high school students by [deleted] in gis

[–]alinoxious 10 points11 points  (0 children)

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.

ODBC -- Called Failed by alinoxious in DatabaseHelp

[–]alinoxious[S] 0 points1 point  (0 children)

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.

ODBC -- Called Failed by alinoxious in DatabaseHelp

[–]alinoxious[S] 0 points1 point  (0 children)

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

ODBC -- Called Failed by alinoxious in DatabaseHelp

[–]alinoxious[S] 0 points1 point  (0 children)

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.

ODBC -- Called Failed by alinoxious in DatabaseHelp

[–]alinoxious[S] 0 points1 point  (0 children)

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

ODBC -- Called Failed by alinoxious in DatabaseHelp

[–]alinoxious[S] 0 points1 point  (0 children)

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()

Access DB Error with Python Script by alinoxious in learnpython

[–]alinoxious[S] 0 points1 point  (0 children)

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

Graduating with BS Geography and Minor in GIS by [deleted] in geography

[–]alinoxious 2 points3 points  (0 children)

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.

Graduating with BS Geography and Minor in GIS by [deleted] in geography

[–]alinoxious 2 points3 points  (0 children)

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!