Latest Contributions by GarrettPullis

‎05-31-2016

Hey everyone, So as a side project, I have a database of clients that I want to put on a map so that all clients on the database will be placed at their corresponding locations. I have set up the database by address, city, state, and zipcode. I'm not entirely sure on the way to approach this. Since it will be a database that will be updated as time goes on, I wanted to eventually automate it to allow my coworkers to access this geocoded database via interactive map or application and add new locations. The database is roughly 600 rows of data on an excel file with multiple tabs (by state). I know this may be a vague question so please feel free to ask me questions that are pertinent to helping answer this question. In all, my end goal is to create an interactive web map and application that will enable someone to type in the office name, address or any other available attribute and display it on a map. The image I have in my head is similar to what Google does when you search for a location on GoogleMaps. Thanks for any and all help!

‎05-03-2016

Currently working on a Median calculation tool. This tool is similar to the one I posted on a previous post involving selecting a city and zooming into it. In this case, we have to type in a country name, where the tool will then select all the cities in that country, sort the POP_RANK of the cities in that country, and calculate the median POP_RANK for that country. I was able to complete the select and zoom aspect but I am not entirely sure how to create a list/search cursor which will allow us to input a calculation. Is there a specific way I should approach this? Any and all help is appreciated!! Thank you import arcpy from arcpy import mapping #sets the workspace mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0] fc = ("N:/data2016/Lab13/cities.shp") cities = arcpy.mapping.ListLayers(mxd, "Cities")[0] cities.showLabels = True def countryList(): country = arcpy.GetParameterAsText(0) country_Layer = arcpy.MakeFeatureLayer_management(fc, "country_lyr") arcpy.SelectLayerByAttribute_management(cities, "NEW_SELECTION", "CNTRY_NAME = '{}' ".format(country)) arcpy.mapping.ListDataFrames(mxd)[0].zoomToSelectedFeatures() arcpy.RefreshActiveView() arcpy.Delete_management("country_lyr")

‎05-03-2016

The only thing that we were able to make it do was select all the cities rather than the one particular city that we input

‎05-02-2016

The interesting thing was I wasn't receiving any errors. The script would run through and complete, but nothing would happen in ArcMap. Prior to that there was an error saying GetParameter wasn't defined. Besides that it runs, but nothing happens.

‎05-02-2016

Working on creating a lab which will allow me to type in a city name into a parameter and it will select that city, add it to the TOC and zoom into it. I'm having trouble getting around certain errors. Please help! import arcpy from arcpy import mapping #set workspace mxd = arcpy.mapping.MapDocument("CURRENT") #set the dataframe df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0] cities = arcpy.mapping.ListLayers(mxd, "Cities")[0] #Establish variables cityName = arcpy.GetParameterAsText(0) #Set variable as the parameter for the city search arcpy.SelectLayerByAttribute_management("Cities", "NEW_SELECTION", " CITY_NAME = 'cityName' ") df.zoomToSelectedFeatures() arcpy.RefreshActiveView()

‎01-07-2016

I think I have a solid resume. I have put a lot of time in effort updating my LinkedIn and updating my resume whenever I gain a new skill but is there a preferred format or specific examples that most employers are looking for? You mentioned that a computer is going through the resumes so does it not so much matter on the things you write about but the words that the program is looking for? Is there anything you wish you knew toward your senior year of your undergraduate that you know now that you would tell your former self? What would your current self tell your younger self about how to get an edge or some foresight on the progression of where GIS is going to be in the next 10 years? Maybe that one transferable skill that can be applied to any interview or application? I appreciate everyone's input. This has been very helpful.

‎01-07-2016

This information is very help! Thank you very much everyone! I will definitely add this to my arsenal. I'm always willing to step out of my comfort zone to learn something new. Do you have any broad examples of what keywords or skills these companies may be looking for? Some of these companies are so large and have different sectors that it's hard to narrow down what to focus on.

‎01-07-2016

Rickey thanks for the help! I actually just recently downloaded Python onto my computer to just kind of play around with it and follow the tutorial on their website to better understand how to use it. I'm still getting use to knowing what to use and where to use it but I guess I'm moving in the right direction. So next to being able to use Arc, programming is where upcoming GIS users should dedicate most of their time? I worked a little bit with QGIS to broaden my GIS experience but I also recently joined the NACIS because they have a lot of resources and like minded individuals as well, along with 'MapLift' where they take wiki maps and help fix them as a way to volunteer my time and skills in exchange for experience. I want to get into the sustainable development, natural resource management, and environmental services industries, companies that work with the government or private sector, and eventually work my way up to a natural sciences manager but it's really hard to know what these big companies want. I haven't really been lucky enough to get any extensive internships, is there any specific websites or organizations/companies that have been known to give good internships or work opportunities?

‎01-06-2016

My name is Garrett and I am a graduating senior finishing up with a bachelors in both Geography and Environmental Geoscience along with a minor in GIS. I have had plenty of jobs throughout my life including retail, landscaping, coaching, and field managing for a nonprofit org, but have no real world experience. I have taken plenty of courses utilizing GIS and imagery programs, but haven't landed a job in GIS quite yet. I have an upcoming part time position as a GIS technician for my final semester as an undergrad but I want to look toward the future for AFTER graduation. I'm trying to hit the ground running and I have already applied to 15 different internships or job positions. Does anyone have any tips that can be added to a resume or toward applying for jobs? I try to elaborate on my skills by referencing results from my experience but with little real world experience, I've had to resort to self-teaching. What else could I do to land that solid first job? Any and all tips and advice are appreciated, thanks! P.S. Looking for jobs in the greater Pittsburgh, DC, NVA,, Baltimore, and NYC areas at the entry level.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by GarrettPullis

Setting up/Creating a geocoded database using address, city, state, and zipcode

median calculation tool

Re: Creating a City Select and Zoom tool using arcpy

Re: Creating a City Select and Zoom tool using arcpy

Creating a City Select and Zoom tool using arcpy

Re: How to perfect a resume for a GIS application with entry-level experience?

Re: How to perfect a resume for a GIS application with entry-level experience?

Re: How to perfect a resume for a GIS application with entry-level experience?

How to perfect a resume for a GIS application with entry-level experience?

How to perfect a resume for a GIS application with...