| 3 | | ===== How to start ===== |
| | 4 | 1. Technische Bedingungen: |
| | 5 | - Wo liegt Mappit? Welche Version? |
| | 6 | http://mappit.mpiwg-berlin.mpg.de/mappit/ |
| | 7 | |
| | 8 | - Wo liegt die Dokumentation? |
| | 9 | https://it-dev.mpiwg-berlin.mpg.de/tracs/GIS/wiki/WikiStart |
| | 10 | über Link in Oberfläche: Manual |
| | 11 | |
| | 12 | - Was muss ein Benutzer wissen, können oder auf seinem lokalen Rechner etwa installieren (besondere Plugins für Webbrowser o.ä.), um Mappit zu benutzen? |
| | 13 | Aktuelles Firefox oder Safari |
| | 14 | |
| | 15 | 2. Wie muss die Excel-Tabelle beschaffen sein, die in Mappit eingelesen wird? |
| | 16 | - Gibt es hier eine maximale Anzahl von Spalten? |
| | 17 | Nein |
| | 18 | |
| | 19 | - ID-Spalte: wie muss die ID beschaffen sein? |
| | 20 | Allgemeine ID: alphanumerisch |
| | 21 | |
| | 22 | - lat/lon-Spalte: sind zwingend Dezimalangaben? |
| | 23 | Ja |
| | 24 | |
| | 25 | - Benennung und Reihenfolge der Spalten? |
| | 26 | Kleinbuchstaben, „_“ anstelle von Leerzeichen, keine Sonderzeichen |
| | 27 | |
| | 28 | - Ausgabe-/Speicherformat ist aber xml? |
| | 29 | Speichern in Excel als „XML-Spreadsheet“ |
| | 30 | |
| | 31 | 3. Wie erzeugt man die verschiedenen Layer? |
| | 32 | - Alle Daten in einer Exceltabelle? Wie angeordnet? |
| | 33 | Eine Tabelle pro thematischem „Layer“ |
| | 34 | |
| | 35 | - Oder mehrere Tabellen? Wie angeordnet? Welche Daten müssen in den Layer-Tabellen unbedingt auftauchen (ID?)? |
| | 36 | Erforderlich: Ortsangabe über Lat./Lon oder CHGIS-Id |
| | 37 | Für Europeana4D: Zeitangaben (entweder Timespan oder Timestamp) und mindestens zwei Datensätze (Zeilen) pro Tabelle |
| | 38 | |
| | 39 | 4. Haben die Karten mit den Layern eine referenzierbare URL? |
| | 40 | - Wie kann ich die auslesen? |
| | 41 | Wird noch implementiert: in der Multi-Layer-Map, Button „New Window“, Adresszeile gibt speicherbare URL an. |
| 14 | | * Delete complete user tables. |
| 15 | | * Add/Drop attributes to/from user tables (selectable datatypes: date, integer, location, text and numeric). |
| 16 | | - Choose a name for the attribute. |
| 17 | | - Choose one of the five data types. |
| 18 | | - Press "Refresh" to list the existing attributes. |
| 19 | | * Sub-Function "Data Upload" |
| 20 | | - Select an empty table from the list in the lower left frame. (If there is no table available yet, choose "Table Administration" and create a new empty table first.) |
| 21 | | - Browse through your files and choose the datafile. |
| 22 | | * The datafile should have the following format: |
| | 52 | * Generate empty (Multi-Layer) Maps |
| | 53 | * Generate tables from *.xml-Files. |
| | 54 | * The datafile should have the following format: |
| | 55 | * create table in Microsoft Excel |
| 24 | | * all attributes are separated by a simikolon: ';' |
| 25 | | * the number of data per row must correspond exactly to the number of columns (attributes) of the specific databasetable (defined in "Table Administration") |
| 26 | | * the type of data must correspond to the datatype chosen for the databasetable defined under "Table Administration" (if in doubt choose "text", as it excepts all strings) |
| 27 | | - Upload the datafile. |
| 28 | | * You may check it in the text-window. |
| 29 | | * Send the file to the database by clicking the "Load File" button. |
| 30 | | * If the content of your datafile is not shown (you may only see "{}"), please go back to the previous step und upload the datafile again. |
| 31 | | - The number of successfully loaded datasets will be shown. (If the number is "0.0", press the "Refresh"-button.) |
| 32 | | - To check the success of the upload, please go to Sub-Function "Edit Datasets" |
| 33 | | * Sub-Function "Add Datasets" |
| 34 | | - Select a specific user table in the lower left frame and press "Add dataset". |
| 35 | | - Specify a new dataset by entering attributes in the main frame. |
| 36 | | - Press "Add new dataset" to save and continue specifing the next dataset. |
| 37 | | - To see or edit the datasets, go to sub-function "Edit Datasets". |
| 38 | | * Sub-Function "Edit Datasets" |
| 39 | | - Select a specific user table from the list in the lower left frame and press "Show to alter". |
| 40 | | - Specify a dataset-range to show within the table and press "List sub-selected datasets". |
| 41 | | - Select a specific dataset and press "Show dataset" to edit. |
| 42 | | - Edit the values of the dataset and press "Save dataset" to save the the alterations. |
| 43 | | - Select the next dataset to edit. |
| 44 | | |
| 45 | | ===== Main-Function "Search and Mapping" - Table Query ===== |
| 46 | | |
| 47 | | |
| 48 | | **This function allows the user to select datasets from an user-table, to show the related locations in a map and to add further spatial objects.** |
| 49 | | |
| 50 | | - Select a database-schema from the list in the middle left frame. Each database-schema represents a folder, which may contain a number of tables. The ChinaGIS database consists of two schemas: |
| 51 | | * "User Tables" => user specified tables, which can be related to the "sys_id"-attribute of the geodata-layers in chgis |
| 52 | | * "China Historical GIS" (chgis) => original geodata-layers from [[http://www.fas.harvard.edu/~chgis/data/chgis/|the China Historical GIS]] |
| 53 | | - Select a table/layer from the lower left frame |
| 54 | | - Specify: |
| 55 | | * the attributes to be shown in the dataset-table |
| 56 | | * the query for at least one selected attribute and |
| 57 | | * the attribute, which will be used to relate to the "sys_id"-attribute of the geodata-layers in chgis. |
| 58 | | - "Run Query" presents the number of so far selected datasets. The range of datasets to show can be specified in the upper right part of the central frame. |
| 59 | | - The table shows the specified datasets. |
| 60 | | * Select the datasets you want to display and press the "Selected" button to generate the map. |
| 61 | | * Alternatively press the "All" button to display all datasets. |
| 62 | | - The map will be generated. If the central screen remains empty, press the "Refresh"-button (the server is often slower than the browser). |
| 63 | | * The map area should now show a map with one or more red "markers". These markers are clickable and provide additional information about the location. If there are multiple datasets for one location, the marker-dot will increase and after clicking on it, the datas will be shown in "tabs". |
| 64 | | * The right "legend"-frame presents some additionally available geodata-layers, wich |
| 65 | | * can be included by specifying a reasonable time-range and hitting the "Load Layer"-button |
| 66 | | * can be excluded by specifying an "unreasonable" time-range (like from -9999/12/31 to -9999/12/31) |
| 67 | | |
| 68 | | ===== Main-Function "Spatial Query" ===== |
| 69 | | |
| 70 | | * still empty |
| 71 | | ===== Main-Function "Mapping" ===== |
| 72 | | |
| 73 | | * Sub-Function "SQL-query": |
| 74 | | * Early test function to show the results of a SQL-query on geometry-layers in the map. |
| 75 | | * May be used, if regular SQL-queries are known. |
| 76 | | * !!!Errors are not caught!!! |
| 77 | | * Sub-Function "Coordinates" |
| 78 | | * Early test function to show a marker at specified coordinates on the map. |
| | 57 | * all attributes are in separate columns |
| | 58 | * first row contains the column names (no special characters like $§ or &!) |
| | 59 | * for latitude and longitude write decimal degrees only! |
| | 60 | * save the table as XML-SPREADSHEET |
| | 61 | * Select the xml-file from your system. |
| | 62 | * Name the new table (you may use old table names to overwrite these tables!) |
| | 63 | * Click the Upload-button |
| | 64 | * Select the datatypes for the columns, like "coord_lat" and "coord_lon" for the coordinates or "from_date" and "until_date" für timespans |
| | 65 | * Open the table as a layer |
| | 66 | * Specify the layer name and visualization parameters |
| | 67 | * Save the layer first and THEN open it in a multi-layer map. |
| | 68 | * Open layer in a mulit-layer map |
| | 69 | * Specify the name of the map and additional layers (to add more than one layer, reload the hwole page, then open the map and add then one more layer) |
| | 70 | * Save the map |
| | 71 | |
| | 72 | == Main-Function "Open" == |
| | 73 | * Open user tables. |
| | 74 | * Open saved layer |
| | 75 | * Open multi-layer maps |
