Jump to content


Inactive Members
  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About artjom872

  • Rank

Profile Information

  • Gender

Recent Profile Visitors

524 profile views
  1. I would like to get opinions and experience about GIS servers. Lets assume that we need to host our data and use them internally as well as sell them to others. "Everyone" is using ESRI ArcGIS Server. But there is also GeoServer and MapServer (these need other software to bridge the gap between ESRI). ESRI option is expensive but others lack GUI, ease of use and some functionality. So: - What would you suggest me to consider in choosing between options? - How they compare (management, functionality, administration)? Now there is ArcGIS Enterprise. So feature looks more like ArcGIS Pro together with Portal? As I understand than anyone connecting to Portal needs license (or only those that want to publish something)? Could you share your experience? How whole Portal experience compares to open source alternatives (GeoServer with GeoNode with OpenLayers)? There is page at: https://gis.stackexchange.com/questions/100273/comparison-of-open-data-portal-solutions Which country national cartography and topography agencies are using free or open source GIS software at the back end? Could you share knowledge and experience of why should I choose to buy ArcGIS for Enterprise instead of using free alternatives?
  2. Could you share your experience programming GIS software extensions. How about web back end - Java, PHP, .NET? What language should complex system use? What is the best language for developing extensions for specific software: - QGIS (Python) - ArcGIS for Desktop (ArcObjects, ArcPy, .NET, Java) - ArcGIS Pro (ArcPy, .NET) ? What about functionality, speed? What tools do you use: - IntelliJ IDEA? - Visual Studio for .NET? - What Python IDE? What is going to be used in feature? .NET is not going away for a while. Python is increasingly used but from time to time there are things or extensions that doesn't work.
  3. artjom872

    GIS databases

    I would like to get opinions and experience about GIS databases. In this case ones that are used for large topography, cartography and related dataset creation and publishing. So lets imagine that we have the following databases to choose from (you can freely add others, that have native GIS types and ESRI support): Oracle (PL/SQL) - native GIS or ESRI option - wide applications, very expensive SQL Server (T/SQL) - native GIS or ESRI option - easy administration, expensive PostgreSQL (PL/pgSQL) - native GIS or ESRI option - hard configuration, cheap (support) In those we can build GIS datasets without ESRI price tag and with it if choose to buy ESRI licenses. All three of them have database side language for making custom procedures, functions that help organize things. A lot of people in my country have invested in Oracle database knowledge and certification. So it is easy (there is always lack of people with programming, database and administration skills for certain amount of salary) to find corresponding people. But that all comes with the price tag (Oracle is not AIO, for every additional feature that it alternatives is already included you have to pay). Lets work under assumption that there are equal number of professionals for every database. There are two other big names: PostgreSQL and SQL Server (and probably DB2). From the pricing perspective both are at least times cheaper. As I understand than there are specific aspects to each of them. How do they compare (why should I choose one over the another): - Could you name the most important aspects? - How common are geometry errors? What other problems have you experienced (like ESRI ST_Intersects errors or other)? - What is the best tooling for administrating and developing in these databases (price, ease of use, functionality - Oracle SQL Developer Studio, MS SQL Server Management Studio, pgAdmin, TOAD)? - What about security - how easy is configuration for novices? - How hard is it to properly configure and administrate specific database? - What can I do with data if I use ArcGIS, and what if I use QGIS? - What about ArcGIS Geodatabases vs native GIS data types - availability of tooling (ArcGIS cant edit PostGIS)? - Would migration be worth it and if you have experience what was the hardest thing, given pricing (migrating code)? I do look towards PostgreSQL because of pricing. What would I miss? How future would look like in databases? Ideally those that have experience with at least two of the mentioned databases (one preferably being PostgreSQL) would respond.
  4. Unlikely change but it would be nice if "elUserNav" would be appended with dedicated icon for followed content (with number indicating how much of followed content have been updated - similarly to notifications icon). Right now it is under "cUserLink" -> "Manage followed content". It is somewhat strange to manage followed content but not be able to view and get updates on it. Of course it could be that it is limited by design "invisionpower"?
  5. I still have not used it myself but know there is this option: https://letsencrypt.org
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.