Profile

Cover photo
Anthony Lopez
Works at National Renewable Energy Laboratory
Attended University of Northern Colorado
Lives in Lakewood, CO
21 followers|16,423 views
AboutPostsPhotosVideosReviews

Stream

Anthony Lopez

Shared publicly  - 
 
Here I present a method for dumping a table from one server/database and loading into another server/database with a different schema. This is a spinoff of a previous post (PostgreSQL - Copy Table to Another Server) which shows you how to dump a table from one server to another.
1
Add a comment...

Anthony Lopez

Shared publicly  - 
 
Batching Geometry Registration in PostGIS 1.5
When creating new spatial tables – say as the result of an analysis – you should register and add constraints to your table. At least this is the proper thing to do… If you are like me, I get a little...
1
Add a comment...

Anthony Lopez

Shared publicly  - 
 
Basic Comparison of Raster analysis in ESRI and PostGIS
This post compares - in a very basic sense - tabulating raster area in ESRI and PostGIS. 1. Data - Raster: 90 meter resolution covering most of the contiguous United States. Represents available land ...
1
Add a comment...

Anthony Lopez

Shared publicly  - 
 
PostgreSQL-  simply method for copying data across servers
My previous workflow for copying tables from one server to another was (1) pg_dump on server "A" then (2) SCP to server "B" then (3) restore via psql. Not a terrible workflow, but my new workflow is m...
1
Add a comment...
In his circles
25 people
Have him in circles
21 people
Lorrie Lopez's profile photo
Jørn Aabakken's profile photo
Jorn Aabakken's profile photo
Jenae Lopez's profile photo
J.R. Matero's profile photo
Alysha Guenther's profile photo
Jen Close's profile photo
Gregory Lopez's profile photo
J. Albert Bowden's profile photo

Anthony Lopez

Shared publicly  - 
 
Yup GIS folks, you need to learn to code
1
Add a comment...

Anthony Lopez

Shared publicly  - 
 
Nothing mind blowing here: PostgreSQL, determining table and index size
This is somewhat of a follow up to my previous post. If you are interested in knowing the size of your postgres table and associated indexes, sequences, etc., you can run the following SQL to find out...
1
Add a comment...

Anthony Lopez

Shared publicly  - 
 
PostGIS - Majority Point Value in Polygon
1
Add a comment...

Anthony Lopez

Shared publicly  - 
 
Experimenting with zonal statistics in PostGIS2.0
I've just taken up the task to experiment with PostGIS 2.0 raster support. At this point in time, it seems that there is little documentation (by other folks) regarding raster analysis using PostGIS, ...
1
Add a comment...
People
In his circles
25 people
Have him in circles
21 people
Lorrie Lopez's profile photo
Jørn Aabakken's profile photo
Jorn Aabakken's profile photo
Jenae Lopez's profile photo
J.R. Matero's profile photo
Alysha Guenther's profile photo
Jen Close's profile photo
Gregory Lopez's profile photo
J. Albert Bowden's profile photo
Education
  • University of Northern Colorado
    Geography, 2001 - 2006
Basic Information
Gender
Male
Work
Occupation
I currently work at the National Renewable Energy Laboratory in Golden, Colorado as a GIS Scientist. Analyzing and visualizing geospatial relationships is my career and passion
Employment
  • National Renewable Energy Laboratory
    GIS Scientist III, 2009 - present
  • SWCA
    GIS Analyst, 2006 - 2009
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Lakewood, CO
Previously
Greeley, CO - San Diego, CA
Good burritos. Quick and friendly service.
Food: GoodDecor: Poor - FairService: Good
Public - 2 years ago
reviewed 2 years ago
Good food; service was a bit slow but overall a good experience
Food: GoodDecor: GoodService: Good
Public - 2 years ago
reviewed 2 years ago
The wings are good but far from anything special.
Food: GoodDecor: Poor - FairService: Good
Public - 2 years ago
reviewed 2 years ago
19 reviews
Map
Map
Map
Great place to stay. Comfy, great design and decor, and walking distance to everything downtown Fort Collins has to offer.
Appeal: ExcellentFacilities: ExcellentService: Very Good
Public - 2 years ago
reviewed 2 years ago
A whooooooole lot o food for next to nothing. Pretty decent too
Food: GoodDecor: GoodService: Good
Public - 2 years ago
reviewed 2 years ago
Simply could not get someone to give us service. Quite strange...they were not even that busy...Google makes you fill out everything. I can only assume the food was ok.
Food: GoodDecor: GoodService: Poor - Fair
Public - 2 years ago
reviewed 2 years ago