{"id":1310,"date":"2017-12-07T14:25:29","date_gmt":"2017-12-07T14:25:29","guid":{"rendered":"https:\/\/max-drake.cc\/?p=1310"},"modified":"2020-07-10T21:04:03","modified_gmt":"2020-07-10T21:04:03","slug":"openmaint-gis-localhost-part-2-partial-success","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=1310","title":{"rendered":"OpenMAINT and GIS on Localhost. Part 2"},"content":{"rendered":"

 Part 2.<\/h3>\n

At the end of part 1<\/a> I was left with openMAINT not recognising postGIS.<\/p>\n

At the end of part 2 I have the map in openMAINT, but no building icon on the map, or plan of building either, but there is a progression.<\/p>\n

After configuring openMAINT as per the CMDBuild documentation, I decided to go exploring in other areas and investigate PostGIS and GeoServer. So Mr YouTube was my friend.<\/p>\n

This first video<\/a>, in Arabic, but just watch the process shows a couple of things:<\/p>\n

    \n
  1. The fact that PostGIS needs to be activated as an EXTENSION in PostgreSQL database<\/li>\n
  2. The link between geoserver & postGIS<\/li>\n
  3. How to start up and link the 2 together.<\/li>\n<\/ol>\n

    Item 1\/ Above, I went looking on the postGIS website  insta<\/a>ll section and saw that there was an activation process, as it says, do not do in the posgres<\/strong> database.\"\"<\/p>\n

    I used the first line:  — Enable PostGIS (includes raster) CREATE EXTENSION postgis;<\/em><\/p>\n

    Testing it in SQL in pgADMIN3.
    \n\"\"<\/p>\n

    I have chosen a deatabase  “omback” to run the SQL query on. And got an ERROR.<\/p>\n

    \"\"<\/p>\n

    It is looking for the postgis.control file in a directory share\/postgresql\/extension<\/p>\n

    Whereas in my setup this file is sitting in a directory share\/extension<\/p>\n

    \"\"<\/p>\n

    So, I copied a lot of the files from the share\/extension<\/strong> directory to  share\/postgresql\/extension <\/strong>and got a further error inv that it couldn’t find a $lib <\/strong>directory.<\/p>\n

    I searched online about this issue and the common theme was that I loaded up the programme wrong.<\/p>\n

    My original load was PostGreSQL 9.3 then loaded after postGIS.<\/p>\n

    From the video tutorial above<\/a> I saw that the process was a single download of postgreSQL with Stackbuilder which installed postGIS for postgreSQL, as it downloads the version that is compatible.<\/p>\n

    So I went back and downloaded the combined installer here<\/a>.<\/p>\n

    \"\"<\/p>\n

    Follow link, chose version, choose operating system and then download.<\/p>\n

    BACKUPS & More BACKUPS<\/h3>\n

    So I backed up all my databases, remember to backup “alfresco’ too!!!<\/p>\n

    Also, I backed up INDIVIDUALLY<\/p>\n

      \n
    1. public schema<\/li>\n
    2. gis schema<\/li>\n
    3. shark schema<\/li>\n<\/ol>\n

      Make sure you back them all up as you may be using these later.<\/p>\n

      Then I deleted my postgreSQL installation and reinstalled it. I deleted the original directory.<\/p>\n

      You may have to reboot a couple of times and check your postgres SERVER is off in your windows task manager), then I created the same directory and installed postgreSQL back into it (then the tomcat maps to it as per the original if all the directories\/sub directories are the same).<\/p>\n

      If you don’t put it in same directory I think you may need to set up openMAINT from scratch (not absolutely sure on that though)<\/p>\n

      \"\"<\/p>\n

      I then created a blank database and restored my Database for GIS\/Public\/Shark (the openmaint setup) then tried to install the extension postGIS but again had problems.<\/p>\n

      So I installed the postGIS extension first and then loaded up the other schemas (public\/gis\/shark) and then  ran openMINT, and again it did NOT recognise the postGIS installation!!!! AAAAAgghh.<\/strong><\/p>\n

      In fact, you have to run the SQL on all the extensions above, then it works:<\/p>\n

      -- Enable PostGIS (includes raster)\nCREATE EXTENSION postgis;\n-- Enable Topology\nCREATE EXTENSION postgis_topology;\n-- Enable PostGIS Advanced 3D \n-- and other geoprocessing algorithms\n-- sfcgal not available with all distributions\nCREATE EXTENSION postgis_sfcgal;\n-- fuzzy matching needed for Tiger\nCREATE EXTENSION fuzzystrmatch;\n-- rule based standardizer\nCREATE EXTENSION address_standardizer;\n-- example rule data set\nCREATE EXTENSION address_standardizer_data_us;\n-- Enable US Tiger Geocoder\nCREATE EXTENSION postgis_tiger_geocoder;<\/pre>\n
      Now, as I was in multiple installation mode, I only setup my restore database partially.  I just wanted to test to see if the GIS section could be activated, and it was.<\/p>\n
      The OpenMAINT initialisation<\/h3>\n
      (Note in image below I have latitude and longitude the wrong way around.<\/em> )<\/p>\n
      \"\"<\/p>\n
      This is for initialising the GIS<\/p>\n
      Then go to item 6 above<\/p>\n
      \"\"<\/p>\n
      The icons I used are from Freepik on the flaticon.com website. You are allowed to use for free but have to acknowledge the author. Thankyou Freepik.<\/p>\n
      \"\"<\/p>\n
      \"\"<\/p>\n
      \"\"\"\"<\/p>\n
      For item 5 I am using a shape file that I generated in QGIS. So see below for the explanation of how that was created\/saved.<\/p>\n
      Also, in the video at the start<\/a>, it shows how he uses a plugin in postgres  to import a SHP file into postGIS database (into a new table). I am still figuring all this out.<\/p>\n
      \"\"<\/p>\n
       <\/p>\n
      openMAINT Administration Module<\/h3>\n
      So, as far as setting up goes, I have done a preliminary setup , and on the Administration panel I have, the map.<\/p>\n
      Unfortunately I cannot stick pins into it. So map with no content.<\/p>\n
      The  main tab has a map icon in the top right corner now.<\/p>\n
      \"\"<\/p>\n
      clicking on the map icon shows you the map and a data box to the right with 3 tabs.<\/p>\n
      Where the map icon was is a grid with list, click on that and it takes you back to the previous image.<\/p>\n
      The thematism next to the the list icon. See this video from CMDBuild<\/a> where they talk about it ( go to about 15 minutes into the video)<\/p>\n
      \"\"<\/p>\n
      \"\"<\/p>\n
      The 3 tabs are shown in these 3 images, I’m still trying to figure out what they mean.<\/p>\n
      \"\"<\/p>\n
      So, at this point, I have a map in openMAINT without any map icons in the map relating to my buildings. Note, as I deleted my original database setup currently I have basic openMAINT data but have not got shark workorders or Alfresco running in this instance.<\/p>\n
      This is fine at present, as I am just trying to understand the GIS part, but it all needs to come together so all components work.<\/p>\n
      Geoserver, part 2. Connecting to postGIS schema<\/h3>\n
      Now I want to go and look at some of the Geoserver items.<\/p>\n
      As I was trying to figure the map in openMAINT out I came across information about Geoserver. I am still not sure if its needed for pins in map, or if its only used for overlaying Vector information (rooms\/plans etc) onto the map, but as this is all part of the GIS stuff I will put down what I have found.<\/p>\n
      \"\"\"\"\"\"\"\"\"\"\"\"<\/p>\n
      QGIS.<\/h3>\n
      Within the whole GIS area there is a lovely programme called QGIS, which is a pretty impressive programme that is free. I had played with it before for another exercise<\/a>.<\/p>\n
      Download it here<\/a>. A basic beginners guide to QGIS here<\/a>.  I focused on layers, saving them and points (for putting flags in openMAINT) and saving SHP files.<\/em><\/p>\n
      My objective with this programme was to create some coordinates and save them to a SHP file that I could either download into Geoserver or postGIS.<\/p>\n
      This was successful. I created the data, it may be a bit limited and I may need to develop it further, but the zipped file can be downloaded here<\/a>.<\/p>\n
      Although I got the shape file into Geoserver & postGIS I still was not able to have a point on the map with a flag\/icon on it. This is for a future blog. A bit more research required.<\/p>\n
      Beware. Because this is a pretty sophisticated programme it needs a bit of power from the computer, so if you have a light computer it will be slow.<\/em><\/p>\n
      \"\"<\/p>\n
      Conclusion<\/h3>\n
      At the end of this we have done the following actions:<\/p>\n
        \n
      1. Reinstalled the postgreSQL database and postGIS add-in<\/li>\n
      2. Made a postGIS set of extensions (7) for a total of 8 extensions in postgreSQL<\/li>\n
      3. Used QGIS to create a SHP dataset of points that can be saved as a file<\/li>\n
      4. Have Map working in OpenMAINT after a basic configuration<\/li>\n
      5. Have Geoserver connected to postGIS schema? or are we linked to the database?<\/li>\n<\/ol>\n
        What we haven’t got working, at this point because of the test environment focusing on the GIS<\/p>\n
          \n
        1. Shark & Alfresco, as we rebuilt the database<\/li>\n
        2. Icons on the map in openMAINT related to the building that we want to associate it with.<\/li>\n<\/ol>\n
          So in reality, we haven’t got too far at all. Hopefully the next installment will answer a few more questions.<\/p>\n
          I would like to point bout that there is nothing in the openMAINT or CMDBuild about the extension requirements of postGIS in the postgreSQL database. They really are not a helpful bunch of people. I honestly do not understand why they are calling this open source if they do not give you the fundamentals to set it up. I believe that the university set this up, not tecnoteca, so they are just maintaining it to their own advantage.<\/p>\n
          What is getting my head scratching is why is there NOT a simple Longitude\/Latitude cell to put in coordinates of the building? Floor?Room?Component?<\/p>\n
          Do we need to create these attributes? they should logically just be in there.<\/p>\n
          Another test I could do is to take the original database DEMO and install it to see if there are Longitude\/Latitude attributes to fill in.<\/p>\n","protected":false},"excerpt":{"rendered":"
           Part 2. At the end of part 1 I was left with openMAINT not recognising postGIS. At the end of part 2 I have the map in openMAINT, but no building icon on the map, or plan of building either, but there is a progression. After configuring openMAINT as per the CMDBuild documentation, I decided […]<\/p>\n","protected":false},"author":1,"featured_media":1343,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7,9],"tags":[16,112,113,53,54,145,144,114,143,146],"class_list":["post-1310","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-maps","category-openmaint-assettiger","category-openmaint-setup","tag-amfm-data-management","tag-cafm","tag-cmms","tag-facility-management","tag-facility-operations","tag-geoserver","tag-gis","tag-iwms","tag-openmaint-gis","tag-qgis"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-27.png","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-27.png","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/1310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1310"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/1310\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/1343"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}