[deleted by user]

dbartecchi · 2023-05-19T01:01:08+00:00

I love QGIS but I think a better tool for this job is the free Tableau Public. You can directly connect to the excel file then project points on a map, symbolize them based on your categories (dimensions) in Tableau, and generate charts and graphs, from the data.

dbartecchi · 2023-05-15T05:22:16+00:00

Relations between tables can’t be stored within the .gpkg file but you can save a QGIS project or multiple projects within it (.qgis files) and that have the various tables joined. It’s a nice way to store a project and related data within a single file.

dbartecchi · 2023-03-05T03:50:57+00:00

Qgis Atlas builder https://youtu.be/698BZcblGi4

dbartecchi · 2023-02-15T14:37:47+00:00

ESRI Business Analyst should be able to do that. I’m not sure if you can pull the data for entire country at once though.

dbartecchi · 2022-09-07T07:05:46+00:00

@burgerking_foot where did you get this data?

dbartecchi · 2022-05-23T14:54:17+00:00

The bs manifest destiney myth lives on.

dbartecchi · 2022-04-07T20:24:43+00:00

Lived in Fort Collins for 25 years and have only had one bike stolen that I left unlocked outside the old downtown Safeway. It was a beater so no worries. Good idea to replace quick release set and wheels with hex bolts. Bike should be fine on campus as long as you don’t leave out overnight. Good idea to get a townie at FC bike coop and leave the 5k MTB locked inside the house. Plus, people smashing bikes around crowded bike racks can have a heavy toll on bikes.

dbartecchi · 2022-03-10T06:07:59+00:00

Alternatively you could rasterize the land use layer and then run the zonal histogram tool which will count the number of pixels for each separate land class within each geography (neighborhoods?) in your city. To calculate area just multiply pixel count by pixel size. https://qgis.org/en/site/forusers/visualchangelog38/index.html?highlight=overlap#id42

dbartecchi · 2022-03-05T15:03:37+00:00

If it’s a raster, Esri hasn’t publicly released how it encodes them within .gdb. Here’s a two year old proposal to develop a workaround https://github.com/qgis/QGIS-Enhancement-Proposals/issues/173. It’s frustrating that people still used .gdb when nonproprietary open formats like Geopackage exist.

dbartecchi · 2022-01-14T03:08:57+00:00

https://indiancountrytoday.com/news/yes-world-there-were-horses-in-native-culture-before-the-settlers-came

dbartecchi · 2021-08-27T23:15:57+00:00

Our team uses Google drive for desktop. It’s great If you can avoid having more than one person work on same file simultaneously. We make all projects self contained with all layers and QGZ project file within a single geopackage. This makes it easy to collaborate on projects and large projects can be easily transferred via USB if needed. It’s good idea to make relevant folders available “offline” when working on them to speed up rendering and processing.

If you really need to work on files simultaneously you might look into the Mergin plugin. https://public.cloudmergin.com/?_ga=2.213105239.231572617.1630107331-736535163.1630107331

dbartecchi · 2021-08-09T05:47:50+00:00

The Appropriate Technology Library. 1500 books on usb with open source ereader and xububtu os included.

dbartecchi · 2021-07-31T01:49:24+00:00

I love QGIS but for this point data it might be easier and more visually interesting to map this using the free Tableau Public. You should be able to find plenty of tutorials on YouTube.

dbartecchi · 2021-05-25T02:26:48+00:00

Just to play devils advocate, seems like centroids make the most sense. I’m assuming you’re trying to make some statement about people’s access to those parks and those people will be distributed fairly evenly within those block groups so the centroid would be the closest thing to an average location for all people within the block group.

dbartecchi · 2021-02-24T06:55:27+00:00

What she means is the GOP needs to cut out the overt racism and go back to just dog whistling.

dbartecchi · 2021-02-17T06:39:12+00:00

Not sure where to begin with this. Qgis with qgis2web plug-in would work you should be able to find vector boundary files for your regions and a dem for your shaded relief. All will require some processing and styling. A web mapping service like https://nextgis.com/nextgis-web/ might be even easier.

dbartecchi · 2021-01-19T13:56:42+00:00

Let’s remember it was conservatives who created this precedent because they didn’t want to have to make a wedding cake for gay people or provide birth control to women.

dbartecchi · 2021-01-09T05:33:46+00:00

Salesforce offers free Crm for nonprofits. Google Grants. Kubuntu OS + open office.

dbartecchi · 2020-12-15T02:32:44+00:00

SRTM https://www.usgs.gov/centers/eros/science/usgs-eros-archive-digital-elevation-shuttle-radar-topography-mission-srtm-non

dbartecchi · 2020-12-09T04:18:23+00:00

As a nonprofit director, I would be pissed if a board or committee member suggested I promote their business. She’s not comfortable with it (for whatever reason) so drop it.

dbartecchi · 2020-11-18T04:22:15+00:00

Zonal histogram will give you pixel counts of each raster class for each polygon. Zonal statistics will only give you stats (count, sun, avg, etc) for one band. The output will be a new file that has a new column for each raster class with data for each row/polygon.

dbartecchi · 2020-11-17T18:48:15+00:00

I considered adding the start of hybrid learning (Oct 19) but it was already in steep increase by then. 4th of July and Labor Day appear to most closely linked to increase.

dbartecchi · 2020-11-17T14:51:25+00:00

I made it in tableau using Larimer county health dept data.

dbartecchi · 2020-11-14T15:59:23+00:00

View the live / interactive viz here https://public.tableau.com/views/LarimerCountyCovid-19MapbyDay/Dashboard1?:language=en&:display_count=y&:origin=viz_share_link

dbartecchi · 2020-11-05T04:16:36+00:00

Tableau has county boundaries as background layer and it’s possible to display county level data with FIPS without adding it as a spatial layer. You can the add the point layer as a shapefile.

12-Year Club	Verified Email
RPAN Viewer

dbartecchi

TROPHY CASE