LunaGeo leverages open source GIS to build solutions for the web, mobile, and desktop. We offer GIS consulting, custom software development, support, training, and managed cloud-based GIS servers. Our main technologies include QGIS, Geoserver, PostgreSQL/PostGIS, MerginMaps, and various web technologies that we use to build custom WebGIS applications.
If you have any questions about this webinar, please do not hesitate to reach out. Send Cliff Patterson an email at cpatterson@lunageo.com or book a meeting at doodle.com/bp/cliffpatterson/book-a-meeting
Hi. This in an awesome seminar! I’d been oooking for examples on how to set up an enterprise GIS with open source tools and this has been of great help. I’d like to ask you: if I’d be to offer this kind of services to municipalities in my country: would it be possible to integrate with cloud services such as AWS? I guess Luna has its on on premise servers to do this job
The answer is yes! We deploy PostgreSQL/PostGIS databases and cloud-based servers to clients of various sizes, from small teams (<10 users) to environments with hundreds of users. So far we have never encountered a situation where the combination of PostgreSQL/PostGIS and QGIS failed or was not able to meet a client's requirements. It is a very powerful combination used by organizations around the world. Check the PostGIS Day videos for more specific use cases.
@@lunageospatial 100 GIS transactional postGIS long-transaction users ? (viewer don't count) Can you name the organizations? Of course it could be done, but skills and educational/documentation collateral for supporting an enterprise openGIS are just not there. Also, many many corporate CISOs refuse to allow QGIS on desktops (or QGIS Server) It's just a fact.
@@NeverTakeNoShortcuts We talk a lot about the various myths of open source GIS. One of the biggest myths is that there is a lack of documentation, support, and training for enterprise clients. Not only is there exceptional documentation for most mature GIS software (e.g. QGIS, PostGIS, Geoserver), there is also a wealth of other resources out there -- books, training courses, professional support. One thing we do at LunaGeo is help clients migrate to open source GIS by offering implementation consultation, training for basic and advanced end users, and ongoing support. However, if a company flat out refuses to consider open source GIS, it is simply their loss. If big cities like Toronto can use open source GIS and many governments, including various branches of the Canadian, US, NZ, Austrialan governments, it not out of reach for any company.
I love the idea of using materialized views as "releases." And because they've been materialized, that allows you to keep older "versions" as it were, in case you need to roll back changes?
Question: If happens that you have a whole cadastral plan in CAD as dwg file and you purposely wanted to integrate it inside the QGIS as part of database. You need to import it one by one or you just need the description to run?
Great job! Whats important to know when DBMS lets say PgAdmin is used in a multyuser environment? are there any other programs that need to be installed or is it just as simple as installing DBMS on a shared server (and obviously instead of localhost entering a path to a server location for every single connection). Thanks!
This can all be done in the database as foreign keys and then you can build a custom attribute form in QGIS. See our other webinars for example or reach out if you need help.
What are your preferred solutions for a web front end content management and delivery? I've now successfully built a simular system hosted on Azure using PostgreSQL/Geoserver Cloud Native and am using OpenLayers to make my front end web map and it works fine for me, but I am wondering if there is a no-code or low-code Open Source web front end that would contain a collection of maps and data in a single portal that doesnt require custom web coding.
I just watched your BC video and you answered this question in that video. For anyone wondering, options are Leaflet/Open Layers for the maps and GeoNode for a web content portal.
@@devoidbmx1 The short answer is that there isn't a single low or no code solution for WebGIS, which is why we build custom solutions for our clients. Geonode is one option, but the setup is not for the faint of heart. There are a few other projects on the OSGeo website www.osgeo.org.
Attribute = noun(1) কোনো ব্যক্তির বা বস্তুর বিশেষ বৈশিষ্ট্য, ধর্ম বা গুণ; (2) কোনো ব্যক্তির বা তার পদের প্রতীকরূপে কল্পিত বস্তু; (3) বিশেষণ; verb(1) আরোপ করা; (2) কারণরূপে নির্দেশ করা; (3) কোনো ব্যক্তি বা বস্তুর গুণমান বা বৈশিষ্ট্য নির্দেশ করা;
This is the best introductory video I have watched on the topic. Amazing job. Thank you so much. I’m struggling to see practical applications of creating a geodatabase as a recent user. Do you have by any change an idea 💡 for a mini project where I have to create a spatial database in postgres and then display the map on arcgis pro/qgis?
Hi Cliff, I've already watched several times this very useful video💯 and I think it's one of the most complete on the use and potential of geopackages. However, I continue to have a difficulty that perhaps is trivial for you. Once in a big gpkg, in addition to the various layers, styles and print layouts, I have also saved some connected projects, how can I subsequently remove one (o more) of these projects from the gpkg without corrupting it?
I want to point out that you explained you are using ortho linear tiles. When I follow the link I am presented with data in mrsid format. This introduces another step that is not mentioned here or am I confused? Getting the mrSid for any county in Ohio is fairly straightforward. Now I want to serve that overhead data to our mapping application via wms. How do we go from the sid file to geotiff to be able to even build the vrt? I have tried condensing it into a Geo package but that was still 1/3rd the size. Sid file was 35Gb Geo package was 15Gb, and after two hours of these videos which are helpful but haven't introduced any more information into solving this particular issue. I have a 35GB sid file that I would like to serve both to our application via wms. Preferably without it taking hours to serve 15GB over the internet. I keep hearing the work geotiff but have yet to see one unless you zoom all the way in and download each individual geotiff file. Can you help?
nvm heard you say you wrote a scrip to get the individual tiles. there has to be a way to extrapolate the tiffs from the already provided sid format or is this only available via arc map enterprise?