Home

Appendix - INGV - Istituto Nazionale di Geofisica e Vulcanologia

1. I 2D flatshaded 28 30 HE31 432 39 134 3D hillshaded 128 130 31 32 i133 134 I iberia 4Huk 31 32 33 34 layers_eq kmi 28 Latlantic_islands 30 iberia uk 31 france italy whole europe rn rn oo O ei HHfennoscandia eastern europe L wo e ee ee oo gt ha L aegean layers mdp 28 l_ atlantic_islands 90 Liberia fu 31 france A MIDOP internal file structure MIDOP homepage folder for common CSS and Javascripts Cursor image used when dragging the map mouse button pressed Javascript for sorting tables content in seismic histories Javascript for sorting tables content in seismic histories Cursor image used when the mouse is over a map mouse button not pressed CSS used when printing pages CSS used for visualizing pages CSS used for visualizing MIDOP control panel pages CSS used for visualizing pages folder for raw data for generating maps and caching outputs folder for pre generated raster DEMs folder for 2D flat shaded DEMs folder for 2D flat shaded DEMs in UTM 30 zone folder for 2D flat shaded DEMs in UTM 30 zone folder for 2D flat shaded DEMs in UTM 31 zone folder for 2D flat shaded DEMs in UTM 32 zone folder for 2D flat shaded DEMs in UTM 33 zone folder for 2D flat shaded DEMs in UTM
2. elements e no styles must be specified Styling the layer is possible within the dedicated control panel window below available both for layers in the EQ map and MDP map page Through the visual interface can specify both the fill and the stroke style and the layer opacity transparency Layer D02 countries utm32 layer style i layer opacity 100 i stroke Iv i fil v 1 stroke width 600 i filecolor FFO000 A i stroke color 0368CC 2 2 fil opacity 45 Li stroke opacity 100 T A Example style output Li stroke miterlimit none y ETES a i stroke dasharray none y i stroke dashoffset none y dw i stroke line cap round i stroke line join round New geographical layers can be created for example from ESRI shapefiles shp extension These files must be already projected using the corresponding UTM zone to the geographical area where they are going to be used The conversion can be done using the freely available shp2svg Neumann 2007 utility at the CartoNet website http carto net papers svg utils shp2svg composed by two MS Windows executables ogis2svg exe and shp2pgsql exe that works in the Windows Command Prompt The conversion is done entering the following command OU91L1S4SV9 exe input your shaperile output Svg output Ill6e svg roundval 1 80 NA4 D7 Part 2 Improved macroseismic web mapping
3. 31 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual If you decide to alter change correct your data directly in MySql using phpMyAdmin we advice you to keep trace of all of them or you ll end up with a data set which will not correspond to your initial data resulting in odd situation later Data upload via CSV text file e open the table that you want to load in MySql and do a bit of cleaning o if the first line is a header with the name of each column content delete the entire row o inorder to avoid the import of unwanted content delete some column and rows at the end of the table apparently empty cells might contain spaces and they will be exported e from the spreadsheet export a CSV file Comma Separated Value for each table the output is a plain text file The character used to delimit each field content depends on your operating system regional settings in order to know which character is used open the exported CSV file using a standard text editor Usually a semicolon or a comma character are used e turn on both your Apache and MySql server if needed e open a browser and surf to your phpMyAdmin folder e access your database or create a new one e for each table that you want to import into MySql o create a new table containing a field for each column of your spreadsheet table o click on the import tab and load each of your CSV file o Specify which character is used as field delimiter F
4. Create primary key Help JC Cancel Next gt Create e OpenOffice will now ask which columns must be copied select all the fields by pressing the double arrow BOX Apply columns Existing columns EQgroup EQgroup_label scope EQid_archive MDPid_archive Study_code Study 4 9 0 For more information on OpenOffice Base usage refer to http wiki services openoffice org wiki Database Your midop database in the MySql server contains now your data table and the MIDOP package can now use your data A Linux Ubuntu In order to use OpenOffice Base with MySql tables the ODBC Open Database Connectivity http en wikipedia org wiki ODBC system drivers must be installed 1 install these three packages entering the following command in a terminal sudo apt get install unixodbc libmyodbc unixodbc bin 2 launch the ODBC configuration tool with sudo ODBCConfig 41 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 3 Click the System DNS tab and click the Add button Q ODBC Data Source Administrator OO O G9 User DSN System DSN Eie DSN Drivers Stats Advanced About Name oescrpton ore Configure System data sources are shared among all users of this machine These data 3 gi sources may also be used by system services Only the administrator can configure SEE system data sources 4 click Add ag
5. Part 2 Improved macroseismic web mapping tool MIDOP manual array in its turn is contained in another array called symbol epicentre e g symbol_epicentre name_of_the_symbol Note that the symbol name must not contains spaces nor special characters 2 unique identifier definition Note that the code of the map is written in SVG and the specified identifier of each object must be unique in order to let the JavaScript command getElementByld operating correctly on the DOM Document Object Model 3 SVG shape definition code Note that symbols must be inscribed in an rectangle of 3000 by 3000 in order to be homogenous 4 define if the symbol will be used when creating the final map SVG code This is useful in order to turn on 1 and off 0 plotted symbols without the need of deleting the symbol itself Below the source code used for defining the rectangle Ssymbol epicentre SquareBlack new stdClass Ss ymbolL epzeencre SquareBlack e ad 1d5guareBlbackt symbol epzeentre l SquareBlack symbol rect XUL L500 width 3000 height 3000 stroke 000000 stroke width 500 fill FFFFFE Symbol epicentrel sSquareBlack gt onoff i Custom layers Geographical layers in MODOP are plain text files containing SVG elements Before trying to create such files you can find further information on the SVG specifications at the W3C website http www w3 org TR SVG Layers are store
6. Quiero System DSN Drivers Tracing Connection Pooling About Name Description Driver Add Remove Configure An ODBC User data source stores information about how to connect to the indicated data provider A User data source is visible only to you Revert Apply N id Click the lock to prevent further changes 5 Select the appropriate driver used by the ODBC connection Choose A Driver Driver MySQL ODBC 5 1 Driver n F Cancel 6 Insert the name of the ODBC connection something that will help you later remember where the connection is pointing to for example midop on localhost the server name localhost the user name and the password in order to connect to your MySql server in the Connect Options tab insert 3306 as the port number and Applications MAMP tmp mysql mysql sock J as the used socket 3 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Connector ODBC 5 01 0005 Add Data Source Name Connector ODBC Login Connect Options Advanced Connector ODBC Configuration l This dialog is used to add a Data S N ata Source Name midop on localhost Data Source Name DSN Description Server localhost Passworc Database midop v Diagnostics gt gt Ok Cancel Connector ODBC 5 01 0005 Add Data Source Name Connector ODBC Login Connect Options Advanced Connec
7. Y Neries NEtwork of Research Infrastructures for European Seismology Deliverable D9 Appendix Improved macroseismic web mapping tool MIDOP manual June 2010 Activity Distributed Archive of Historical Earthquake Data Activity number NA4 Task 2 Task 3 Deliverable Improved macroseismic web mapping tool MIDOP manual Deliverable number D7 part 2 Responsible activity leader M Stucchi Responsible participant INGV MI Author M Locati and A Cassera Sixth Framework Programme EC project number 026130 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Index di ndo e Ue UO BA mec 5 2 Quick reference 5i e tea e i 7 2 OUTOUEC KANDI OS LU 8 3 Setting up the MIDOP environment ccccseseeesseeseeeeceeneeeeseeneeeseeeseeeseeesseeseoeseeesoonneessooaes 11 3 1 Requested software configuration i 11 OU AB rie i i venei isrannu iii 18 4 INPUT Gala preparation tcn 19 4 Datamanagementi acli di do ds 19 tz input data table Tomas dis 20 Earthquake catalogue table A ias 20 Macroseismic intensity data table oooccconcconcconoconoocnoonncnnnnonocanocanocanenanenanens 21 Map Teterence Dacia ias 25 4 3 Macroseismic earthquake studies i 26 References or sources used seen sene nsns nsa sse nasa nsn nnns 27 4 4 Uploading Gala Into MY SO ica A A a 28 Mal database ChE ANON atan adas
8. i My Data Sources E My Music My Documents jo My Pictures gt File name My Network Places Files of type Link HTML Documents html hm Outlook Paradox db Text Files kxk t co t tab asc Windows SharePoint Services Select Data Source File Data Source Machine Data Source Type Description Excel Files User MAPSERVEH Studies User User MS Access Database User MERIES User repertori User studies User Visio Database Samples User 4 k Mew Cancel Help NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 4 Select the table or tables by multi select using the shift key that you want to link 5 6 Link Tables a ES Tables Storage olial006 catalogue Cancel aliali IU n d j Select All Deselect All Save password It might happens that Access cannot automatically establish which is the table unique record identifier in such cases you must select the identifier field manually Select Unique Record Identifier 7 x Fields in table olial006 cataloguel To ensure data integrity and to update records vau must choose a field or fields that uniquely identify each record Select up to ten fields Once the procedure is finished the requested tables will show up in the Access Tables section You can distinguish between local and remote MySql tables intuitively as they use a
9. 1209 Appennino abruzzese 1246 SPOLETO 1258 Barrea 1276 Orvietano 1277 SPOLETO 1279 CAMERINO 1257 ABBADIA 3 1298 Rieti pp 9 9 B 9 RB HOD H ye HIP HH J ity 6km O O Mw 3 75 4500 25 5500 25 6 50 0 25 macro o O O 4 00 0 25 5 00 0 25 6 00 0 25 gt 6 75 Query by earthquake General earthquakes map zoomed NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual homepage query by place query by earthquake Select an earthquake by clicking on the date Year Mo Da Ho Mi Se Epicentral area LJ DL ic af rJ Ls 1367 Sant Elia Fiumerapido 1414 08 07 TOSCANA OCC 1420 SIENA 1436 03 SIENA 1439 02 Grottaferrata 1449 Asciano 1456 Molise Val Tiberina Citt di Castello Aquilano GUBBIO L quila GUBBIO l C J c QD Hd adi di ee b A oO Hd O nnn 1456 12 05 03 Molise Study Meletti et al 1988 O Epicentre Bx 7 22 0 15 41 302 14 711 n of MDP 199 max Int 11 Place Bojano Fragneto 1 ibate Paduli Apice vecchio Ariano Irpino Ariano Casalciprano Frosolone Isernia Macchiagodena Pesco Sannita Pescolama S Polo Matese S Polom Vinchiaturo Campochiaro sa ls e m ooo o Casalduni MCS 33 AS cO Tg EE a STONE Limata dd O 9 e o O Mirabella Eclano NF 3 4 F 45 56 6 7 7 8 8 9 940 10 11 homepage query by place query by earthquake Select an earthquake by clicking on the date Year Mo Da Ho Mi Se Epicentral area 1420 SIENA 1436
10. Description ReflD Reference source unique identifier text or number Simplified code representing the study StudyCode Trailing spaces and special characters must be avoided aiu epe field used to link to the corresponding field in the earthquake catalogue and used for naming study related PDFs and images 2f NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Simplified code representing the reference source RefCode Trailing spaces and special characters must be avoided text or number Complete bibliographical citation of the study with authors year of RefCitation publication title and publisher long text RefYear Year of publication of the reference source integer RefAuthor List of the authors of the study text RefTitle Title of the reference source text RefLanguage Language of the reference source text Table 4b References or sources used In order to link such table with the corresponding earthquake an additional field with the list of used reference codes must be inserted in the catalogue table The steps for adding references are the following e insert all the bibliographical references sources only once in the table e create a unique identifier preferable simple numbers for each bibliographical entry e create a field in the earthquake catalogue and for each earthquake insert the list of reference identifiers used for that earthquake separated by a semicolon If the ear
11. GJ help 1J special cases b Edit source code frameset navigation bar homepage this page vars L3 http localhost MIDOP 090915 settings page edit page php paqg 5 7 SAVE PAGE lt html gt lt head gt neta http equiv Content Type content text html charset iso 8858 gt lt title MIDOF homepagez title lt link rel stylesheet href cssstemplate cas lt link lt head gt body style bacEground color white lt div style width 600px margin l px lt p style font size 1203 border bottom lpx solid black Example homepages p gt lt p gt nbsp p gt lt ul gt lt li gt lt a href query ed gt query by earthquakes rarer li gt lt li style margin top z px 2 a href query place gt query by places ar lt 1li gt lt ul gt lt r div gt lt body gt lt html gt The final HTML must contain a link to one or two relevant query methods e for entering the query by earthquake area use the standard HTML element lt a gt 87 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual lt a href query eq gt query by earthquake lt a gt e for entering the query by place area insert lt a href query place gt query by place lt a gt Further page layout customization can be done in every HTML editor such as the free tool Kompozer http www kompozer net or the commercial product Dreamweaver by Adobe 6 5 Linking
12. It might happens that Access cannot automatically establish which is the table unique record identifier in such cases you must select the identifier field manually select Unique Record Identifier Fields in table olial006 _catalogue1 Ro e Year Ma Da AxShoart StudyShortCitation StudyCode To ensure data integrity and to update records you must choose a Field or fields that uniquel identify each record Select up to ten fields 6 Once the procedure is finished the requested tables will show up in the Access Tables section You can distinguish between local and remote MySql tables intuitively as they use a different icon C RA Li Ca Hame Create External Data Database Tools Acrobat DPF P DR wa XML File x WII Saved Access Excel SharePoint Saved Excel SharePoint Imports List T More gt Exparts List Import Export bySql_olial006_catalogue bysScl_olial006_mdp N Linked tables S IySal olial amp references bySql_ref_places olial006_mclp Local tables olial006 references ref_places 48 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual PhpMyAdmin application The most used web application interacting with MySql tables is the already mentioned phpMyAdmin By using it users will be able to view and modify existing data intuitively change table structures create new tables create in
13. Part 2 Improved macroseismic web mapping tool MIDOP manual events that you want to re generate and then click Generate all the earthquakes selected maps and tables Once the system has finished you can copy the newly generated files on the final web server IMPORTANT NOTE Before generating the updated version of your files remember that MIDOP will overwrite existing file You can create a backup folder for each version of a published site this will help you keeping track of what has been published in the past and any data content or setting change 6 4 Final homepage customization MIDOP let you customize the homepage of each managed website The homepage file is a plain HTML file stored in settings your_website settings folder homepage htm In order to personalize the page you can directly edit the HTML source code using the built in text editor available by clicking the homepage Edit button in the Structure page of the control panel see image below query by earthquake query by place Eas Eman FLUSHI e Editing file vars emd home ige htm Mozilla Firefox d b Website structure 2 absolute site url http emidi Li navigation bar F Li query by earthquake Li query by place b HTML frame structure 4 left frame width 4 upper left frame height G middle left frame height 2 lower left frame height P Site language Ul default language Li general dictionary
14. The resulting sort of the column is the result of the sort of all the specified fields selected from the earthquake catalogue table starting from the top to bottom Click add a sort rule for adding a filed to the list It is possible to specify a sort order for each selected field Options Li export earthquake Iv Let the user download the MDP list as MS Excel file This settings page let you customize the appearance and functionalities of the intensity map You can specify the default view zoom and extension the geographical layers to be included and the available tools for the final user The following settings boxes are available 1 2 3 4 Map options Default view Map layers Reference places on map 64 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual amp Map options fixed iberia TMi 30 ND Li geographical area D same as the earthquake group from EQ catalogue field ki Li zoom tool 4 Li scale factor 30 i pan tool w Li displacement in km at 100 scale 15 Lil scale bar Fi a tool for adding markers vf export to Google Earth v print tool v 2 geographical grid v Li symbols NERIES_NAA code editar i popup windows if user clicks on a place no 4 alert extended Li seismic history link if available 9 Li wikipedia link 2 google maps link Geographical area e fixed e same as the eart
15. b MySql access parameters 2 host name localhost 2 user name root Li password Lil database neries Host name Set the host name or IP address where the MySql server is installed User name Set the user name for opening a MySql connection Password Set the password for opening a MySql connection Database Set the MySql database name where all the needed tables are stored gt MySql selected database tables Li earthquake list catalag emd eq catalogue Li Macroseismic Data Points MDP table emd mdp database i earthquake studies table nad references Li reference places on map ref places Set the table name with the earthquake catalogue list and Earthquake list catalogue Si macroseismic parameters Macroseismic Data Points MDP table Set the table name with the macroseismic intensity database Earthquake studies table Set the table name with the earthquake studies references Set the table name with places to be used as a geographical Reference places on map reference on maps Page Structure This page let you customize the graphical layout of the website that you are going to publish The following settings boxes are available 1 Website structure 2 HTML frame structure 3 Site language 51 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual b Website structure Absolute site URL Navigation bar Query by earthquake Query by place Li absolute site
16. different icon FK Microsoft Access MIDOP Database Access 2000 file format jig File Edit View Insert Tools Window Help Adobe PDF GAIA VIA 5110 1 H 185 1i oo 58 3 1 S Create table by using wizard Suse H Create table by entering data MySql_olial006_ catalogue MyS5ql_olial006_mdp Reports MySql_olial006_references Forms Linked tables xt Pages P Mysql ref places Macros olial006_catalogue olial006_mdp Modules M Local tables alial Q references Groups ref places Favorites 46 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Using Access 2007 1 create or open a database select the top menu External Data and choose ODBC Database Co moe Li a Pz b i Home Create External Data Database Tools Acrobat DIE m 2e XE dh 5 ud XML File s 5 Text File GG Saved Access Excel SharePoint Saved Excel SharePoint Create Mar Imports List IW Exports List d More 7 E mail Rep Import ODBC Database Collect Da Tables ieee or link to an HTML EH alial d amp catalogue Document olial006_melp Outlook Folder EEH ES Import or link to an Qutlaak alial d references i folder ref_places dEASE File Import or link to a dBASE file Paradox File Import or link to a Paradox file Lotus 1 2 3 File Import a Lotus 1 2 3 file 2 select Link to the data source by creating a linked
17. www apachefriends org en xampp windows html 646 WAMP http www wampserver com e execute the installer script NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual only if you re using Windows Vista once the package is installed check the existence of the file msvcr71 dll within the folder c windows system32 if it doesn t exists try to copy it from another MS Windows computer or try to find it using a web search engine only for XAMPP execute setup_xampp exe message will appear EX C Windows system32 cmd exe If the procedure will be successful this HH HH HH HH HH HH HH HH HH HH HH HH EH H i fipacheFriends XAMPP Lite setup vin32 Version 1 7 Authors Kay par pele kvoBapachefriends orq gt Carsten Wiedmann webmaster wiedmann on line de gt H aaa icono Configure for server 1 7 8 Configure SAMPP with auk for Hindows_NT Please walt Enable AcceptEx Winsocks v2 support for NT systems HHHHH Have fun with ApacheFriends AAMPP Lite HHHHH ress any key to continue DONE modify the Apache configuration file httpd conf adding the following lines at the end of the existing lt IfModule mime module gt tag lt IfModule mime module gt AddType image svg txml svg AddType image svg xml svgz AddEncoding x gzip svgz lt FilesMatch svgz gt lt If Module mod gzrip c mod gzip on No lt IfModule gt lt FilesMatch
18. 0000000000000 Server localhost Database midop z Port o Socket Option fo stmt Icd y At 12 click OK from now on you can access the midop database from every software capable ODBC aware such as OpenOffice In order to use OpenOffice as a front end for your MySql database follow these steps e select ODBC as data source Database Wizard Steps Welcome to the OpenOffice org Database Wizard 1 Select database Use the Database Wizard to create a new database open an existing database file or connect to a database stored on a server 2 Set up ODBC connection What do you want to do Create a new database Open an existing database file e Connect to an existing database ODBC Next gt gt Cancel e select which data source must be used Database Wizard G Steps Set up a connection to an ODBC database 1 Select database Enter the name of the ODBC database you want to connect to Click Browse to select an ODBC database that is already registered in 2 Set up ODBC connection OpenOffice org Please contact your system administrator if you are unsure about the following settings Name of the ODBC data source on your system Browse Choose a data source midop on localhost Help lt lt Back e enter the MySql access parameters username and password 43 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual
19. 03 SIENA alo CCOCbSSSERALA i r INGY DBMIOS Place Mozilla Firefox Torx 1449 10 Asciano i _ _ QQ Q_z gt _Q 1456 12 Molise 2 i San Polo Matese San Polomatese 1458 04 Val Tiberina 4 a 1458 05 Citt di Castello Latitude 41 459 1461 11 Aquilano Longitude 14 494 1465 OS GUBBIO 1466 12 L quila an i o Country IT 1466 12 GUBBIO A GO 44 YA v Province CB 1467 09 Siena 1467 08 Siena pie i ait TF 5 Boiano 9 Municipality San Polo Matese La AM A Municipality code 14070071 1456 12 05 03 Molise Study Meletti et al 1988 e gt pa Ded a Seismic history O Epicentre Bx 7 22 0 15 41 302 14 711 4 ALANS eb un ctl Ty Di s IS n of MDP 199 max Int 11 Place Bojano Fragneto 1 ibate 5 Paduli ld a i LA rp pice vecchio Ds f j e Ariano Irpino Ariano Casalciprano d ss A Frosolone j 2 Oo E Isernia r1 Caseig ar p Macchiagodena A epe g Ceryindra cs Pesco Sannita Pescolama B 0 9 ft dm S Polo Matese S Polom a P EP Vinchiaturo Awarca a Campochiaro gerottaminarda Casalduni a Q f gt JA M 33 df P bf vi Limata ya AS gt 0 00000 Mirabella Eclano NF 3 4 F 4 5 56 6 7 7 8 8 9 940 10 11 Query by earthquake Macroseismic Intensity map of a selected earthquake zoomed NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual home
20. 1 11rsssrrrrsiiiie iii iii 93 Dl LICENCeSs ul sretoneare 93 Creative Commons LICENCE sica ail lle 93 GNU General Public License version 3 GPL 3 i 94 92 hid party products USC dr 94 SA RE 95 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Abstract Within the activities of the Networking Activity 4 NA4 module called Distributed Archive of Historical Earthquake Data of the European Commission NERIES project a massive quantity of historical earthquakes related data is being published online The NA4 working team is composed of many researchers coming from five European National Institutions The retrieved data ranges from year 1000 to year 1900 and covers all of Europe One of the fundamental components of historical seismology research is the so called macroseismic intensity data which describes the level of damage caused by an earthquake in a list of places Usually these data come in form of printed maps and or tables only rarely data are available in digital form Among other tasks the NA4 working team is dedicated to publishing maps representing retrieved material Until now no dedicated software for online map publishing existed and general purpose solutions were adopted However a macroseismic map requires a series of additional information such as explanation on the sources used detailed places information and representation of the level of dam
21. 5 5 Advanced customisations 2 2 3 3 3 4 F 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 10 10 10 11 11 e 00080828 00000000090 RGB values RGB values Fill Stroke Green Blue Green MIDOP is by nature extensively customizable Whenever you find a button Edit by clicking it you will be able to directly modify the source code using a built in source code editor Off course such modifications requires at least a basic PHP and HTML coding knowledge but also novice users might understand it by reading existing code A big effort while developing MIDOP is 76 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual being putted on the coding style adopted extensive use of comments PHP variable with self explaining names and simple text files for storing each managed website settings Symbols customization Available symbols used for plotting macroseismic intensities can be customized and new symbols can also be created by clicking the button Edit within the page MDP map a popup window will open presenting a source code editor b Map options C fixed iberia UTM 30 N i gengraphical area same as the earthquake group C fram EQ catalogue field i places info popup e Yes C no Li zoom tool M Li scale factor 30 i pan tool M 4 displacement in km at 100 scale 15 a scale bar Iv uu tool for adding markers Iv export to Google Earth M print tool Iv Li grid Iv
22. E Laa 3 lt path d N4189125 24073440129 S6le2632 9561 87 1261 96 1411 511 7531 ans R 1n lt path d M4581815 248791324115 10150 191649 24013547 77 jon vis O ES 11 path d N4581815 28791321 508 om aprum CT 16671278 2071 La path d M391900 D pem ini cii6d4 3661354 321655 5961254 57143 13 ooo smi aatal GG 235917595 941410 2221612 361960 3231765 28716055 3 A pa d M4596295 2244090811361 759157 372121 811812 921512 1431503 3161406 38 Z55 path d M47129019 235912501 126 19901413 5211742 7331429 1621194 2751305 231110 Z56 lt path d M4719532 23031761 250 440712201 199611267 14501435 691190 9161 142 5t 25 path d M4 724252 43705451516 52411017 69114858 8871537 1431352 235413562 3741120 Ln 258 Col 1 Insert Sel Normal DOS File size 358683 13 chars 1 lines Once you have your file with the layer extension you can upload it into MIDOP by clicking the button upload a new layer in the control panel J available layers for ibeie UTM30N e ec clwayspresent e EE 3505060600 upload anew layer T Eres elevation xxx ril a i EN Digital elevation model LDEM e pe arCngua Qke area Please note that MIDOP will load the layer file as is and no geographical projection or other transformation will be performed For simple changes to the layers source code a text editor can fulfill the task If complicated SVG manipulation is required you can use the fr
23. Steps Set up the user authentication 1 Select database Some databases require you to enter a user name 2 Set up ODBC connection 4 Set up user authentication User name 5 Save and proceed root Y Password required Test Connection Help lt lt Back Next gt gt Finish Cancel The procedure for copying a table from OpenOffice Base local tables to MySql is the same as the Mac OSX procedure described above 4 5 MySql data manipulation At the end of the macroseismic data production workflow every table must be transferred to MySql in order to let MIDOP load data Once tables are transferred to the MySql server every modification must be obviously made on MySql tables Luckily enough direct modification of MySql table content is quite easy both using online web applications and offline packages These solutions adopt the so called client server approach a graphical interface usually referred as a client or front end separated from the engine that manipulate physically the data called server or back end by having two separate applications for each function the database engine is not tied to a specific interface and anything can ask for data Queries to a database engine follow the SQL query language specifications Structured Query Language http en wikipedia org wiki SQL MIDOP can be considered as a front end or a client that ask for data to a database engine server and then a
24. The macroseismic intensity scale used for assessing the degree of damage such as MCS Mercalli Cancani Sieberg MM Modified IntensityScale text Mercalli EMS98 European Macroseismic Scale 1998 MSK Medvedev Sponheuer Karnik Intensity expressed using the specified macroseismic scale on the Intensity mentioned place Special intensity values as specified within the text NERIES NAA Deliverable 7 part 1 are accepted see tab 2a below Numerical value corresponding to the expressed intensity IntensityNum field used for sorting tables and layering by intensity the plotted MDP decimal on the earthquake map Reliability Reliability as available from the convention in use locally text GazetteerName Source gazetteer used for obtaining the place coordinates text Ss er text or GazetteerlD Place unique identifier within the source gazetteer sum bei Present country code of the locality as described in the ISO 3166 1 country see the reference table below en Region First order country administrative division text Province Second order country administrative division text MunicipalityName Third order country administrative division text MunicipalityCode Third order country administrative division coded Its coding rules is T different in each country Table 2 Macroseismic intensity data Further information on geographical Gazetteers can be found in Hill L 2006 For your convenience below is reported the simplified
25. Visual FoxPro Driver 1 00 02 00 Microsoft Microsoft Visual FoxPro Treiber 1 00 02 00 Microsoft 5 01 05 00 MySQL Al SQL Server 6 00 6001 18000 Microsoft _ E d 4 F The driver is now installed and ODBC aware applications such Microsoft Access can now connect to MySql The first time an ODBC connection is requested a configuration procedure must be stored as a new source of ODBC data in order to be used also in future 1 Turn on the both Apache and the MySql server using XAMPP control panel if needed 2 Create a connection referring to the above created database midop open the ODBC Data Source Administrator within the Control Panel gt Administrative Tools this path might change depending on your localized copy of Windows a e y A x ODBC Data Source Administrator b Create New Data Source Da User DSN System DSN File DSN Drivers Tracing Connection Pooling About M dane mEE AA T User Data Sources User Data Source Applies to this machine only Name Driver Add O gt n Selecting User Data Source creates a data source which is specific to this machine and visible only to you 4 m p the indicated data provider 4 User data source is only visible to you E An ODBC User data source stores information about how to connect to and can only be used on the curre
26. Your fair dealing or fair use rights e The author s moral rights e Rights other persons may have either in the work itself or in how the work is used such as publicity or privacy rights Notice For any reuse or distribution you must make clear to others the license terms of this work The best way to do this is with a link to this web page This is a human readable summary of the http creativecommons org licenses by nc sa 3 0 93 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual GNU General Public License version 3 GPL 3 MIDOP is free software you can redistribute it and or modify it under the terms of the GNU General Public License as published by the Free Software Foundation either version 3 of the License or at your option any later version MIDOP is distributed in the hope that it will be useful but WITHOUT ANY WARRANTY without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE See the GNU General Public License at http www gnu org licenses gpl html 9 2 Third party products used MIDOP is using modified version of the following third party products e for geographical layers o GADM database of Global Administrative Areas Files used for generating European countries administrative boundaries Italy excluded http www gadm org o ISTAT 2005 Confini amministrativi e dei sistemi locali del lavoro Files used for generating Italian administ
27. a suggestion being MIDOP capable of using any field name used in the table header The real naming constraint is that spaces special characters and duplicated names must be avoided The symbol specified in the following tables means that the field is required other mentioned fields are not necessary but they will be used if filled Earthquake catalogue table The earthquake catalogue table contains the complete list of earthquakes that you are going to publish within MIDOP It contains all the information about the whole earthquake such as the origin time the epicentral area and the source of information from which data are taken Description Earthquake unique identifier EQid Trailing spaces and special characters must be avoided a simple integer text or number is advisable number field used retrieving all the corresponding macroseismic intensity points Year Time of the event year Note that negative values are accepted integer Mo Time of the event month integer Da Time of the event day integer Ho Time of the event hours integer Mi Time of the event minutes integer Se Time of the event seconds integer Ax Denomination of the area where the largest effects are located text 20 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Denomination of the area where the largest effects are located shortened ann field useful for html tables that have a character space
28. an Archive of Historical Earthquake Data AHEAD with special reference to the supporting data to be used to compile a homogeneous European Parametric Earthquake Catalogue This task is being accomplished by searching retrieving evaluating and making available the macroseismic datasets on European and Mediterranean earthquakes occurred in the time span 1000 1900 The most important supporting material is the historical earthquake study used by researchers to publish a comprehensive report with all the information regarding a specific earthquake Among the retrieved information a study presents the macroseismic intensity data which describe the effect expressed using a Macroseismic Scale e g the EMS 98 Gr nthal et al 1998 caused by an earthquake in a set of places Usually these data come in form of tables or as maps printed on paper only rarely data are available in digital form Among other tasks the NA4 working team is dedicated to make available online these intensity data by publishing interactive maps Until now no dedicated software for online map publishing existed and general purpose solutions had been adopted However a macroseismic map requires a series of additional information such as the sources used detailed places information and representation of the level of intensity using special symbols These requirements are of difficult implementation using out of the box tools because they result in extremely time consuming and
29. constraint IM Short bibliographical citation mentioning the main author and the date of study StudyShort publication text e g Stucchi M 2009 Stucchi amp Locati 2009 Stucchi et al 2009 An extremely simplified code representing the study StudyCode Trailing spaces and special characters must be avoided text or field used to link to the corresponding record in the bibliographical table and number used for naming study related PDFs and images see chapter 4 3 Table 1a Earthquake catalogue data The earthquake catalogue table may contain information about the epicentre if you want to plot such epicentre within MIDOP you must add an additional set of fields to the catalogue table in order to describe the epicentre parameters Below the list of available epicentre descriptors tab 1b EpLabel EpLocationSource EpLat EpLon Epintensity EpintensityNum EpMagnitudeSource EpMagnitude EpMagnitudeNum EpMagnitudeError EpMagnitudeType MIDOP allows more than one epicentre each one represented with a different symbol Description Epicentre label will appear within the earthquake information frame Epicentre location source Epicentre latitude geographic coordinates in decimal degree Epicentre longitude geographic coordinates in decimal degree Epicentral intensity expressed using a macroseismic intensity scale such as MCS Mercalli Cancani Sieberg MM Modified Mercalli EMS98 European Ma
30. errors On short open tag On auto detect line endings On magic quotes gpc On MOSLEING lt 1nvernal encoding UIF 8 e enable the following PHP extension in php ini extension php curl so extension php dbase so extension php gd2 so0 extension php mbostring so extension php mcrypt so extension php mime magric so extension php mysql so extensi n php mysqlir so extension php pdo mysdal so 14 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual extension php pdo odbc so extension php soap so extensi n php x5p so 4 Edit the content of the file Applications MAMP conf apache http conf as follow section in the red box 3 If the AddEncoding directives above are commented out then vou probably should define those extensions to indicate media types Add Type application x cCompress 2 AddType application x gzip gz tgz AddTvpe imagez svgexml q AddTvpe imagez svgexml swgz AddEncoding x gzip svgz FilesMatch svazi gt e lt IfModule mod gzip c mod gzip on No lt If Modu lez z FilesMatch addType applicationevnd DI eorth kml x lt ml kml Emz i AddHandler allows you to map certain file extensions to handlers actions unrelated to filetvpe These can be either built into the server or added with the Action directive see below 5 For MAMP both Apache the web server and MySql the database managem
31. from external website to a MIDOP generated site Site published with MIDOP can be directly linked from external web pages with ease Below a list of the available linkable objects e the published site homepage http YOUR WEBSITE URL e the query by earthquake homepage http YOUR WEBSITE URL query eq e a specific earthquake within http YOUR WEBSITE URL query eg external call htm eq id earthquake identifier e aspecific earthquake group within the query by earthquake page http YOUR WEBSITE URL query eg eq group the name of the group e the query by place homepage http YOUR WEBSITE URL query place 6 6 XML export A published website is equipped with a XML file used for storing published data and related information Its format is highly inspired by the QuakeML format Schorlemmer et al 2004 https quake ethz ch quakeml QuakeML The file is stored in the data quakeml folder of the published site in the PUBLISHED SITES folder The purpose of this XML file is to keep in a comprehensive and standardized file the original data a file that can be used for future use or for potential data analysis for researchers 88 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual index php css Helosedhand png jquery js jquery tablesorter js L openhand png gres style css template css video css data I dem
32. group the data according to one attribute type y or n J Would you like to include event handlers to the individual elements Type y n n Geometry type MULTIPOLYGON Converted 249 MULTIPOLYSON objects Done xmin 3800000 max 4900000 ymin 2200000 ymas 2900000 writing SWG file removing temporary sqlfile done done C Program FilesWVshp2swvg At the end of the conversion process the output generated SVG file can be found in the same folder In order to use such file in MIDOP as a geographical layer you must open the SVG file in a text editor and delete all the lines that don t contain SVG elements and save the file with the layer extension Below an example screenshot with the converted administrative alps svg file loaded into a text editor enlighten in blue lines that must be deleted 81 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual E ConTEXT CA Program Files shp2svg administrative_alps svq File Edit View Format Project Tools Options Window Help DPMAC SA HOM ea SAHF AA G Tod files lu administrative alps gvg l ml wersion 1 0 P UM ae id mec DOCTYPE ayo PUBLIC W3C DTD SVG 1 1 EH http www wu3 org Graphics SVG 1 1 DTD swi cH ATTLIST awg 4 xmlns attrib CDATA IMPLIED 5 6 z 7 Ge width i00 amp SSR viewBox 3772500 2917500 1155000 735000 E http w 8 sie absens ca let Eume sc tiame Scala a telar acicate Se
33. i symbols MERIES_MNAA edit iu Macroseismic Database Administration Edit Page Mozilla Firefox A http lapmario MIDOP 0931023 settings page svg edit page php pagezsymbols symbol mdp syubol mdp NERIES N 4 ll syubol lt circle p pr fill 8EFF22 stroke FDF323 stroke width symbol mdp NERIES N 4 ll onoff 1 Ssvnbol mdp NERIES NA4 12 new stdClass symbol mdp MERIES N44 12 gt i5 5 Ssvnbol mdp NERIES NA4A 12 gt svmbol lt circle TE Bg fill GEFFZZ stroke 63C600 stroke width ssymbol mdp MERIES M44 12 gt onoff 1 Ssvnbol mdp NERIES NAA4 135 new stdClass ssymhol mdp NERIES NA4 135 gt is 4 5 ssymbol mdp NERIES N44 13 gt symbol lt circle i p fill l AD4d5 stroke SEFF22 stroke width s symbol mdp NERIES N44 13 gt onoff 1 symbol mdp NERIES NA4 14 new stdClass symbol mdp MERIES N44 14 gt is 4d Ssvubol ndp NERIES N44 14 svmbol lt circle p p fill 144D45 stroke 137D335 stroke width Ssvnbol mdp MERIES Mi44 14 gt onoff 1 The code uses PHP macro language for defining SVG Scalable Vector Graphic shapes WARNING Be careful while inserting or modifying source code errors might produce unpredictable effects and might completely harm MIDOP Intensity symbols are organized in sets each with as many symbols as the possible range of macroseismic intensities E
34. list table with the reference table In order to retrieve only those references sources used with specific macroseismic study set the combination of both the unique identifier of the macroseismic study together with the reference source unique identifier for linking to the earthquake list table Set the complete bibliographical citation of the reference source Set the year of publication of the reference source Set the authors of the reference source Set the language used in the reference source 55 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Label Source Method Latitude Longitude Intensity Intensity numerical value Magnitude Magnitude numerical value Magnitude error Type of magnitude Magnitude source Symbols Box Box colour b Earthquake epicentres Epicentre 1 iJ label Instr NJ source Inst Source Li method hd Li latitude Inst_lat 4 longitude Inst lan i intensity v i intensity numerical value Li magnitude Inst hd i magnitude numerical value Inst hk G magnitude error Inst DIM i type of magnitude Li magnitude source 4 symbols x StarBlack dd edit i box hd G box colour FFFFFF Pa i preferred epicenter source add an epicentre Set the epicentre label that will appear in the detailed information frame in the middle left frame Set the epicentre source who did provide the information You
35. log contains the complete list of places for which a seismic history has been generated 6 3 Update subsets of an already published site In research activities it often happens that a sub set of the original data must be updated or corrected in some parts When you have finished updating such data in MySql tables you can proceed updating the already published website by publishing again only those parts that you have modified and only those generated files will have to be copied on the web server To do so click on the publish page and follow your specific update case below Frameset structure update It might happen that only the general layout must be updated for example the left frame needs to be a bit larger or the selected information frame a bit higher To create the needed updated files click only the button Generate the html structure and copy the resulting files in your publication folder to the already published website Earthquakes list table and general earthquakes map update If you only have to update something within the earthquake list table content in the upper left frame for example new columns or modified earthquake parameters you have to click only on the button Generate EQ list catalogue and epicentres map Selected earthquake map and macroseismic observations table update Within the publication page you can choose a subset of the entire earthquake catalogue just select those 86 NA4 D7
36. one city information related to quarter part of a city Table 2c Places special case codes ISO 3166 1 country codes reference table extracted from NA4 Deliverable 7 part 1 tab 2d Code Geographical area Code Geographical area AL Albania MD Moldova DZ Algeria MC Monaco AD Andorra ME Montenegro 24 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Morocco Netherlands Norway Poland Portugal Romania Russian Federation Serbia Slovakia Slovenia Spain Sweden Switzerland Tunisia Turkey Ukraine United Kingdom LV Latvia Additional codes AT Austria MA BY Belarus NL BE Belgium NO BA Bosnia and Herzegovina PL BG Bulgaria PT HR Croatia RO CY Cyprus RU CZ Czech Republic RS DK Denmark SK EG Egypt SI EE Estonia ES FI Finland SE FR France CH DE Germany TN GR Greece TR HU Hungary UA IS Iceland UK IE Ireland IT Italy LY Libyan Arab Jamahiriya GG LI Liechtenstein Gl LT Lithuania IM LU Luxembourg JE MK Macedonia SU MT Malta YU Guernsey Gibraltar Isle of Man Jersey Soviet Union being phased out Yugoslavia being phased out Table 2d ISO 3166 1 country codes Map reference places MIDOP can show place names on maps to be used as a geographical reference Built in support is available for the whole Europe Atlantic Islands UK Iberia France Italy Eastern Europe Fennoscandia Aegean In order to let MIDOP understand when it has to plot a place y
37. php e write lt php phpinfo within the text file and save e open an internet browser and enter the address http localhost info php below an example of a correctly working installation 17 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual i phpinfo Mozilla Firefox OQA 69 File Edit View History Bookmarks Tools Help gt Q Q qi e http localhostyinfo php v Ne x e phpinfo A v PHP Version 5 2 10 2ubuntu6 4 Linux vboxlocati 2 6 31 17 generic 54 Ubuntu SMP Thu Dec 10 16 20 31 UTC 2009 i686 Jan 6 2010 22 15 47 Virtual Directory Support disabled Configuration File etc php5 apache2 php ini Path Loaded Configuration File etc php5 apache2 php ini additional ini files Zend Extension Server API Apache 2 0 Handler i z n i PHP Extension Zend Extension DebugBuld m Done Your Linux system is now ready for the MIDOP installation 3 2 Browser compatibility MIDOP uses the SVG Scalable Vector Graphic language for describing graphical elements such as maps or diagrams Such format is a World Wide Web Consortium W3C standard established since 1999 used for describing vector graphic objects on the Web lts diffusion is slowly growing but still has some issue on browsers that don t fully support nowadays W3C standards Below a browser compatibility matrix resuming our tests Operating systems Browser rendering eng
38. represented intensity 4 5 Ssymbol mdp NERIES NA4 9 new stdClass symbol mdp NERIES NA4 9 18 4 5 Ss ymbol mdpel NERIES NA4 9 gt symbol lt dircl ox 0 Ey 0 rs 1900 fi L i EDE323 stroke FES96G3E streoke wtatk 600 gt Ssymbol mdp NERIES NA4 9 gt onoff 1 A problem occurs if the original macroseismic intensity data adopts intensity diction that doesn t match the defined intensity symbol set If MIDOP found the intensity IV V and a symbol linked to this intensity doesn t exists the intensity point will simply not be rendered on the map In order to solve this problem you can automatically convert your custom intensity values instead of changing the whole intensity symbols set or altering the data contained in the intensity tables This conversion is based on the file settings symbols symbol_conversion php If for example you would like to convert the roman value V VI into 5 6 two lines of code must be inserted Ssymbol convert cases IV V symbol convert value 4 5 You can specify multiple conversion at once so if you would like to convert both the original values V VI and 5 5 into 5 6 write something like SS yYMDOL Convert Cases se m5 EVE Ssymbol convert value 4 5 Epicentre symbols are defined by four PHP lines 1 second level array object class creation named as the name of the symbol The so created 78 NA4 D7
39. table Get External Data ODEC Database Specify how and where you want to store the data in the current database Import the source data into a new table in the current database IF the specified object does not exist Access will create it IF the specified object already exists Access will append a number to the name of the imported object Changes made to source objects including data in tables will not be reflected in the current database ccess will create a table that will maintain a link to the source data Changes made to the data in Access will be reflected in the rce and vice versa 3 Select the stored ODBC connection that links to the database containing the wanted table Select Data Source File Data Source Machine Data Source Description MAPSERVER NERIES User MAPSERVEH studies User User User User User SAR NERIES User studies User 4 A Machine Data Source i specific to this machine and cannot be shared User data sources are specific to a user on this machine System data sources can be used by all users on this machine or by a system wide service Cancel Help 47 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 4 Select the table or tables by multi select using the shift key that you want to link Link Tables Tables storage _ storagevars_olial006 Cancel Pup qud Select All Le Deselect All E save password 5
40. the place name that will be plotted as a geographical reference on the map Set the truncated place name that will be plotted as a geographical reference on the map with a distant zoom Set the reference place latitude The value must be expressed in geographical decimal degree Set the reference place longitude The value must be expressed in geographical decimal degree Set the zoom value to be used for the place name Allowed values are detail for close up zoom medium for medium distant view large for distant zoom Set in which geographical area the place will be shown MIDOP has 6 built in areas atlantic islands iberia france uk Italy eastern europe fennoscandia aegean This settings page controls the query by place part of your website This functionality is available only if mentioned places are identified by uniquely identifier as specified in tab 2 and if the country field has been compiled The following settings boxes are available 1 Query by place settings 2 Seismic history diagram 3 Place position map 69 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Li b query by place settings countries to be considered AD Andorra v AL Albania v AT Austria i BE Belgium W BG Bulgaria CH Switzerland CY Cyprus CZ Czech Republic DE Germany EG Egypt ES Spain iv I LU Luxembour
41. tool MIDOP manual When asked answer n to every question Below an example output of the conversion of the shapefile called administrative alps shp EX Administrator CAWindows system32 cmd exe C Program Files shp25vg 0g1525vg exe i1nput administrative alps shp output administrative alps svg roundval 1 working on layer administrative alps converting shapefile to a temporary sqlfile done tablename administrative alps The following attributes are available Please select the attributes you want to include in the SVG export Attribute gid Type ser1al Do you want to include it y n n Attribute f code Type varchar Do you want to include it y n n Attribute f cade des Type varchar Do you want to include it y n n Attribute nam Trpe warchar Do you want to include it y n n Attribute na2 Trpe warchar Do you want to include it y n n Attribute na2_descri Type varchar Do you want to include it y n n Attribute na3 Type varchar Do you want to include it y n n Attribute na3_descri Type varchar Do you want to include it y n n Attribute tile id Type 1nt4 Do you want to include it vy n n Attribute sfac id Trpe 1nt8 Do you want to include it vy n n You selected the following Attributes Which one would you like to select as a unique swg id Type in attribute Name or none if you don t want to include a unique id none you selected none as a unique attribute Do you want to
42. used for retrieving the corresponding earthquake in the catalogue number Macroseismic Data Point MDP unique identifier Trailing spaces and MDPid special characters must be avoided a simple integer number is or number advisable Place unique identifier It must be the same in every earthquake where the place is mentioned Trailing spaces and special characters must be avoided a simple integer number is advisable etoi PlacelD It may differ from the original gazetteer identifier used for retrieving the Uber place coordinates field used in order to generate place seismic histories if not specified the query by place will not be available PlaceName Place name text Place name shortened coa non field useful for html tables that have a character space constrain did PlaceSC Place special case T See the two characters code reference tab 2c below Placel at Place latitude in geographical coordinates in decimal degree Tecna field used for plotting the place PlaceLon Place longitude in geographical coordinates in decimal degree dedma field used for plotting the place Place latitude in geographical coordinates in decimal degree for large PlaceLatTE territories Such places will not be represented on map but their decimal coordinates if present will be taken into account for centering the map Place longitude in geographical coordinates in decimal degree for large PlaceLonTE RE decimal territories See above
43. 34 zone folder for 3D hill shaded DEMs folder for 3D hill shaded DEMs in UTM 30 zone folder for 3D hill shaded DEMs in UTM 30 zone folder for 3D hill shaded DEMs in UTM 31 zone folder for 3D hill shaded DEMs in UTM 32 zone folder for 3D hill shaded DEMs in UTM 33 zone folder for 3D hill shaded DEMs in UTM 34 zone folder for the geographical grid layer grid used when creating maps in UTM 28 zone grid used when creating maps in UTM 30 zone grid used when creating maps in UTM 30 in Iberia grid used when creating maps in UTM 30 in UK grid used when creating maps in UTM 31 zone grid used when creating maps in UTM 32 zone grid used when creating maps in UTM 33 zone grid used when creating maps in UTM 34 zone folder for temporary cache of kml files geographical layers used for generating the earthquakes map layers used for UTM 28 zone layers used for UTM 28 zone in Atlantic Islands layers used for UTM 30 zone layers used for UTM 30 zone in Iberia layers used for UTM 30 zone in UK layers used for UTM 31 zone layers used for UTM 31 zone in France layers used for UTM 32 zone layers used for UTM 32 zone in Italy layers used for UTM 32 zone for the whole Europe layers used for UTM 33 zone layers used for UTM 33 zone for Fennoscandia layers used for UTM 33 zone for eastern Europe layers used for UTM 34 zone layers used for UTM 34 zone for Aegean geographical layers used for generating single earthquake MDP map layers used
44. 43 create a new site By clicking the button create a new site you will be able to add a new website and some information must be entered such as e the site title that will appear in the window title e the site settings folder that will contain all the customized files describing the website it must be named without spaces nor special characters possibly starting with the prefix vars e asite description comment that helps administrators remembering important information related to the website 73 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual The creation date and further changes dates will be kept automatically by MIDOP Select the newly created site by clicking on the corresponding column selected and click save settings in order to activate your changes Click now the top button show the selected site settings and the control panel will switch to the selected website settings If you would like to remove a website click the button remove a popup message will appear asking you to confirm the delete operation As additional safety measure you must also click the button save settings in order to completely delete the website Every time a new site is created a series of default values will be applied helping administrators speeding up the customization process All the presets values are stored within the folder settings defaultvars by changing th
45. BL 4 S Valentino in Abruzzo Cit IT PE 9 San Valentino Torio IT SA 4 San Venanzo IT TR 8 Campobasso San Vendemiano IT TV 4 San Vincenzo la Costa IT CS 4 San Vincenzo Valle Roveto IT AQ 6 San Vitaliano IT NA 3 San Vito al Tagliamento IT PN 16 San Vito Chietino IT CH 3 Pot San Vito dei Normanni IT BR 3 e Olenza San Vito di Cadore IT BL 9 San Vito di Fagagna IT UD 7 San Vito di Leguzzano IT VI 3 San Vito Romano IT RM 9 San Vito sullo Ionio IT CZ 8 San Vittore del Lazio IT FR 6 San Zeno IT VR 4 San Zeno Naviglio IT BS 6 Closest places whithing 10km San Zenone degli Ezzelini IT TV 5 Places Country HMO Distance Sanarica IT LE 4 Sanfr IT CN 4 Baranello TR 9km Sanfront IT CN 3 Bojano IT 3km Sangano IT TO 3 Sangineto IT CS 7 Campochiaro TET 1km Sanguinetto IT VR 15 Sannicandro di Bari IT BA 4 sica zi a Sannicandro Garganico IT FG 23 Colle d inchise IT 6 kn Sannicola IT LE 3 Sansepolcro LT AR 52 Guardiaregia IT 5km pant Agapito IT IS 4 San Massimo TT Skm Sant agata IT FI 3 Sant Agata IT RC 4 Spinete IT Sian Sant igata Bolognese IT BO 4 Vinchiaturo IT Okm 2ant Acata de n EN 6 Query by place Example output for San Polo Matese in central Italy 10 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 3 Setting up the MIDOP environment In order to use the MIDOP publishing system a development computer is needed which will be used for tuning all the available settings and for generating an outpu
46. Description VARCHAR Length A fixed length field from 0 to 255 characters long TINYTEXT A string with a maximum length of 255 characters TEXT A string with a maximum length of 65 535 characters MEDIUMTEXT A string with a maximum length of 16 777 215 characters LONGTEXT A string with a maximum length of 4 294 967 295 characters TINYINT Length Range of 128 to 127 or 0 to 255 unsigned SMALLINT Length Range of 32 768 to 32 767 or O to 65535 unsigned MEDIUMINT Length Range of 8 388 608 to 8 388 607 or 0 to 16 777 215 unsigned INT Length Range of 2 147 483 648 to 2 147 483 647 or 0 to 4 294 967 295 unsigned Range of 9 223 372 036 854 775 808 to 9 223 372 036 854 775 807 or O to 18 446 744 073 709 551 615 unsigned FLOAT A small number with a floating decimal point DOUBLE Length Dec A large number with a floating decimal point DECIMAL Length Dec A double stored as a string allowing for a fixed decimal point BIGINT Length DATE In the format of YYYY MM DD DATETIME In the format of YYYY MM DD HH MM SS TIMESTAMP In the format of YYYYMMDDHHMMSS range ends in the year 2037 TIME In the format of HH MM SS Table 5 Main MySql field data types Main database creation 1 Open the XAMPP online administration panel and click the Admin button corresponding to the Apache web server Apache must be turned on gt XAMPP Control Panel Application o fe 3 XAMPP Control Panel Modules L svc Apa
47. Group Access Database Delete gt Text File Groups cut gt XML File amp Favorites 3 Copy DA Add to Group a gt HTML Document 2 only for Access 2003 scroll down the types on the export table dialogue and choose ODBC Database 34 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Troll Save in EE Desktop I amp ala X C EH Toss J Mame Siz Type Date modif Date created El ingv i NAA Codici pes de Public n NA4 Terremoti Storici E Computer n probe meepbatch Ww B Metwork ha Programs a 1117 UK Desktop Ub 1222 I Documents e 12950903_Ch Il test mdb re My Documents Copia NA4_Codici 2 m I dum A M My Computer de sia A File name Save formatted Export My Network Autostart Places Save as type Microsoft Office Access mdb adp Microsoft Active Server Pages asp a Microsoft IIS 1 2 Abs idc Rich Text Format rtf Microsoft Word Merge Ext xml ODBC Databases 3 Enter the name of the table that will be created in MySql Note that you can also specify different a table name than what is used in for the Access table you might have stored in your database various versions of the same table Export EGIT Export my table to User Data Sources Driver Add LG BD SNR Er e a MySQL ODBC 5 1 Driver Remove Remowe An ODEC User data source stores information about how
48. Improved macroseismic web mapping tool MIDOP manual P Earthquake parameters i magnitude ban Li magnitude type G label NAd study O automatic max intensity median L Symbols position from eq catalogue fields Lil latitude Lat Lil longitude Lon i epicentral area AE i amas NERIES NA4 edit Magnitude Define the earthquake magnitude value that will appear on top of the epicentres map Define the magnitude type e g local magnitude moment magnitude surface wave Magnitude type magnitude label Define the epicentre label that will appear on top of the epicentres map usually this field is used for the study citation Set where MIDOP will plot symbols representing earthquakes e automatically MIDOP will calculate the couple of coordinates representing the median point of the observations with maximum intensity contained in each earthquake e taking for each earthquake coordinates from two field in the earthquake catalogue table Epicentral area Set the epicentral area text that will appear on top of the epicentres map Set which symbol set will be used for representing earthquakes on the map By pressing edit you will be able to customize the source code of the set of symbols Symbols position Symbols Page MDP list In this page you can define all the information contained in your Macroseismic Intensity Data table as defined in tab 2 Each field existing in your table must be m
49. Z v add a sort rule mM central eel a T i i earthquake web amp x w Az add a sort rule n icentral area epicentral area shortened eft e E k i l earthquake web_Oate A tZ remove number of point v ZA add a sort rule 3rd MOPS number of point 5 rigth earthquake web_Date A gt Z remove AT ena Em max intensity fA add a sort rule x max intensi eft A None at i earhquake web Date Ao remove Sth let ASZ y 6th left e e amp xf add a sort rule 7th left e Ac add a sort rule Bth lett e e AR add a sort rule gth left 5 e T S Y add a sort rule 10th left e e lt A add a sort rule Column title Define the text to be used as a column header Column content Define the column content source field Define the maximum number of characters of the column content If a text has a Chars i number of characters longer than this value the resulting text will be truncated Align Define the column alignment Link Define which column has to be used as a link for selecting an earthquake Define which column is the table default sort Only one column can be set as the Default sort cui Define the rules for sorting the column content The resulting sort of the column is the result of the sort of all the specified fields selected from the earthquake catalogue table starting from the top to bottom Click add a sort rule for
50. ach intensity symbol within a set is defined using again four lines 17 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 1 third level array object class creation named using a progressive integer as the unique identifier within the set The array intensity so defined it s contained in an array called as the name of the set in its turn contained in another array called symbol mdp e g symbol mdp name of the set intensity value Note that the set name must not contains spaces nor special characters 2 definition of the macroseismic intensity value for which the symbol will be used Note that the specified intensity notation must be identical to the intensity notation used for the compilation of the input data If for example the symbol says that it must be used for values 6 7 but the input data is compiled with a VI VII or 6 5 the symbol will not be used 3 SVG shape definition code Note that symbols must be inscribed in an rectangle of 3000 by 3000 in order to be homogenous 4 define if the symbol will be used when creating the final map SVG code This is useful in order to turn on 1 or off 0 plotted symbols without the need of deleting the symbol code The built in symbol sets used for representing MDP on a map are contained in the php file settings symbols symbol mdp php Below the source code used for defining the 9 symbol of the NERIES_NA4 set defining the
51. ada 29 Data Upload Via CSV TEX Menard 32 Data upload via ODB mornin a 32 4 5 MySql data manipulation iii 44 PODIWVAGIMIN apical LEE 49 5 MIDOP SCS e 50 ol MIDOPTIEStIN Sala neh allea 50 MP AA dla 50 Page bB aC66SS Lernia aaa 51 Pade stufe aaa 51 Page EG Israele uil e dada 53 FPagsesEOMapa T 58 Page MDP S nto 62 page MERMA Dorset creation RA O 64 Page Query DY DIa6e si 69 Rage dU eio 71 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 5 39 MUItIple S tes management aa 73 5 4 Epicentre and Intensity SYMDOIS siii li ceed aceon honed Jats cee iat 14 EDICENITESe Lalla 14 DBMIOA IMeENSINGS Selassie ia 14 DBMIOS intensties seta laol uil iL 75 NEIRIES NA4 intensities set a2 a ass 76 9 9 Advanced cuUstomisatON Seti 76 S mboils GUSIOoMIZatoni ale ie lilla TT CUSTOMS asl 79 Loading custom objects on selected earthquakes 83 6 PUDIISNINO a SH siciliana 84 0 1 Final pUplicatlon INtFoOQUGlions gt il lee 84 0 2 PUDIISHING a NEW SM a 85 6 3 Update subsets of an already published SIte i 86 6 4 Final homepage customization i 87 6 5 Linking from external website to a MIDOP generated site 88 OO dU E DO oasis 88 7 MIDOP internal file structure rei 89 0 ROTerences nani il 92 9 Licence used products and credits
52. adding a filed to the list It is possible to specify a sort order for each selected field Sorting rules The following settings box called Earthquake groups let you create logical groups of earthquakes With the terms earthquake group MIDOP means different sub set of the earthquake catalogue and it will result in automatic splitting of the original single catalogue in multiple parts It is possible to have one earthquake group resulting in one earthquake catalogue only featuring all the earthquakes present in your original earthquake catalogue table It is also possible to split the catalogue in multiple time spanned sub catalogues only by specifying the time span of each group MIDOP will automatically generate as many sub catalogues as requested 57 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual If you need a custom group of earthquakes you can add a field in your catalogue table and set its content for each earthquake part of that group For custom groups MIDOP let you specify two fields one used for sorting the group and the other for specifying the earthquake group label e g you can create 5 groups in the first field you set a number from 1 to 5 and in the second field the label for each group MIDOP will order the list of earthquake group using the first field b Earthquake groups OL all the earthquakes in one group Li group label query by earthquake i multiple earthquake groups 5
53. age using special glyph These requirements are of difficult implementation using out of the box tools resulting in extremely time consuming hard to do customization and manual operations tasks that NERIES NA4 couldn t afford To solve the situation the working team decided to create MIDOP a specific tool that allows web inexperienced researchers to easily transform unappealing tables into deeply customized interactive maps A completely coding free approach has been adopted sporting a user friendly web interface capable of generating entire websites from scratch Once a website has been created its publication on the web is easy as dragging a folder to the final web server Thanks to its SVG and JavaScript integration the web server will only manage static pre generated pages resulting in a secure and lightweight web application from the server point of view Only the client computer resources will be used when users require actions such zoom pans or mapped places search The MIDOP tool is based on open source solutions such as JavaScript PHP and MySql and extensively uses SVG for visual representation and interaction The tool is being released under an open source license NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 1 Introduction The main goal of the NA4 module Distributed Archive or Historical Earthquake Data of the EU NERIES http emidius mi ingv it neries NA4 project is to establish and implement
54. ain to create a new ODBC driver O gt Select a Driver gt a G Select the DRIVER to use or Add a new one Name Description Driver Lib Setup Lib Configure These drivers facilitate communication between the Ae Driver Manager and the data server Many ODBC Ok y drivers can be downloaded from the Internet while others are obtained from your database vendor c i Typically you must be a root adminstrator user to sance add drivers Z 5 in the Driver Properties window enter a label representing the new driver and its description using the appropriate fields enter the path to the libmyodbc so file in the Driver field usr liblodbc libmyodbc so enter the path to the libodbcmyS so file in the Setup field usr lib odbc libodbcmyS so the final result should look like the figure Driver Properties new ES Iv x M Name Description Driver64 Jusr lib gt Setup 2 Setup64 fusr lib gt UsageCount 1 CPTimeout CPReuse 9 click the Save and Exit button to save the settings 10 click OK to open the Data Source Properties window 11 give the new data source a name enter its description then specify the MySql server address the database name and port 42 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Q Data Source Properties new O Iv X M Name midop on localhost Description mysql Driver myst
55. als e g 9 10 and 9 5 4 and 4 0 5 6 and 5 5 Published output 1 standard HTML frameset with pre generated earthquake tables earthquake interactive maps UTM zones and related intensity data points 2 places seismic histories available only if places have unique identifiers A browser capable of rendering SVG Scalable Vector Graphic is required for interactive maps and places seismic histories Firefox 3 x Safari 3 Opera 9 x Chrome Internet Explorer needs a SVG plug in enabler e g Adobe SVG Viewer www adobe com svg viewer install NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 2 1 Output examples homepage query by place query by earthquake Select an earthquake by clicking on the date Year Mo Da Ho Mi Se Epicentral area 1005 AREZZO 1091 01 27 Roma 1160 10 15 Subiaco 1161 01 16 Ceccano 1170 O05 09 Ceccano 1209 Appennino abruzzese 1246 SPOLETO 1258 Barrea 1276 Orvietano 1277 SPOLETO 1279 CAMERINO 1287 ABBADIA 3 1299 Rieti i 9 9 RB 9 RB RH 9 Ho ab pa HH D O Mw 3 75 4500 25 5 50 0 25 6500 25 macro oO O O 4 0020 25 5 00 0 25 6 00 0 25 6 75 Query by earthquake General earthquakes map homepage query by place query by earthquake Select an earthquake by clicking on the date 1456 12 05 Molise 7 22 et ii ici Meletti et al 1988 n of MDP 199 max Int 11 1005 AREZZO L 1091 01 27 Roma 1160 10 15 Subiaco 1161 01 16 Ceccano 1170 05 09 Ceccano
56. amp Assistant A Dictionary e ColorSync Utility DVD Player BB Console Expos DigitalColor Meter FileZilla E Directory Firefox amp l Directory Util ty Font Book Ej Disk Utility Front Row Grab Google Earth Grapher Cal W Java iChat Keychain Access Image Capture Lng Migration Assistant Sync Network Utility iTunes 22 ODBC Administrator Nail Podcast Capture Microsoft Office 2008 RAID Utility Photo Booth Remote Install Mac OS X em guosouUutm emlli c Preview System Profiler QuickTime Player E Termiral amp Safari o VoiceCver Utility Smultron X X11 bi Spaces gt Stickies El System Preferences TextEdit Thunderbird amp lime Machine 3 Utilities Il l of 28 selected 183 72 GB available 3 Check if the MySql driver is available to the system by opening the Drivers tab 36 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual ODEC Administrator User DSN System DSN Drivers Tracing Connecton Pooling About Driver File MySQL ODBC 5 1 Driver usr local lib libmyodbcS5 so An ODBC driver allows ODBC enabled programs to cet information from ODBC data sources To install new drivers use the driver s installer 1 j CI ck the lock to prevent further changes 4 Add anew ODBC connection in the User DNS tab that from now on you will use in order to transfer data to and from the selected data source ODBC Administrator
57. and generalized European Macroseismic Scale EMS 98 Gr nthal et al 1998 tab 2a which is the recommended scale to be used EMS 98 intensity Definition Description of typical observed effects abstracted 22 Not felt Scarcely felt Weak Largely observed NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Not felt Felt only by very few individual people at rest in houses Felt indoors by a few people People at rest feel a swaying or light trembling Felt indoors by many people outdoors by very few A few people are awakened Windows doors and dishes rattle Felt indoors by most outdoors by few Many sleeping people awake A few are frightened Buildings tremble throughout Hanging objects swing considerably Small objects are shifted Doors and windows swing open or shut Many people are frightened and run outdoors Some objects fall Many houses suffer slight non structural damage like hair line cracks and fall of small pieces of plaster Most people are frightened and run outdoors Furniture is shifted and objects fall from shelves in large numbers Many well built ordinary buildings suffer moderate damage small cracks in walls fall of plaster parts of chimneys fall down older buildings may show large cracks in walls and failure of fill in walls Many people find it difficult to stand Many houses have large cracks in walls A few well built ordinary buildings show serious failure of walls w
58. apped to the corresponding MIDOP field Fields with the symbol are required The following settings boxes are available 1 Macroseismic Intensity Points MDP parameters 2 Macroseismic Data Points html table columns definition 3 Options b Macroseismic Intensities Points MDP parameters J EQ unique identifier EGid archive 11 MDP unique identifier MDPid_archive y 1 place unique identifier NA4_NLOC v UJ place name Loc i place name shortened Loc Y place special case SC v U latitude LatMDP v 1 longitude LonMDP Y 3 latitude for territories LatMDPg v O longitude for territories LonMDPg v i intensity macroseismic scale v 1J intensity NA4 Is y 1 intensity numerical value NA4_Ic2 v G reliability Y 11 gazetteer v 2 gazetteer unique identifier H country Cou y 2 region M province v municipality v i municipality code v 62 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual EQ unique identifier MDP unique identifier Place unique identifier Place name Place name shortened Place special case Latitude and longitude Latitude and longitude for territories Intensity macroseismic scale Intensity Intensity numerical value Reliability Gazetteer Gazetteer unique identifier Country Region Province Municipality Municipality code Define the earthquake unique identifier The identifier can be a number or a text but it must fol
59. ased on these geographical areas will not be represented on map however their position if specified here will be included within the calculation of the earthquake intensity field extension The value must be expressed in geographical decimal degree Define the macroseismic scale adopted for expressing the intensity value Define the MDP observed intensity The value must be expressed with a text 5 5 6 6 6 7 NF F D HD Define the corresponding numerical value of the observed intensity value The value must expressed using decimal numbers 5 5 5 6 6 5 1 3 9 6 5 7 5 Define the reliability code of the assigned macroseismic intensity Define the source geographical Gazetteer from which the places information such as name and coordinates are taken Define the unique place identifier used in the source Gazetteer for identifying the place Define the place country code available codes in tab 2d Define the place second national administrative subdivision usually called region sometimes department district or canton Define the place third national administrative subdivision usually called province sometimes county Define the place municipality sometimes called city or town Define the place municipality code as defined at national level 63 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual gt Macroseismic Data Points html table columns definition 1st 2nd 3rd 4th St
60. at shaded 2D or hill shaded 3D Set the resolution quality of pre elaborated DEM to be included high or low Set the layer level where the DEM will be drawn in the map Set if the DEM will cover only the epicentral area where there are macroseismic observations or the entire geographical area Available layer style settings details for SVG tags are available at http www w3 org TR SVG painting html Layer opacity Stroke Stroke width Stroke color Stroke opacity Stroke miter limit Stroke dash array Stroke dash offset Stroke line cap Stroke line join Define the level of opacity or transparence of the geographical layer If enabled the geographical layer content will be drawn with a stroke Specify the stroke color expressed in hex triplet a six digit three byte hexadecimal number used in HTML CSS SVG Define the level of opacity or transparence of the fill color of the stroke Define the stroke miter limit Define the stroke dash array Define the stroke dash offset Define the stroke line cap Define the stroke line join Fill If enabled the geographical layer content will be drawn with a fill Specify the fill color expressed in hex triplet a six digit three byte hexadecimal number used in HTML CSS SVG Fill opacity Define the level of opacity or transparence of the fill color of the layer Fill color Important note about Geographical Layers Geographical layers are shared between all the web
61. ating the selected earthquake MDP list folder for storing symbols used when generating maps macroseismic intensity conversion table epicentre symbols definitions general earthquake map symbols definitions selected earthquake MDP map symbols definitions draw all the plotted epicentre symbols within the earthquake information frame 91 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 8 References Grunthal et al 1998 Gr nthal G ed Musson R M W Schwarz J and Stucchi M associated eds 1998 European Macroseismic Scale 1998 Cahiers du Centre Europ en de G odynamique et de S ismologie 15 Luxembourg 102 pp Hill 2006 Hill L 2006 Georeferencing the Geographic Associations of Information The MIT Press Massachusetts Institute of Technology Locati et al 2006 Locati M Meletti C Rovida A Rubbia G Ercolani E Meroni F 2006 A WebGIS tool for the dissemination of earthquake data EGU Vienna 2006 http www earth prints org handle 2122 2510 Locati and Cassera 2008 Locati M and Cassera A 2008 Online tools facilities for historical earthquake data investigation 6 International Conference on Scalable Vector Graphics Nuremberg http www svgopen org 2008 papers 49 Online_ tools facilities for historical earthquake data investigation Locati and Cassera 2009 Locati M and Cassera A 2009 MIDOP Macroseismic Intensity Data Online Publish
62. can use a fixed text or a field from the earthquake catalogue list Set the method used for the epicentre calculation You can use a fixed text or a field from the earthquake catalogue list Set the latitude of the epicentre The value must be expressed in decimal degree Set the longitude of the epicentre The value must be expressed in decimal degree Set the epicentral intensity value The value is usually expressed with a text 5 5 6 6 6 7 F D HD Set the corresponding numerical value of the epicentral intensity value The value must expressed using decimal numbers 5 5 5 6 6 5 3 9 6 5 7 5 Set the magnitude value This field can be a text Set the magnitude value using numerical values only Set the error associated uncertainty to the magnitude value This field can be a text example 0 2 gt 0 2 gt 0 2 Set the magnitude type Usual values are Mw Moment Magnitude ML Local Magnitude Ms Surface waves Magnitude mb Body wave Magnitude Set the magnitude source value who did provide the value Set the epicentre symbol to be used on maps The pop down selector contains the list of available choices Customization and creation of new symbols is possible by editing the PHP SVG source code button edit If you require to plot a rectangle representing the surface projection of the sismogenic source you can use this field for adding the 4 couples of coordinates of such rectangle The field must be c
63. cel closed source or OpenOffice Calc open source Spreadsheets are a comfortable solution both for creating new 19 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual data organising existing ones simple analysis and for sharing data with other colleagues In order to avoid misunderstandings about the transferred data between colleagues we would like to stress on the importance of always incorporate a description of the data content and a description of each field name used in table We encourage users to take a step forward in their data manipulation processes by adopting a relational database system in addition to a spreadsheet Packages such as Microsoft Access OpenOffice Base or Koffice Kexi are relational databases capable of facing complex analysis by using a relatively user friendly interface These instruments have been created with a series of constraints that helps people avoiding compilation errors that might produce unwanted publication mistakes 4 2 Input data table formats The Deliverable 4 of the NERIES NAA project called European macroseismic database 1000 1600 M gt 5 0 and its continuation in Deliverable 7 part 1 European Macroseismic Database 1000 1750 M 5 0 tries to establish a series of guidelines for macroseismic data compilation and validation MIDOP has been designed within the NA4 Working Group and adopts all of its guidelines Note that the represented field names are just
64. che Running L Svc MySql Running O Svc Filezilla Star L Mercury 29 Za 3 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Select phpMyAdmin within the web interface panel XAMPP Lite XAMPP Status This page offers you one page to view all information about what s running and working and what isn t working Documentation Components phpinfo CD Collection Biorhythm Instant Art Server Side Includes SSI Flash Art Phone Book Eo DE to the configuration may sometimes cause false negatives All reports viewed with SSL https localhost do not nction Tools phpMyAdmin VV CL f 7 T phpMyAdmin is a web tool written in PHP language that offers let you visually manage your MySql databases By using it you will be able to create modify and query both databases and tables and also upload and download your data content In the phpMyAdmin window create a new database for example called midop lower case and specify utf8 general ci as a collation from the drop down menu think about databases as a folder here you ll be able to store all the data tables about a project phpMyAdmin 23 Server localhost Databases ff SOL Status S Variables 2 Charsets EgEngines 3Privileges Aes e information schema Actions MySQL MySQL localhost UJ Sener localhost e Serer version 5 1 is Create new database A t k User rooti localhos Please select a database fi M
65. ck OF By clicking on the button Start of 1 Apache and 2 MySql you will enable respectively the web server and the database engine server XAMPP Control Panel Application EJ Modules O Svc O Svc O Svc O Mercury XAMPP Control Panel Apache MySql FileZilla Start Running Stop Running Stop Current Directory C xampplite Install Directory WARNING Directory mismatch Status Check OK Apache started Port 80 MySql started Port 3306 cu Status Refresh Explore Help Exit By pressing Stop you will turn off the servers b if you are using WAMP click on the system tray icon and select Start All Services 13 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Powered by Anaska a Localhost 3 phpMyAdmin www directory E E Apache Quick Admin Start All Services top All Services Restart All Services Put Offline I MacOS X MAMP package installation procedure Installation steps 1 Download the MAMP package from http www mamp info en mamp index html Drag the MAMP icon into the Application folder By using a text editor modify the file Applications MAMP conf php5 php ini and set the following variables as follow precision 18 max execution time 120 memory Limit 950M post max size 64M upload max filesize 64M error reporting E ALL amp E NOTICE display
66. croseismic Scale 1998 MSK Medvedev Sponheuer Karnik e g 6 6 7 7 7 8 Epicentral intensity numerical e g 6 6 5 7 7 5 Epicentre magnitude source e g references to a published paper Epicentre magnitude might contains also text Epicentre magnitude the corresponding numerical value Epicentre magnitude associated error Epicentre magnitude type how the epicentre is obtained manually or if calculated the adopted method mentioning the reference published paper or at least a descriptive text Table 1b Epicentres description data text text decimal decimal text decimal text text decimal text text In order to add another epicentre another set of dedicated fields must be added to the catalogue table Remember that within the same table two fields cannot have the same name so you will have to change it for instance by adding a progressing number e g Ep2Label Ep2Source Ep2Lal Ep2Lon Ep2Intensity Macroseismic intensity data table The macroseismic intensity data table stores the complete list of Macroseismic Data Point MDP for each earthquake Their scope is to describe as much as possible all those information retrieved in the original published earthquake study about places where the earthquake was felt 21 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Field Description Type EQid Earthquake unique identifier text or field
67. croseismic web mapping tool MIDOP manual e center coordinates fixed by using a couple of fixed coordinates View extension calculation method e fixed distance e based on the epicentre distribution o minimum distance o maximum distance Set how the default view extension of the map will be calculated by a specified value by calculating the complete geographical extension of all the plotted epicentres MIDOP can generate maps projected in UTM zones only It has built in support for European UTM zones such as 30 31 32 33 and 34 MIDOP includes e geographical layers such as countries first administrative subdivision and main rivers e place names to be represented on maps for geographical reference Seven geographical areas covering the whole Europe are available out of the box plus one at lower resolution covering the whole Europe UTM 28 Atlantic Islands UTM 30 Iberia UTM 30 UK nm p UTM 33 Fennoscandia EISE eMe Uren low resolution Q E e AS e r LS a i 1 S h 4 E T 7 pai cr of a A E 5j e at A due d 4 s y a t 2 bed gt 60 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual i detailed zoom scale value iJ available layers for whole Europe UTM 32 N F always present ll always present ll upload a new layer poe SUI T rh ch Layer O countries oF nmnaeim a DA YEI D fr mE L
68. d in the folder data separately for the general earthquake map and for single earthquake intensity maps and for each UTM zone and covered area following this structure e earthquakes maps data 1 layers eq Y o UTM zone 28 data layers_egq 28 Atlantic Islands data layers eq 28 atlantic_islands o UTM zone 30 data layers_eq 130 Iberian layers data layers_ eq 30 iberia UK layers data layers eq M30 uk o UTM zone 31 data layers_eqg 31 France layers data layers _eq 31 france o UTM zone 32 data layers_eq 32 talian layers data layers_eq1 32 italy entire Europe layers data layers_eq 32 whole_europe 79 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual o UTM zone 33 data 1 layers_eq 33 Eastern Europe layers data layers_eq 33 eastern europe Fennoscandia layers data layers_eq 33 fennoscandia o UTM zone 34 data layers_eq 34 Aegean layers data layers_eq 34 aegean An identical file structure is used for storing geographical layers for earthquake intensity maps in folder data layers_mdp V Layers files must follow some important rule e each layer file must contains only SVG elements of the same kind e g only path only rect or only circle e no groups must be present no lt g gt
69. dexes and keys import and export data and execute direct SQL commands Below a screenshot example showing a editing session of macroseismic intensity record phpMyAdmin ca Server localhost E Database midop E Table olial006_mdp EBrowse fe Structure SOL Search Zclnsert FS Export Ejlmport Operations Empty Drop Field Type Function Null Value Database EQid int 11 Do eie MDPid int 11 fosso Es 00315 Ribagorca la Ribagorca la midop 6 midop 5 PlacelD varchar 50 E olial006_cataloque Placellame varchar B0 E olial006_mdi E TUR ace Neat ARE E ref places E _storagevars_olial006_ Places varchar 4 E storage PlaceLat decimal 10 3 KA TELER TELI PlaceLon decimali 3 Gi PlaceLatTE decimal 18 3 PlaceLonTE decimal 18 3 xl Intensity varchar 50 IntensityMum decimal 10 11 Intensityscale varchar 10 Reliability varchar ca m m a GazetteerName varchar S50 71 sazetteerlD varchar 5 Country varchar 255 Region varchar 255 Province varchar 255 MunicipalityName varcharf255 Municipality Code varchar 255 Study varchar S50 LEE TE NA ACA Olivera etal 006 Go For a detailed explanation please refer to the phpMyAdmin user manual available at http www phpmyadmin net home_page docs php 49 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 9 MIDOP setup 5 1 MIDOP fir
70. e affected places and their macroseismic intensity o an interactive map of the macroseismic intensity points for every place mentioned it creates o the list of earthquakes and the relative level of intensity experienced o a diagram representing the level of damage experienced at the place for each earthquake publish the macroseismic studies on which published data are taken The features most requested by seismologists for such a tool are use of already existing standards in terms of input data table formats and content effortless online publication of the material reducing as much as possible problems while transferring material to IT staff complete coding free approach while publishing interactive maps featuring zoom pan and search trough the represented places use of a long standing and open technology avoiding possible future bottleneck or solutions that might disappear in the years to come possibility to interactively add points on already published maps export of the published material to downloadable files such as spreadsheets high quality images and high quality print easy to understand graphical user interface using as much as possible seismological terms advanced graphical customization both of the geographical features and symbols used Features requested by the IT staff are safety measures against probable online attacks lightweight technologies use of a small footprint server simplified source cod
71. e and epicentre map or maps if you chose to have more than one earthquake group c generation of each earthquake map and table of intensity observations The Publish the seismic histories part also previously mentioned in this document as query by place is a three step process 1 generation of the html frameset structure 2 generation of the list of available places 85 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 3 generation of each available place seismic history Each process will show a popup window that will inform you about the generation status At the end of the publishing process your website can be found in PUBLISHED SITES folder and will contain everything is needed to work Copy it to the final web server and that s it you will have your macroseismic data points online At every publication step process a series of log files are created helping you keeping trace of the parameters used in order to generate the website Below the description of the available logs e HIML structure generated log contains the parameters for generating the html frameset structure e Earthquake lists and epicentres maps generated log contains the list of MySql source tables and the content of the defined groups of earthquakes e Selected earthquakes maps and tables log contains the list of MySql source tables and the complete list of earthquakes generated e Place lists generated
72. e modifications in case of customization requests by researchers use of web standards where possible possibly open source and well documented MIDOP can be referenced as Locati M and Cassera A 2009 MIDOP Macroseismic Intensity Data Online Publisher Istituto Nazionale di Geofisica e Vulcanologia Sezione di Milano Pavia http emidius mi ingv it neries_ NA4 MIDOP NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 2 Quick reference MIDOP official homepage http emidius mi ingv it neries NA4 MIDOP available under registration Hardware configuration requirement e minimum CPU 2Ghz at least RAM 2Gb 4Gb for Microsoft Vista Operating system tested e Windows 2000 XP and Vista e MacOSX Tiger 10 4 and Leopard 10 5 e Linux Ubuntu 9 10 OpenSuse 11 Fedora 11 Additional software any AMP environment 1 web and DBMS server Apache 2 x configured with PHP 5 x and MySql 5 x 2 software for manipulating data tables content a online phpMyAdmin b offline Microsoft Access linked tables or OpenOffice Base Macroseismic data formatted minimum requirement 3 earthquake list table with a earthquake identifier code b origin time 4 macroseismic intensity points data table a earthquake identifier code b places latitude and longitude geographical coordinates decimal degree c amacroseismic intensities ordinal number and the corresponding numerical value expressed in decim
73. e place list Generate all the seismic histories 12 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 5 3 Multiple sites management MIDOP is capable of managing more than one site each using separate settings such as separate MySql source servers data tables frameset size or source field names geographical layers etc This is a major advantage by using one tool an unlimited number of websites can be managed easily Switching between sites can be performed without data loss at any time it is enough to specify which site must be used save the multisite preference and switch to the selected site control panel and settings MIDOP websites SHOW THE SELECTED SITE SETTINGS SAVE SETTINGS b site wars settings selected title directory name description date remove built in default website last modified August 24 2009 06 45 i detault vars_default remove created April 3 2009 12 52 website dedicated to the Hifi 2 validation process of the int monens Pom em librati initiati ugus H4 validation vars nad validation occ EL AREE remove created April 5 2009 20 54 website dedicated to the NH 4 E calibration initiative last modified August 24 2009 06 45 i A4 calilhratian vars nasa calibratiar remove created n May 5 2009 10 53 European Macroseismic Database website Preliminary last modified August 24 2009 06 45 Had EMD vars_na4_emd remove created May 14 2009 17
74. e system should be automatically started As we require to do some customizations turn the servers of by clicking on the button Stop Servers e the fe _ the aJ manage your manage your Status Status Stop Servers 3 L Start Servers Apache Server e Apache Server 1 a NN Open start page Open start page PMA MySOL Server A MySOL Server L Preferences J lt q Preferences 9 L Quit J C Quite MAMP control panel with Servers started MAMP control panel with Servers stopped 6 Click Preferences select the Ports tab and change the default ports values as follow then click OK Apache Port 80 1 65535 MySQL Port 3306 1024 65535 TTT Te _ _ _ _ _ Set to default Apache and MySQL ports Reset MAMP ports 7 Turn both servers on by clicking Start Servers Your OSX system is now ready for the MIDOP installation 15 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Linux Ubuntu LAMP installation procedure Execute the following terminal commands sudo apt get install apache2 sudo apt get install php5 libapache2 mod php5 sudo etc init d apache2 restart sudo apt get install mysql server insert the mysql root password when asked which will be used later sudo apt get install libapache2 mod auth mysq sudo apt get install php5 mysgql sudo apt get install php5 curl sudo etc init d apache2 restart sudo ap
75. e will appear within the place popup window If selected the link to Google map showing the place surroundings will appear within the place popup window gt Default view Li map center calculation method U MDP and epicentre coordinate median O MDF only coordinate median MDP with maximun intensity coordinate median O epicentres only coordinate median C center coordinates from field latitude longitude 2 view extension calculation method fixed distance 320 km fixed distance from field based on the MDP distribution minumum distance 200 km maximum distance 600 km Define how the default center of the map will be calculated e MDP and epicentre Define the map center to the coordinates resulting from the median coordinate median e MDP only coordinate median between plotted epicentres and all the intensity points Define the map center to the coordinate median resulting from all the plotted intensity points plotted Only places corresponding to large areas tab 2c that have coordinates will be used within the calculation e MDP with maximum intensity Define the map center to the coordinate median of the highest intensity coordinate median e epicentres only coordinate median value points plotted Define the map center to the epicentre only in case of more than one epicentre the center will be set to the coordinate median resulting from all the plotted epicentres e center coordina
76. ee chapter Advanced customization Switch on or off the layer use when creating an earthquake map Rename the layer file name the extension layer must be kept Layer file name files stored in data layers eq UTM covered area The level number at which the layer will be inserted within the map is automatically established by sorting the list of layer filenames alphabetically Change the layer s appearance style A popup window will appear see the image above where you can specify both fill and stroke and the layer opacity Set when the layer will be shown always present shown at medium and detailed zoom only on detailed zoom 67 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual e code e delete e upload a new layer SVG code from catalogue field Layer level Digital elevation model enabled e type resolution cover only the epicentral area include after level Edit the layer source code Delete the layer file a requester will prevent accidental deletion Load an additional layer file to MIDOP Set which catalogue field contains SVG objects that will be rendered on the map See the chapter 5 5 Set at which layer level the SVG code loaded from the catalogue field will be rendered MIDOP can include a DEM Digital Elevation Model when creating a map Switch on or off the DEM inclusion when generating a map Set the type of pre elaborated DEM to be included fl
77. eely available graphic tool Inkscape http www inkscape org which uses SVG as its native format of manipulating graphical object 82 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Once you ve done your changes within Inkscape remember to save the file as plain SVG code and again strip off all the unnecessary SVG lines of code Loading custom objects on selected earthquakes MIDOP can load custom SVG objects that will be rendered in selected earthquakes In order to obtain such feature you have to create a dedicated field within the earthquake catalogue table in which your SVG custom code will be stored You then need to tell MIDOP to load such SVG code by selecting the created field in the MDP page at SVG code from catalogue field see below and specify at which layer level MIDOP will render it edium zoom scale value IE 1 scale value ilable layers for iberia UTM 30 N Jee u upload a new layer 83 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 6 Publishing a site 6 1 Final publication introduction While reviewing your website within the control panel using the two top buttons query by earthquake and query by place MIDOP generates web pages in real time and only SVG generated maps are cached This method let you extensively test your website while tuning up available settings in order to obtain what you need This solution is not ad
78. em every new site will inherit these settings The list of all managed sites is kept in the file settings settings _vars php 5 4 Epicentre and intensity symbols MIDOP comes with a variety of predefined set of symbols for epicentres and for macroseismic intensities Epicentre set For every plotted epicentre one of the following symbols can be specified Symbol Available colors Black Blue Brown Cyan Green Orange Pink Red Violet Yellow DBMI04 intensities set This symbol set comes from the Italian Macroseismic Database 2004 http emidius mi ingv it DBMI04 NF 1 2 2 3 3 3 4 F 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 10 10 10 11 11 00000000000 0 74 Intensity value 9 10 10 11 11 Hexadecimal codes Fill FFFFFF FFFFFF FFFFFF FFFFFF FFFFFF A0E46F A0E46F 00FFFF 00FFFF FFA5FF FFA5FF HFFFFOO HFFFFOO HFF8224 HFF8224 FF0000 FF0000 9C31FF 9C31FF 00008C Stroke A0E46F 00FFFF FFA5FF HFFFFOO FF8224 FF0000 9C31FF 00008C 255 255 255 255 255 160 160 255 255 255 255 255 255 255 255 156 156 0 RGB values Fill Green 255 255 255 255 255 228 228 255 255 165 165 255 255 130 130 49 49 0 Blue NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual RGB values Stroke Green Blue DBMIOSG intensities set This symbol set comes from the Italian Macroseismic Database 2008 h
79. er 7 International Conference on Scalable Vector Graphics Mountain View http www svgopen org 2009 papers 102 MIDOP Macroseismic Intensity Data Online Publisher Locati and Cassera 2010 Locati M and Cassera A 2010 MIDOP Macroseismic Intensity Data Online Publisher Rapporti Tecnici INGV 123 92 pp http portale ingv it produzione scientifica rapporti tecnici ingv copy of numeri pubblicati 2010 2010 01 29 1754295499 Neumann 2007 Neumann A 2007 ArcView Shapefile to SVG converter Software tool http www carto net papers svg utils shp2svg Scotti et al 2004 Scotti O Baumont D Quenet G Levret A 2004 The French macroseismic database Annals of Geophysics 47 http www sisfrance net Schorlemmer et al 2004 Danijel Schorlemmer Adrian Wyss Silvio Maraini Stefan Wiemer and Manfred Baer ETH Z rich 2004 QuakeML An XML schema for seismology Observatories and Research Facilities for EUropean Seismology Newsletter Volume 6 no 2 http www orfeus eu org Organization Newsletter vol6no2 quakeml shtml Stucchi et al 2007 Stucchi M Camassi R Rovida A Locati M Ercolani E Meletti C Migliavacca P Bernardini F Azzaro R 2007 DBMI04 il database delle osservazioni macrosismiche dei terremoti italiani utilizzate per la compilazione del catalogo parametrico CPTI04 Quaderni di Geofisica INGV http emidius mi ingv it DBMI04 ECOS 2002 Swiss Seismological Se
80. ering the coordinates If selected the icon 2 amp gt will be available to the user and will let to see the selected map in Google Earth End users must have Google Earth previously installed on their system If selected the print tool will be available to the user with the icon Se in the map frame toolbox If selected maps will be created with the geographical grid layer graticule 1 by 1 Select which set of symbols must be used for representing observed macroseismic intensities By clicking edit the administrator can modify the PHP SVG file containing symbols for each set If alert or extended are selected every intensity symbol rendered on the map can be clicked by the user If alert only a simple system alert will appear with the place name and the intensity value if extended a popup window will appear with information such as place name the geographical coordinates and some other information see below If selected the link to the selected place seismic history will appear within the selected place popup window If clicked a new window will open The link will only appear if the place satisfy the minimum number of earthquakes occurred specified in the query by place settings page 65 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Wikipedia link Google maps link Map center based on If selected the link to the Wikipedia page about the selected plac
81. f a compulsory field is not set MIDOP will complain that a field is not filled and will not allow you to save the current settings page see example below EQ list EQ map MDP map Publish by earthquake FLUSH CACHED FILES SAVE SETTINGS gt Macroseismic Intensities Points MDP parameters The page at http localhost says l J EQ unique identifier M D MDP unique identifier MDPid A Please fill all the required fields 2 place unique identifier Placeld v 4 place name PlaceName v ij nlare name fshnartened PlaceName w 50 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual The control panel has a built in help system whenever you require further information click on the symbol and a popup message with an explanation will appear It is possible to customize these messages editing the file settings language language english help php Below the detailed list of available settings Page DB access This page is dedicated to configure the connection between MIDOP and the MySql database server and the table names with your macroseismic data You can use a server working on your computer or a remote server In order to connect to the MySql server a user name and a password are required and if using a remote server your computer IP address must be accepted by the server The following settings boxes are available 1 MySql access parameters 2 MySql selected database tables
82. for seismic history creation Enable the seismic history table download Closes places Closes places maximum Set the maximum distance in km for creating the list of closest places distance km b seismic history diagram 2 minimum intensity value represented in the seismic history diagram 4 5 UG minimum year value represented in the seismic history diagram 1000 1 seismic history diagram X axis years steps 100 Specify the minimum degree of macroseismic intensity represented in the place seismic history diagram Smaller intensities will not be represented Minimum intensity value represented in the seismic history diagram Minimum year value represented in the seismic history diagram Seismic history diagram X axis years steps Specify a minimum represented year in the diagram Specify the step in number of years for the X axis of the diagram gt place position map Li show a map with the place position G fixed distance of view extension 300 Li symbol size 1000 FF0000 Pd Li symbol color Show a map with the place If selected a map representing the place position will be shown 70 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual position Fixed M OM Specify the zoom level of the map extension Symbol radius Specify the radius size of the circle representing the place on the map Specify the color of the circle expressed in hex triplet a six digit three Symbol c
83. for UTM 28 zone layers used for UTM 28 zone in Atlantic Islands layers used for UTM 30 zone layers used for UTM 30 zone in Iberia layers used for UTM 30 zone in UK layers used for UTM 31 zone layers used for UTM 31 zone in France 89 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 32 italy 33 HHfennoscandia eastern europe 34 L aegean studies I images pdf svg maps places xls T images L kml nome simboli query eq Hexternal_call php I frame eq info php frame eq list frameset php frame eq list table php frame eq list table header php I frame eq mdp list php I frame eq mdp map php frame navigation bar php frame navigation bar external php function php index php make dem svg php I make eq js svg php I make eq map svg php I make layers svg php I make mdp js svg php I make mdp map svg php make symbols svg php Hmake_viewbox php H popup_addpoint php I popup study php I quakeml catalogue php I quakeml mdp php I save kml php save xls php query place I call eq php call place php frame navigation bar php frame places index php I frame places list php I frame places selected php graph php H index php Hmake_place_map_svg php save xls php root publish settings I index php settings vars php defaultvars Hdb_access php I eq info ph
84. fter some manipulation serve tables and maps within web pages Tables used by MIDOP are exposed to anything that can interact with MySql so a multitude of graphical front ends both stand alone applications and web applications can manipulate the same table contents Standalone relational database such as Microsoft Access and OpenOffice Base have an internal database engine but can also rely on external engines such as MySql In order to create a link to an existent MySql table the procedure is different between Access 2003 and Access 2007 Below both are explained together with phpMyAdmin application Using Access 2003 44 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 1 create or open a database and right click in the empty white space select Link tables Microsoft Access MIDOP Database Access 2000 file Format ERES File Edit View Insert Tools Window Help Adobe PDF Ce B RIEG RV 4 ae Ao Create table by using wizard Quae Create table by entering data olial006 catalogue F orms olial006_mdp Reports oliall0 references 3 EJ E EJ dE ES I2 View Li Pages ref_places Arrange Icons k Macros Line Up Icons Modules Import Groups 2 Link Tables Favorites aJ Relationships 2 Visual Basic Editor 2 select ODBC Databases from the Files of type drop down list Link Look in E Documents A a ow BE
85. g MA Morocco MC Monaco ME Montenegro MK Macedonia MT Malta ML Netherlands PL Poland 4 PT Portugal RO Romania RS Serbia E d ed ied e RU Russian Federation SI Slovenia FR France GG Guernsey RESOR BE W GR Greece SK Slowakia W HR Croatia W SM San Marina HU Hungary SY Syrian Arab Republic IL Israel TM Tunisia TR Turkey CUA Ukraine V Uk United Kingdom IT Italy JE Jersey JO Jordan LI Liechtenstein AR Isi Li number of earthquake for seismic history creatian 3 Li enable the seismic history table download li closest places i closest places maximum distance km e S Select which countries will be considered for creating seismic histories MIDOP will only list here countries mentioned in the field Country as specified in the control panel page MDP list Select the minimum number of earthquakes occurred in the place in order to create a seismic history If the place is mentioned in a number of earthquake inferior of this value the seismic history of the place will not be generated If selected the table with the list of earthquakes occurred in the place can be downloaded as MS Excel file files with xls extension If set a table listing places close to the selected places will appear at the page bottom Countries to be considered Number of earthquake
86. g the website See the Wikipedia page at http en wikipedia org wiki Meta tag for more information b Site language i default language english li general dictionary edit 3 help edit i special cases edit i countries edit Set the language of the entire site It will change also the control panel user interface language By clicking Edit you will be able to modify all the texts used In order to create a new language you must create 4 new files in settings languages Default language e language XXX php with the general interface terms e g language french php e language XXX help php with popup help information e language XXX sc php with locality special cases definitions e language XXX country php with the list of countries General dictionary Edit the general interface language text file Help Edit the help language text file used for popup windows within the control panel Special cases Edit the locality special cases language text file as specified in table 2c Countries Edit the the list of available countries as specified in table 2d Page EQ list In this page you configure the earthquake catalogue table tab 1a that you previously uploaded into MySql each field existing in your table must be selected and mapped to the corresponding MIDOP field Field with the symbol are required by MIDOP in order to work not setting these field will cause MIDOP fa
87. gt AddType application vnd google earth kml xml kml AddType application vnd google earth kmz lt ifModule gt kmz modify the PHP configuration file php ini by customizing the default value of the following parameters precision 18 Max execution time 120 memory limit 950M post max size 64M upload max filesize 64M error reporting E ALL amp display errors On short Open tag On auto detect line endings On magic quotes gpc On mbstring internal encoding enable the following PHP extension in php ini E_NOTICE 12 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual extensi n php curlcdll extension php dbase dll extensi n pio gal a Ll extension php mbstring all extension pap mexrypr all extension php mime magic dll extension php mysql all extension php mysql all extension php pdo mysql dll extension Php pdo odbe all Extensi n php soap dll extension php zip dll start the HTTP and MySql servers a if you are using XAMPP execute the xampp control exe the XAMPP Control Panel E XAMPP Control Panel Application EJ Modules O Svc O Svc O Svc O Mercury XAMPP Control Panel Apache MySql FileZilla Status Refresh Explore Help XAMPP Control Panel Version 2 5 95 May 2007 Windows amp 0 Build 6001 Platform 2 Service Pack 1 Current Directory C xampplite Install Directory Status Che
88. h 6th 7th 8th Sth 10th 2 columns title Place Lsc LathiDP LonMDP Columns title Columns content Chars Align Map link Default sort Sorting rules Export earthquake Page MDP map 3 columns content 2 chars 2 align H map link X default sort H sorting rules PlaceName v AZ v add a sort rule place name shortened 131 L v o IntensityNum vy ZA v remove Intensity Y ADL y remove place special case v 13 L vy AZ v addasortrule latitude v G Rv vy A gt Z v addasortrule longitude vii R v Y AZ v adda sort rule IntensityNum vy 224 v addasortrule intensity v 5 L o Intensity Y AoZ v remove PlaceName Y DZ y remove vy Z gt A v add a sort rule L gt v AD v remove v 2A v remove L v AZ v addasortrule v L vy AZ v addasortrule L vy OZ v addasortrule L v AZ v addasortrule Define the text to be used as a column header Define the column content source field Define the maximum number of characters of the column content If a text has a number of characters longer than this value the resulting text will be truncated Define the column alignment L left R right Define which column will be used as a link for finding places on the map Define which column is the table default sort Only one column can be set as the default sort Define the rules for sorting the column content
89. hard to do customization as well as manual operations These are tasks that NA4 working team could not afford Previous experiences in historical macroseismic map publishing systems available in Europe have been considered the Italian DBMIOA Stucchi et al 2007 the Swiss ECOS ECOS 2002 and the French SisFrance Scotti et al 2004 databases The best fitting solution to NA4 scopes was identified as the mapping solution adopted by DBMIO4 Locati et al 2006 http emidius mi ingv it DBMI04 internally developed at INGV But a straightforward adoption of the DBMIO4 solution was not possible because of the complete lack of a friendly graphical user interface and the tightly Italian oriented code not suitable for a broader use An improvement was required and the NA4 working team decided to create MIDOP which stands for Macroseismic Intensity Data Online Publisher a specific tool strongly inspired by the DBMI software but allowing web inexperienced researchers to easily transform unappealing tables into deeply customized interactive maps Before implementing the tool a series of requirements have been filed by listening to involved researchers and to the IT people of the different research Institutions NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual The tool addresses the following tasks managing one or more catalogues of earthquakes parametric or not for each earthquake creates o a table listing th
90. he XLS file for exporting the seismic history into Excel folder for published sites folder for the MIDOP control panel and all the managed website settings control panel homepage calls the user selected control panel page used for storing the list of managed websites default websites settings used when a new website is being created new sites default settings for connecting to the MySql server new sites default settings for the earthquake information frame new sites default settings for defining earthquakes parameters new sites default settings for creating earthquakes maps new sites default settings for the earthquake information frame new sites default settings for defining earthquake s MDPs new sites default settings for creating single earthquakes MDPs maps new sites default query by earthquake html page new sites default query by place html page 90 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Hpage_structure php place_history php homepage htm languages Hanguage english country php Hanguage english help php Hanguage english php L popup_help php page active country php HFactive_group php I database php I db access php edit page php I eq info php I eq list php Heq_map php Hexample php Hexport_site php Hflushcache php Hindex2 php I js script php Hayers_delete php I layers edit php I layers rename php layers style php Hayers_table ph
91. he name of the ODBC database you want to connect to Click Browse to select an ODBC database that is already registered in 2 Set up ODBC connection OpenOffice org Please contact your system administrator if you are unsure about the following settings Name of the ODBC data source on your system Choose a data source C OK midop on localhost o e Database Wizard Steps Set up the user authentication 1 Select database Some databases require you to enter a user name 2 Set up ODBC connection 4 Set up user authentication p User name root 5 S d d ave and procee MI Password required 39 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual e register the database connection into OpenOffice and open the created file QOD Database Wizard Steps Decide how to proceed after saving the database 1 Select database Do you want the wizard to register the database in OpenOffice org 2 Set up ODBC connection 9 Yes register the database for me 4 Set up user authentication O No do not register the database OTO II Pr After the database file has been saved what do you want to do MI Open the database for editing f Create tables using the table wizard Click Finish to save the database Help lt lt Back Finish Cancel To copy a table from a OpenOffice Base to MySql database you require two different OpenOffice Base files 1 a Base file wi
92. hile weak older structures may collapse General panic Many weak constructions collapse Even well built ordinary buildings show very heavy damage serious failure of walls and partial structural failure Strong Slightly damaging Damaging Heavily damaging Destructive A EI Many ordinary well built buildings collapse Devastating Most ordinary well built buildings collapse even some with good earthquake resistant design are destroyed Completely devastating Almost all buildings are destroyed Table 2a EMS 98 the European Macroseismic Scale 1998 Notes on the intensity notation e socalled uncertain intensity values such as 7 8 8 9 etc are accepted e intensity notation is of fundamental importance in order to let MIDOP plot the right symbol Do not use variants such roman numerals or other characters as they will not get plotted unless you create your own symbol set see chapter 5 5 Advanced Customization e MIDOP requires also a numerical translation of such intensity in order to being able to correctly sort tables and for the correctly layering of the intensity symbols on maps lower intensities will be displayed underneath higher intensities Special macroseismic intensity codes reference table extracted from NEIRES NA4 Deliverable 7 part 1 tab 2b Code Intensity code description E Environmental effects only e g landslide liquefaction W Environmental effects only e g sea or lake wave
93. hquake group e from EQ catalogue field Zoom tool e scale factor Pan tool e displacement in km at 100 scale Scale bar Tool for adding markers Export to Google Earth Print tool Grid MDP symbols popup window if user clicks on a place Seismic history link if available Select the geographical area where the earthquakes are placed You can put all the earthquakes in a single area inherit the group geographical area selection specified in control panel page EQ map or select a field in the catalogue table where a different geographical area has been specified for each earthquake If selected the zooming tool will be available to the user with the icon ou zoom in and e zoom out in the map frame toolbox Define the scale step factor to be used with the zoom tool the lower is this percentage the lower will be the different scale factor between each click If selected the pan tool will be available to the user with the icon Eg in the map frame toolbox and users will be able to pan the map Define the displacement steps to be used with the pan tool If selected a graphical scale will be available to the user in the lower part of the map The units of measurements are expressed in kilometers If selected the tool for adding new markers on the map will be visible in the map frame toolbox End users will be able to add a temporary marker over the selected earthquake map by ent
94. i group earthquakes using a field ea group Li label field eg group label EMD 1000 1750 I EMD 1900 on e i time spanned earthquake groups separated by underscore eg 272 1800 500_1000 remove 1001_1500 remove 1501_1900 remove add time span AE EAr UAE If set one earthquake list only with all the earthquakes will be created group e group label Set the label to be used for creating the link in the upper frame of the window VO PE quae If set multiple earthquake lists will be created groups e group earthquakes Create as many groups as specified by the selected field This field name used for using a field grouping earthquakes and for sorting the list of groups e label field Define the text label to be used for identifying each earthquake group Set each group time span subdivision By clicking the button add time span you can enter a new time spanned earthquake group Only year are accepted for Time spanned defining a time span and year must be separated by the symbol Overlapping earthquake groups time windows are possible but it will result in earthquakes listed in more than one group The label for the upper frame link of the window will be created automatically Page EQ map This page let you customize the appearance of the map representing all the earthquakes listed in the selected earthquake catalogue list The following settings boxes are available 1 Map options 2 Default v
95. ields terminated by o check your imported data by clicking on the Browse tab Data upload via ODBC This section covers the procedure on how to transfer a table from Microsoft Access to MySql using an ODBC Open Database Connectivity http en wikipedia org wiki ODBC In order to let Access and MySql communicate directly Windows need to know which driver must be used while transferring data such database engine driver will transparently maps Access data into MySql and vice versa with just a couple of clicks A A Windows The MySql ODBC driver is freely available on the MySql website Follow these installation steps 1 Download and install the MySql driver connector Windows MSI Installer package from http dev mysql com downloads connector odbc 2 Once the automatic installation procedure ends check if the driver is correctly installed by opening the Data Sources ODBC navigate to Control Panel Administrative Tools the MySql driver should appear in the list of installed Drivers tab 32 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual ODBC Data Source Administrator User DSN System DSN Fe DSN Diver ODBC Drivers that are installed on your system Name Version Company Microsoft Paradox Treiber db 6 00 6001 18000 Microsoft Microsoft Text Driver txt csv 6 00 6001 18000 Microsoft Microsoft Text Treiber txt csv 6 00 6001 18000 Microsoft Microsoft
96. iew 3 Map layers 4 Earthquake parameters 98 NA4 D Part 2 Improved macroseismic web mapping tool MIDOP manual b Map options Li geographical area Li info an map 1J zoom tool Li pan tool Lil scale bar 1 timeline slider Li geographical grid Li grid stroke width Li grid label size Geographical area fixed fixed for single group Info on map Zoom tool scale factor Pan tool displacement in km at 100 scale Scale bar Timeline slider Geographical grid Grid stroke width Grid label size fixed whole_Europe UTM 32 NJ cw fixed for single group 1000_1750 1751 18989 Cw atlantic islands UTM 28 N atlantic islands LITh4 28 N Li scale factor 20 1J displacement in km at 100 scale 80 is s S Select the geographical area where the earthquakes listed in the earthquake catalogue list are referred to If you created more than one sub sets of earthquake groups you can specify a geographical area for each group If selected a text will appear in the upper part of the map when the user will put the mouse pointer over an earthquake symbol The text will contain information about the earthquake such the date and the epicentral area If selected the zooming tool will be available to the user with the icon QQ zoom in and El zoom out in the map frame toolbox Define the scale step factor to be used with the zoom tool the lower is this percen
97. ight of the upper left part of the frameset containing the earthquake list The number can be expressed as a percentage value where 100 is the entire window height or in number of pixels Set the earthquake list table header height useful if you want add some static text above the list The number can be expressed as a percentage value where 100 is the entire window height or in number of pixels Set the height of the middle part of the frameset containing the detailed earthquake information The number can be expressed as a percentage value where 100 is the entire window height or in number of pixels navigation bar navigation bar earthquake catalogue eq list selected earthquake selected earthquake intensity points map information eq mdp map eq info mE selected earthquake macroseismic intensity points eq mdp list Above the frameset layout in italic the actual html frame name 92 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual b Site meta tags li author i copyright 1 keywords Lil description Author Set the website author META tag information Copyright Set the website copyright META tag information Keywords Set the website list of keywords META tag information Description Set the website description META tag information IMPORTANT NOTE You should carefully fill all the html META tags information such data will be used by web search engines for indexin
98. iling creating tables and maps The following settings boxes are available 1 Earthquake parameters Earthquake studies Earthquake epicentres Earthquake list table columns definition Earthquake groups arpa 19 93 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Earthquake unique identifier P Earthquake parameters 2 EQ unique identifier EGid archive year web Year month web Mao day web_Da Y date hour web Hao minutes weh Mi hd seconds weh Se Li epicentral area web Ax i epicentral area shortened web Ax bl Li study unique identifier Ficode Li study short citation Study 1 references refCode Set the earthquake unique identifier The identifier can be a number or a text but it must follow some rules it can not contains spaces nor special character such e i accents apostrophes parenthesis symbols lt gt S Only the symbol underscore is allowed This parameter must be always set and it will be used by the system to create references between tables This parameter will also be used for the dynamic file name creation of the final website files Date e year Set the date of the earthquake also called origin time Once you will set year e month month day hour and seconds the control panel will consider them all together as e day date This parameter must be always set but some of the sub parameter such as e hou
99. ines Windows MacOSX PPC MacOSX Intel Linux Gecko based Firefox 2 x Camino 1 6 x Epiphany 2 2 x OK OK OK OK Internet Explorer 6 x OK WebKit based Safari 3 x Google Chrome 1 x OK OK OK 2 Opera 9 5 OK OK OK OK KHTML based i l a Konqueror Internet Explorer requires a plug in in order to show SVG content MIDOP has been successfully tested using the Adobe SVG Viewer plug in http www adobe com svg viewer On PowerPC based Macs Macs sold prior to year 2006 Safari for OSX have problems if the plug in Adobe SVG Viewer is installed NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 4 Input data preparation 4 1 Data management Macroseismic intensity data are usually stored heterogeneously The tiding up process performed in order to create a scientific publication requires among others reformatting the raw data georeferencing places on a map create a list of bibliographical references and obviously mention the main scientific text accompanying the published data Think about MIDOP as an alternative way of publishing this material By using this tool you can e publish a list of earthquakes based on an earthquake catalogue table e publish a map and a table for each earthquake based on a list of georeferenced places which have been affected by some degree of intensity e publish the bibliographical references based on a reference table e publish the scientific study accompanyi
100. ke studies MIDOP can publish Macroseismic Earthquake studies related information from which the intensity points are taken Bibliographical citations original documents as PDFs files related images and link to external web pages can be specified for each study mentioned in the earthquake catalogue In order to publish such information a bibliographical table must be prepared tab 4 Description Simplified code representing the study Trailing spaces and special characters must be avoided text or field used to link to the corresponding field in the earthquake catalogue number and used for naming study related PDFs and images Short bibliographical citation mentioning the main author and the date of study publication e g Stucchi M 2009 Stucchi amp Locati 2009 Stucchi et al 2009 The field content is the same as the corresponding field in the earthquake catalogue Complete bibliographical citation of the study with authors year of publication title and publisher ExternalPageURL Address link to an external web page containing online relevant information about the study ExternalPDFURL Link to an external website with the PDF file of the study text YearOfPublication Year of publication of the study integer StudyAuthors List of the authors of the study text StudyLanguage Language used in the macroseismic study text StudyCode ShortCitation long text text CompleteCitation text Table 4 Mac
101. l character such i accents apostrophes parenthesis symbols lt gt S Only the symbol _ underscore is allowed This parameter will be used for the dynamic file name creation of the final website files Set the short version of the earthquake study citation If set this field will be used for creating the html text of the popup window referring to the study and for the dynamic file name creation of the stored files Set the study complete citation text If set will be used in the popup window with the study detailed information Set the URL address pointing to an external web page with relevant information about the study If set the link will appear in the popup window with study information Set the URL address pointing to an external PDF containing the study or relevant information about it If set the PDF link will appear in the popup window with study information Set the study publication year Set the author s of the study If set the specified information will be shown in the popup window that appear clicking on the link of the study citation 2 published 2 references identifier e references code RefCode references code hd study unique identifier T i complete citation RefCitation M i year of pubblication Refrear ID Li authors Ref uthor I i language RefLanguage El Set the reference source unique identifier This field is required in order to link the earthquake
102. ldes de Malavella Olivera et al 2006 411427 05 15 15 Vall d en Bas Olot Olivera et al 2006 1427 04 23 11 Lloret Salvatge Olivera et al 2006 W 1427 04 22 22 Lloret Salvatge Olivera et al 2006 4 1427 04 13 Osor amp mer Olivera et al 2006 J 1427 03 19 21 Osor 4mer Olivera et al 2006 Earthquake list 4 1427 03 15 23 Amer Olivera et al 2006 W 1427 03 14 12 Amer Olivera et al 2006 only selected W 1427 03 13 11 Amer Olivera et al 2006 earthquakes W 1428 02 02 08 Camprodon Olivera et al 2006 will be created 1448 05 25 01 Near Granollers Olivera et al 2006 1450 09 16 10 Pirineus Olivera et al 2006 Start generating the whale website Generate the whole website or generate only a specific query by earthquake area generate the EU catalogue generate all the earthquakes and epicentres map selected maps andtables generate the HTML structure P Publish the seismic histories part I generate the generate all the place list seimic histaries generate the HTML structure i The Publish the query by earthquake part is dedicated to the publishing of the catalogue its map of earthquakes and each earthquake intensity map and MDP tables The entire process is subdivided in three sub processes a generation of the html frameset structure all the html files that will be filled with the content b generation of the earthquake catalogu
103. le for l should not be used for earthquake i i meaning of intensity mie intensity assessment parameters determination coordinates are assessed F G3 intensity assignment G4 or G5 grade damage of the is not compatible with EMS98 are assessed the statistical These MDPs should not be used meaning of intensity for earthquake parameters determination these MDPs cannot be used for earthquake parameters determination small settlement single isolated isolated building A building building standing alone like a light tower a country church etc settlement whose information may not traditional place name Strictly refer to the multiple refers to a set of small place name settlement settlements in a limited However no better area including small interpretation can be islands provided abandoned locality the seismic history deserted eventually rebuilt may show locality elsewhere with the interruptions or non same or another name seismic gaps assess intensity and coordinates The code represents a warning for the user assess intensity and coordinates The code is a warning for understanding the seismic history assess intensity and coordinates same as above The code is a warning for understanding the seismic history place name and the assess Is and coordinates coordinates may be The code is a warning for somewhat arbitrary understanding the seismic history absorbed a locality absorbed into locality a larger
104. low some rules it cannot contain spaces nor special character such i accents apostrophes parenthesis symbols lt gt 2 S Only the symbol _ underscore is allowed This parameter must be always set and it will be used by the system to create references between tables This parameter will also be used for the dynamic file name creation of the final website files Define the macroseismic data point identifier it can be a number or a text but it must follow some rules it cannot contain spaces nor special character such i accents apostrophes parenthesis symbols lt gt S Only the symbol _ underscore is allowed This parameter is required Define the cited place identifier it can be a number or a text but it must follow some rules it cannot contain spaces nor special character such i accents apostrophes parenthesis symbols lt gt S Only the symbol _ underscore is allowed This parameter must be always set Define the place name of the macroseismic data point Define the truncated version of the place name of the macroseismic data point It will be used for html content creation Define the place special case code See the locality special case code tables in chapter 4 2 Define the MDP latitude and longitude The value must be expressed in geographical decimal degree Define the MDP latitude and longitude for territories Observations b
105. mmon functions query by earthquake HTML frameset generates the MDP map DEM Javascript functions used in the earthquakes map generates the earthquakes map generates the layers to be included into maps Javascript functions used in the selected earthquake MDP map generates the selected earthquake MDP map generates the symbols to be included into maps generates the map view parameters SVG viewbox functions for adding points in realtime into an existing map file delle pop up contenenti le informazioni dello studio del singolo terremoto generates the QuakeML file for exporting the catalogue generates the XML file for exporting the list of MDP for each earthquake generates the KML file for exporting the list of MDP into Google Earth generates the XLS file for exporting the list of MDP into Excel folder for MIDOP files used for generating the query by place contains functions for calling an earthquake from the seismic history diagram used when receiving calls from an external website requesting a place seismic history html loaded into the frame navigation bar contains generated link html loaded into the frame places index contains the index alphabet html loaded into the frame places list contains the list of places html loaded into the frame place selected contains the selected place seismic history generates the selected place seismic history diagram query by place HTML frameset generates the selected place map generates t
106. ng the data The whole process of publishing within MIDOP requires that data tables are well formatted The key point of well formatting in MIDOP is the concept of unique item identifier code Each basic element must be uniquely identified in order to be able to recall it from other elements Some examples of unique identifiers considered in MIDOP e every earthquake in the catalogue must have a unique identifier code as it will be used by its related macroseismic intensity observations e every macroseismic intensity observations has a unique identifier e places mentioned by macroseismic observations have a unique identifier in all earthquakes they are used for creating places seismic histories and they might refers to a geographical gazetteer Unique identifiers in MIDOP are preferably abstracted codes or simply numbers It must be said for example that in historical seismology the origin time cannot be the identifier code because the big time range uncertainty might cause overlapping earthquakes A simple solution is to adopt integer numbers or if you prefer a combination of numbers and letters to make it easier the identification The unavoidable rule about unique identifiers is to avoid spaces and special characters such as i fi aem T ESA The amount of records involved in historical seismology is usually small and its data manipulation is possible using general purpose spreadsheet software such as Microsoft Ex
107. nk com content m2578573521h4n60 ExternalPDFURL http www springerlink com content m2578573521h4n60 fulltext pdf YearOfPublication 2008 Authors Albini P and Vogt J Table 4a Study bibliographical record example As we want to show also a thumbnail image of the whole study using a paint program we create an image with the front cover of the study we called it ALBVO008 jpg and we store it in the folder data studies ALBVO008 The image will show up in the bibliographical popup window every time users will click the corresponding study Suppose that the catalogue that is going to be published considers three earthquakes from this study the 11 September 1661 the 12 March 1662 and the 1664 earthquakes all in Zakynthos Greece Three PDF files and three thumbnail images are created respectively both PNG or JPG can be used e ALBVOOO8 1661 09 11 pdf and ALBVOOO8 1661 09 11 png e ALBVOOO8 1662 03 12 pdf and ALBVOOO8 1662 03 12 png e ALBVOOO8 1664 paf and ALBVOOO8 1664 png These PDF and images will only show up in the popup window when the corresponding earthquake is selected from the catalogue References or sources used Users might want publish the list of all of the used bibliographical resources for each earthquake Such material depending on the procedure followed by the investigators might be called references or sources MIDOP supports such feature but an additional table is required
108. nt machine C Create New Data Source E MySQL Connector ODBC Data Source Configuration Select a driver for which you want to set up a data source M uso Connector ODBC Microsoft ODBC for Oracle 6 E Microsoft Paradox Driver db 6 Microsoft Paradox Treiber db 6 oeste Microsoft Text Driver txt sv 6 Microsoft Text Treiber txt csv 6 Microsoft Visual FoxPro Driver 1 Data Source Mame MIDOP database on localhost 4 z iber 113 MySQL ODBC 5 1 Driver 5 TUNE a BL Description 4 n j Server localhost Port 3306 User root Password NE Database midop Test Cancel Details gt gt Cancel Help 33 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Click ada in order to create a new ODBC data source Select User data source applis only to this machine only then click Next Scroll the list of available source driver until you find MySQL ODBC 5 1 Driver then click Next In the Data source name insert the connection label enter a text that will helps you later remembering the data stored in the database you are going to connect to You can enter also an extensive text Description of the connection if you want In the Database field you must enter the exact name lower upper case sensible of the MySql database In User and Password you must insert a MySql use
109. olor byte hexadecimal number used in HTML CSS SVG representing the place on the map MIDOP has the built in functionality to extrapolate the places seismic histories The only condition in order to create such feature is that places within the macroseismic database must have a unique identifier For example the town Milan must have always the same identifier so that MIDOP can process the whole database tracking down every earthquake in which Milan appeared Page Publish This page let you publish your website in its final version Publishing a website mean that you will create a folder MIDOP PUBLISHED_SITES containing all the files required in order to load your website in Internet There are two main publishing areas one for the query by earthquake and the other for the query by place Each part has been divided in publication steps in order to let you better control the publication process lf you repeat one step you will overwrite previously published files this is useful for updating only those parts that are being updated The time required for the complete publication of a website varies based on many factors the CPU performance of the computer used for the website development the size of the RAM memory the number of earthquakes and the number of mentioned places Also the DEM inclusion will heavily affect the publishing time Just to have an idea a website containing more or less 1000 earthquake
110. ompiled with 4 couple of coordinates expressed in decimal degree Use to separate each couple and the symbol _ to separated longitude and latitude lon1_lat1 lon2_lat2 lon3_lat3 lon4_lat4 For example 15 5567 40 4425 15 642 40 5316 16 042 40 1726 16 1273 40 2617 Set the line color of the box using HTML color code HTML colors are defined using a hexadecimal hex notation for the combination of Red Green and Blue color values RGB The lowest value that can be given to one of the light sources is O hex 00 The highest value is 255 hex FF 96 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Set the preferred epicentre Useful when many epicentres are shown on the map as it help to highlight which one is the selected choice by the compilers This field must contain the exact text describing the selected epicentre source selected above The symbol used by the system will be the above selected symbol _ preferred as described in the PHP SVG code If you created more than one epicentre in your earthquake catalogue table by clicking Add an epicentre this button you will be able to add as many epicentre as you require each with its parameters and its symbol Preferred epicentre source b Earthquake list table columns definition Li column title li column content li chars Lil align Ll link LH default sort Li sorting rules ist YearkoDaHoMii date el left a e earthquake web Date A gt
111. ou must specify the geographical area for each place For example if you want to show Paris both in UK and France maps you must insert Paris twice in this table one will be used while generating maps for the UK area and the another will be used while generating maps for the France area If you plan covering an extra European area you should integrate the new places within the built in table called ref places structured as follows Description Record unique identifier This is not a place identifier as the same place can be inserted more than one time RecordiD PlaceName Place name text or number text PlaceNameDistant Place name displayed when the map will be zoomed out text PlaceLat degree Place latitude in geographical coordinates in decimal decimal 25 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Place latitude in geographical coordinates in decimal degree When to show the place on the map MIDOP accepts one large If text PlaceLon decimal 5 tt 5 tt ZoomLevel of these 3 zoom values detail medium empty the place will never appear Geographical area code where the place will be shown MIDOP has these built in areas atlantic islands iberia france uk italy eastern europe fennoscandia aegean GeographicalArea Table 3 Map reference places data 4 3 Macroseismic earthqua
112. p I layers upload php I lightbox css Hightboxiframe js Hmdp_list php Hmdp_map php I page structure php piker png Holace_history php Horototype js Hpublish php I publish maker php Ii publish maker place php settings php svg edit page php Htable_colors php utility class php utility settings php _utm_group php query Heq_list_query php moap list query php symbols Hsymbol_conversion php Hsymbol_epicentre php I symbol eq map php Hsymbol_mdp php L_symbol_return php T E cR new sites default settings for the html frameset structure new sites default settings for creating a place seismic history page new sites default html homepage folder list of available countries english used for storing the control panel help language english general MIDOP language file english html popup window used for showing help information within the control panel folder for each control panel page generates the list of countries to be used into the Query by pace page file di supporto allla pagina di settaggi dei cataloghi dei terremoti functions for calling the MySql server and selecting data control panel DB access page control panel source code editor popup window control panel earthquake information page control panel EQ list page control panel EQ map page example shape within the popup window for styling geographical layers expor
113. p I eq list php Heq_map php I html info htm Hmdp_list php Hmdp_map php Hpage_info_introduction htm Hpage_places_introduction htm layers used for UTM 32 zone layers used for UTM 32 zone in Italy layers used for UTM 33 zone layers used for UTM 33 zone for Fennoscandia layers used for UTM 33 zone for eastern Europe layers used for UTM 34 zone layers used for UTM 34 zone for Aegean folder for storing bibliographical material about used studies studies images studies PDFs folder for temporary cache of SVG files cached SVG maps cached SVG seismic history diagrams cached XLS table files folder for storing all bitmap images used by MIDOP folder for storing bitmap symbols to be used in exported Google Earth files folder for MIDOP files used for generating the query by earthquake part used when receiving calls from an external website requesting a specific earthquake html loaded into the frame eq_info contains information about the selected earthquake frameset loaded into the frame eq list contains the earthquake list and its header html containing the earthquake list or catalogue table html containing the earthquake list or catalogue table header html containing the selected earthquake MDP table html containing the selected earthquake MDP map html loaded into the frame navigation bar contains generated link html of the navigation bar used when receiving external calls geographical conversion operations and other co
114. page query by earthquake ABCDEFGHIJKLMN Seismic history of San Polo Matese San Polomatese OPORSTUVWXYZ 41 459 14 494 Total number of earthquakes 3 pen Freer Gr OEUDAD ie Da 2 Effects Earthquake occurred San Pietro in Amantea IT CS 8 San Pietro in Cariano IT VR 10 Is Year Mo Epicentral area Study San Pietro in Casale IT BO 3 San Pietro in Guarano IT CS 12 10 1456 12 MOLISE DOM San Pietro in Lama IT LE 4 10 1805 07 Molise CFTI San Pietro Infine IT CE 13 San Pietro Mussolino IT VI 3 5 1984 05 Appennino abruzzese GETI San Pietro Vernotico IT BR 5 San Pio delle Camere IT AQ PAR FOTONE ee T al de 12 Is San Polo Matese San Polomatese San Polo dei Cavalieri IT RM 4 S Polo Matese S Polomatese IT CB 3 San Possidonig IT MO 4 San Potito Sa co IT CE 6 San Potito Ult IT AV 4 San Prisco TT CE 5 San Procopio IT RC 5 San Prospero IT MO E San Quirico d Orcia IT SI S8 San Quirino IT PN 4 San Remo IT IM 15 San Roberto IT RC 5 San Rufo IT Si 9 San Salvatore di Fitalia LT ME 8 San Salvatore Telesino IT BN 6 San Salvo IT CH 7 San Savino IT RN 3 San Sebastiano Curone IT AL 4 San Secondo di Pinerolo IT TO 3 San Secondo Parmense IT PR 9 380 530 680 830 980 1130 1280 1430 1580 1730 1880 San Severino Lucano IT PZ 9 San Severino Marche IT MC 27 San Severo IT FG 37 San Sisto dei Valdesi LE CS 4 San Sossio Baronia IT AV 9 San Sostene TT CZ 7 San Sosti IT CS 12 eL Aquila San Sperato IT RC 3 San Teodoro IT ME 6 5 Tomaso Celat 5 Tomaso IT
115. quake study citation If set this field will be used for creating the html text referring to the study Set the list of references used within the macroseismic study If set this field will be processed in order to retrieve all the codes separated by a semicolon The resulting codes will be used for creating the link to the reference table b Macroseismic earthquake studies U published i study unique identifier StudyCode d Li short citation Shortcitation f Li complete citation CompleteCitation Ei i link to an external web page ExternalPageLiRL Fal LG link to an external PDF ExternalPDFURL E L year of publication YearOfPublication EX i authors StudyAuthors 7 i language StudyLanguage 54 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Study unique identifier Short citation Complete citation Link to an external web page Link to an external PDF Year of publication Authors Publish Reference code Reference code and study unique identifier Complete citation Year of publication Authors Language b References Sources Set the unique identifier code of the study This field is required in order to link the earthquake list table with the studies table where all the complete descriptions links and other information are kept This identifier can be a number or a text but it must follow some rules it cannot contain spaces nor specia
116. r enabled to work on data from your computer If you are using a XAMPP Lite based installation just enter root without a password otherwise you must specify the password entered while installing MySql For advanced users we remember that phpMyAdmin offer a comfortable way of managing MySql users through a visual interface Privileges tab From now on you will be able to connect to this data resource from every application ODBC enabled You are now ready to transfer data from Access and MySql with a couple of clicks Note that this connection works in both ways you can export but also import data tables from MySal In order to export a table from Access to MySql follows these steps 1 In Access left version 2003 right version 2007 right click on the table that you want to transfer to MySql a Microsoft Access test Database Access 2000 file format 2 Cut E il File Edit View Insert Tools Window Help ypeaq lt Lia Copy fi a3 a W 4 F f id J Format Painter B UA EBE Clipboard E Font Rich Text Create table in Design view Tables Create table by using wizard Gi olial006_a 8 Open n Ei olial006_n v mE Create table by entering data Jueries Design View H Y jj olial006_r Forms EH Import Reports i i Exporta p Excel Pages i z Collect and Update Data via E mail SharePoint List Macros E Rename gt Word RTF File RARO oe gt Acc Modules Hide in this
117. r seconds minutes or hour could be left unset This parameter will also be used for e minutes the dynamic file name creation of the final website files e seconds Epicentral area Epicentral area shortened Study unique identifier Study short citation References Set the extended text representing the epicentral area This field is not required to publish a site if it is set it will be available in the control panel for example for the label that will appear in the general earthquake map It will be used by the system for creating the epicentral area field within downloadable MS Excel files Set the shortened text representing the epicentral area This field is not required to publish a site if it is set it will be available in the control panel It might be useful for saving space when creating html table columns in the earthquake catalogue list Set the unique identifier code of the study This field is required in order to link the earthquake list table with the studies table where all the complete descriptions links amd other information are kept This identifier can be a number or a text but it must follow some rules it cannot contain spaces nor special character such accents apostrophes parenthesis symbols lt gt S Only the symbol _ underscore is allowed This parameter will be used for the dynamic file name creation of the final website files Set the short version of the earth
118. rate the EU catalogue generate all the earthquakes HTML structure and epicentres map selected maps and tables Time span filter By specifying a starting and a final year all the earthquakes occurred in e from year such time span will be selected from the list leaving other earthquakes e to year unselected This is useful while updating only a sub set of the entire Apply the filter earthquake catalogue Select all I Select all or unselect all the earthquakes listed in the table Select none Earthquake list Contains all the earthquakes listed in the selected earthquake catalogue Generate the final entire website HTML structures catalogues and maps Generate all the html files defining the website structure of the query by earthquake part of the final website Generate the whole website Generate the HTML structure Generate the EQ catalogue and epicentres map Generate all the earthquakes selected maps and tables Generate the earthquake catalogue and its corresponding map Generate all the earthquake intensity map gt Publish the seismic histories part generate the generate the generate all the HTML structure place list seimic histaries Generate all the html files defining the website structure of the query by place part of the final website Generate the list of available places Generate of each available place seismic history tables diagrams and maps Generate the HTML structure Generate th
119. rative boundaries http www istat itfambiente cartografia o Shuttle Radar Topography Mission SRTM Files used for generating the raster DEM covering the whole of Europe and surrounding areas http www2 jpl nasa gov srtm e modified code file database php for managing MySql database calls Joomla project Copyright C 2005 Open Source Matters GNU GPL License http www joomla org e modified code mosHTML class from the file joomla php for managing HTML form content dynamically Joomla project Copyright C 2005 Open Source Matters GNU GPL License http www joomla org e modified code files jquery js and jquery tablesorter js for managing tables content via Javascript jQuery JavaScript Library GNU GPL v2 License http jquery com e Lightboxes HTML object by Chris Campbell used while publishing a website http particletree com features lightbox gone wild 94 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 9 3 Credits This product has been designed and developed by Mario Locati locati mi ingv it and Andrea Cassera with contributions of participants of the module Networking Activity 4 Distributed Archive of Historical Earthquake Data of the project NERIES The present manual is by Mario Locati Special thanks to the massive support by Massimiliano Stucchi and all colleagues involved at INGV Sezione di Milano Pavia http www mi ingv it Big thanks also to beta tester
120. roseismic earthquakes studies data By specifying a link in the above table MIDOP will automatically show the external link within the popup window containing bibliographical information A similar link will appear if an external PDF is filled in PDFs stored on your computer can also be published these files must be named using the StudyCode with pdf as file extension and stored in the folder data studies YOUR STUDY CODE MIDOP will automatically scan the study archive folder and the PDF will shows up in the bibliographical popup window A similar procedure is used for publishing study images PNG or JPG image files must be named StudyCode with extension jpg or png and stored in the relative study folder 26 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Additionally to the above methods MIDOP has a way of linking PDF and images to subsets of a study By naming a PDF or an image with StudyCode and the complete earthquake date the file will be show only when that specific earthquake will be selected Here an example on how to compile a study bibliographical record tab 4a StudyCode ALBVO008 ShortCitation Albini amp Vogt 2008 Albini P and Vogt J 2008 A glimpse into the seismicity of the lonian Islands CompleteCitation between 1658 and 1664 In J Fr chet M Meghraoui M Stucchi eds Historical Seismology 43 91 ExternalPageURL http www springerli
121. rvice 2002 ECOS Earthquake Catalog of Switzerland ECOS Report to PEGASOS Version 31 3 2002 Appendix A ECOS Database SED Zurich http histserver ethz ch 92 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 9 Licence used products and credits 9 1 Licences MIDOP is released under two open source licenses models which will hopefully help the tool in many ways free circulation within the researchers easier adoption by public institutions open development and improvements debugging effort shared among involved subjects Creative Commons Licence coereative commons Attribution Noncommercial Share Alike 3 0 Unported You are free to Share to copy distribute and transmit the work to Remix to adapt the work OS Under the following conditions Attribution You must attribute the work in the manner specified by the author or licensor but not in any way that suggests that they endorse you or your use of the work Noncommercial You may not use this work for commercial purposes Share Alike If you alter transform or build upon this work you may distribute the resulting work only under the same or similar license to this one O S O With the understanding that Waiver Any of the above conditions can be waived if you get permission from the copyright holder Other Rights In no way are any of the following rights affected by the license e
122. s F Felt D Damage HD Heavy damage destruction extensive damage or total collapse 23 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual G3 Light damage to an isolated building requires IB in place special case field G4 Moderate damage to an isolated building requires IB in place special case G5 Heavy damage to an isolated building requires IB in place special case Table 2b Macroseismic intensity codes Place special case codes reference table extracted from NERIES NA4 Deliverable 7 part 1 tab 2C Special case Epicentral parameters assessment notes E coordinates and intensity must not area containing several ipo o EA with be assessed F D or HD and localities the size of the SR arbitrary coordinates only for the definition of i area exceeds the one i graphical representation should intensity and any suggested by the oca on woud be be assessed These MDPs must EMS98 not be used for earthquake arbitrary parameters determination Code Description Problem large area territory unknown a place which both the not author of the study and coordinates cannot be located the MDP compiler is not assigned locality able to locate today settlement the size of eni coordinates are assessed F D or which is too small to y g HD are assessed er is not compatible with i supply a significant Nara As a first choice these MDPs Fe the statistical building samp
123. s Xavier Goula Jordi Pujol Cay n and Jorge Fleta from the Institut Geol gic de Catalunya Barcelona Josep Batll and Ricardo Deus from the Instituto de Meteorologia Lisbon Jos Manuel Mart nez Solares Ant n Resurrecci n and Jos Francisco Valero Zornoza from the Instituto Geogr fico Nacional Madrid Roger Musson from the British Geological Survey Edinburgh This product has been funded by the EC project NERIES http www neries eu org 95
124. s with 14000 mentioned places without a DEM requires more or less 2 hours on a computer based on a 2 GHz CPU The following settings boxes are available 1 Publish the query by earthquake part 2 Publish the seismic history part 71 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Time span filter Earthquake list fonly selected earthquakes will be created gt Publish the query by earthquake part apply tha filter fram year to year l select all select none 1373 03 03 02 Ribagorga Olivera et al 2006 1376 02 21 06 Probablement Pirineus Olivera et al 2006 1427 06 14 08 Caldes de Malavella Olivera et al 2006 1427 06 12 Caldes de Malavella Olivera et al 2006 1427 05 15 15 Vall d en Bas Olot Olivera et al 2006 1427 04 23 11 Lloret Salvatge Olivera et al 2006 1427 04 22 22 Lloret Salvatge Olivera et al 2006 1427 04 13 Osor 4mer Olivera et al 2006 1427 03 19 21 Osor 4mer Olivera et al 2006 1427 03 15 23 Amer Olivera et al 2006 1427 03 14 12 Amer Olivera et al 2006 1427 03 13 11 Amer Olivera et al 2006 1428 02 02 08 Campradan Olivera et al 2006 1448 05 25 01 Near Granollers Olivera et al 2006 1450 09 16 10 Pirineus Olivera et al 2006 Start generating the whole website Generate the whole website or generate only a specific query by earthquake area generate the gene
125. sites managed by MIDOP Renaming layers or deleting them will affect all the websites stored in MIDOP Important note about DEM usage If you enable the DEM image inclusion within the generated maps MIDOP uses PHP functionalities for image manipulation GD image libraries usually built in in the PHP distribution These procedures require a lot of computational power both in terms of used RAM memory and CPU cycles Generation is not in real time and several seconds will be required once the map is generated it will be cached and the next time it will ready instantaneously To flush pre generated maps stored within the MIDOP cache simply click the flush cache button Cached map files are stored within the folder data svg maps Please remember that the higher the quality of the DEM is the heavier and slower the map will be in the client browser 68 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Record unique identifier Place name Place name distant zoom Latitude Longitude Zoom level detail medium large Covered area Page Query by place b Reference places on map a a a a i a i record unique identifier id place name Flace_name d place name distant zoom Place_name_ short T latitude Lat longitude Lon kd zoom level detail medium large zoom_lewel covered area area Record unique identifier not repeated in the table Set
126. st installation Once both the required AMP environment and the supporting macroseismic data tables are ready MIDOP can be installed Follow these simple steps e copy the MIDOP folder to htdocs where the Apache web server stores its websites e Switch ON both the Apache and the MySql servers if needed 5 2 Available settings MIDOP lets you customize many aspects of the final website through a simplified control panel You can access it by opening a web browser and surf to http localhost MIDOP settings Settings are organized in pages grouping logically every aspect Title of you website SWITCH TO ANOTHER SITE MIDOP Manual settings vars_site_name EQ list MDP map MDP list Query by place Publish query by earthquake query by place FLUSH CACHED FILES SAVE SETTINGS Note that whenever a settings page is modified it must be saved by pressing save settings in the upper right in order to apply changes If you don t save your settings before changing page your customizations will be lost You can open the customized website by clicking query by earthquake in the upper left The content of these web pages is generated in real time only maps are generated once then they are cached in order to reflect new settings applied on maps cached files must be flushed by clicking flush cached files When you have done with your customization and are happy with the results you can proceed to publishing tt I
127. t F e v P DOS _provinces_spain_utm3D layer always present e Fl a 06 regions spain utm3 layer sf always present F e v Pa OF countries utm3B lavaer always present O upload a new layer LL SWG code from catalogue field h LI layer level after a Digital elevation model DEM Al enabled E eae 30_hillshaded LI resolution high i layer level after 1 l cover only the earthquake area O Layer 07 countries _uim30 layer style i layer opacity 100 y i stroke Iv i fill Iv i stroke width pon Li fill calor FF0000 i stroke color to368cC i fil opacity 4596 Medium zoom scale value Detailed zoom scale value Available layers for covered area on off rename available layer files style display i stroke opacity 100 i stroke miterlimit none EP MICE i stroke dasharray none i t AN e i i stroke dashoffset none 2 4 q 2i 7 A round AS round 3 11 stroke line cap i stroke line join Set the meaning of medium zoom in terms of zoom degree Set the meaning of detailed zoom in terms of zoom degree Manage which layers must be included with the generated maps Built in layers covers the following UTM zones 28 atlantic_islands 30 area iberia or uk 31 area france 32 area italy 33 area eastern_europe or fennoscandia 34 area aegean For further information on layers managements s
128. t all settings of a website managed by MIDOP functions for flushing all the cached files contains functions for storing the control panel variables into settings file control panel common Javascript functions functions for deleting the geographical layer file functions for editing the geographical layer file source code functions for renaming the geographical layer file popup window for styling geographical layers generates the list of available geographical layer files functions for uploading a geographical layer file style used when publishing a website Javascript functions called while publishing a website control panel MDP list page control panel MDP map page control panel Structure page immagine contagocce usata per l apertura della poup scelta colore control panel Query by place page Javascript functions called while publishing a website control panel Publish page generates published files containing the earthquake list generates published files containing seismic histories functions for loading updating and saving control panel settings control panel SVG source code editor popup window color selector tool common functions and classes for the control panel functions for loading and saving the list of managed websites settings functions for retrieving the current earthquake group UTM zone folder for common query function to the database query for generating the earthquake list or catalogue query for gener
129. t folder that will contains all is needed for publishing the website The minimum computer hardware configuration is a 2GHz CPU and a RAM of 2Gbyte as the software performs many heavy operations 3 1 Requested software configuration MIDOP is a web application based on AMP Apache MySql PHP environment which is required to make it work The adopted solution is theoretically independent from the operating system in use The AMP environment is widely used by web developers and it usually requires each part of it web server mark up language interpreter and a database management system to be installed separately As the installation procedure of the entire environment is both complicated and time consuming for novice users we encourage the use of pre packaged AMP solutions which are coming with a out of the box complete AMP environment MIDOP has been successfully tested on e Windows 2000 XP and Vista using XAMPP Lite and WAMP packages e Mac OSX 10 4 and 10 5 using the MAMP package e Linux using manually installed Apache PHP and MySql Note that by installing an AMP environment you will have a web server working on your computer so you ll probably have to contact the technical support of your department and check if this complies the software security installation policy Installation procedure of XAMPP Lite and WAMP e download the freely available package of your choice XAMPP Lite Self extracting version http
130. t get install phpmyadmin select apache2 when asked Some web server customization must be manually done in order to use MIDOP edit the Apache configuration file etc php5 apache2 apache2 conf and add the following lines at the end of the file 16 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual AddType image svg xml svg AddType image svgtxml svgz AddEncodring X gzip Svoz lt FilesMatch svgz gt SLrModule idmod gzips c mod gzip r No lt IfModule gt lt FilesMatch gt AddType application vnd google earth kml xml kml AddType application vnd google earth kmz kmz e edit the PHP configuration file etc php5 apache2 php ini and change these values precision 18 max execution Lime 20 memory limit 950M post max size 64M upload max filesize 64M error reporting B Ale NOTICE display errors gn short open tag On auto detect line endings On Magie quotes ape 0n nbstrings internal encoding e UTE 8 e restart the Apache web server by entering the command sudo etc init d apache2 restart The Apache and its PHP module and the MySql servers are now installed Also the MySql frontend called phpmyadmin is ready to be used Now check your installation e create a PHP test file using a text editor If you are using a Gnome environment enter sudo gedit var www info php if you are using a KDE environment enter sudo kate Ivarlwww info
131. tage the lower will be the different scale factor between each click If selected the pan tool will be available to the user with the icon Eg map frame toolbox and users will be able to pan the map in the Define the displacement steps to be used with the pan tool If selected a graphical scale will be available to the user in the lower part of the map The units of measurements are expressed in kilometers If selected a timeline slider appears to the user that let show on the map only those earthquakes within a custom time window If selected a latitude and longitude geographical grid will be rendered on the map Line width of the rendered geographical grid from 1 small to 10 large Font size of the geographical grid labels from 1 small to 10 large The following settings box will let you customize the default look of the earthquakes map how MIDOP will calculate the map center and how big the zoom will be Map center calculation method epicentre coordinate median gt Default view Lil map center calculation method epicentre coordinate median center coordinates fixed latitude 42 longitude 12 2 view extension calculation method fixed distance 1300 km J based on the epicentre distribution minumum distance km maximum distance km Set how the default center of the map will be calculated by using the coordinate median of all the plotted epicentres 59 NA4 D7 Part 2 Improved ma
132. tes from field Define the map center to coordinates taken from the earthquake o Field latitude catalogue table o Field longitude View extension e fixed distance e fixed distance from field e based on the MDP Define how the default view extension of the map will be calculated Define the view extent to a fixed value valid for every earthquake map Define the view extent from a value taken from the earthquake catalogue table field Each earthquake can have a different value Define the view extent automatically The extent will be calculated distribution taking into account all the intensity points of the earthquake Limit the minimum value in kilometers of the automatic extent o minimum distance calculation It useful in case the earthquake has a very small amount of points or they are very close to each other Limit the maximum value in kilometers of the automatic extent o maximum distance calculation It is useful in those earthquakes that cover very large geographical areas 66 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual P Map layers 2 medium zoom scale value 110 Li detailed zoom scale value 160 S available layers for iberia UTM 30 M on off rename available layer files style display code delete v Fd 01_coasts_utm30 layer 4 always present e v P D3 sea iberia utm30 layer 4 always present jg e v Fa O4 rivers_utm30 layer 4 always presen
133. th your locally stored tables 2 aBase file connected to MySql server created above As OpenOffice Base cannot manage local and linked tables within the same Base file you must follow this procedure in order to copy a table to MySql e open both the OpenOffice Base file containing your local stored tables and the above created Base file connected to MySql then copy and paste as a Data source table the table between the two Base files ma ym baseLOCAL odb OpenOffice org Base ABBA baseODBC odb OpenOffice org Base 2 80 E 4 Er oOo BEBE B E 0 pm E Create Table in Design Vi Description EE E Create Table in Design Vi Description E E Use Wizard to Create Tab ed E Use Wizard to Create Tab Tables Create View Tables amp Create View E NES Queries Queries e e None gt E eS Forms Forms paste ES Reports Reports Embedded database midop on localhost root oou Paste Special Source Unknown source C ok gt Cancel Selection Help Formatted text RTF HTML HyperText Markup Language Y ETTI Data source table 40 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual e once you paste a table into the destination OpenOffice Base file a requester appear asking to define what to copy select Definition and data BOD Copy table Options Definition and data O on Append data
134. thing is working MAMP MAMP PRO powered by appsolute GmbH 9 localhost Databases SQL Status Variables i Charsets EjEngines Privileges Processes Export Eslmport Actions MySQL MySQL localhost EJ Server Localhost via UNIX socket E Ed Server version 5 1 37 midop egener ci 18 Create print gt User root localhost MySQL connection collation MySQL charset UTF 8 Unicode utf8 Interface Web server Language English HH gt Apache 2 0 63 Unix PHP 5 2 11 DAV 2 MySQL client version 5 1 37 amp Theme Style gt PHP extension mysql gt Custom color A Reset phpMyAdmin Font size 82 Version information 3 2 0 1 3 Let s create your first MySql database for example enter midop do NOT use upper case spaces nor special characters in the Create a new database field and specify utf8 general ci as a collation from the drop down menu then click create A feedback message will show up telling you if the requested operation successfully succeeded eoo MAMP OD O O O By screenshot osx key Q e CE eee TA TETTI Start phpin MILLS QLiteManager FAQ Try MAMP PRO MAMP amp MAMP PRO powered by appsolute GmbH phpMyAdmin 3 localhost gt midop S d 23 DO Ye _ Drop E PS Database midop has been created AAA eee Database Edit Create PHP Code midop 0 No tables found in database No tables found in database
135. thquake catalogue contains multiple macroseismic studies each with a different set of bibliographical references users might want to adopt a series of reference identifiers coherent within the same macroseismic study MIDOP supports such feature and users must specify the macroseismic study code for which the references must be used the link between the catalogue table and the references table will be created using both the macroseismic study code and the reference code 4 4 Uploading data into MySql Macroseismic data tables must be loaded into MySql in order to let MIDOP using them This load process is crucial if something goes wrong your data could be affected by some conversion error so be careful while doing it In order to avoid potential problems please follow these simple rules e within the same table do not duplicate field names e intable names and field names avoid spaces special characters and use always or lower or uppercase characters e foreach field specify the data format integer or floating numbers characters long text If you are new to MySql consider a database as a folder which may contains various data tables 28 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Each table might contain hundreds of fields each with a unique name and a specific type With type MySql specifies the nature of the field content Below a list of data types available in MySql Type
136. to connect to the indicated data provider A User data source is only visible to you and can only be used on the current machine The data transfer speed might depends on the table size and the type of connection to MySql local on the same computer or a remote connection That s it your table is now stored in MySql and will be available to MIDOP 35 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual MacOS x 1 Download and install the MySql driver connector from http dev mysql com downloads connector odbc 5 1 html macosx dmg Introd E w Install MySQL Connector ODBC 5 1 Welcome to the MySQL Connector ODBC 5 1 Installer UN MySQL Connector OD BC 5 1 5 MySQL This is the installer for MySQL Connector ODBC which allows applications to work with MySQL servers by using the cross platform database agnostic ODBC interface Please visit htto www mysal com for more information Continue 2 Once the installation process has finished open the ODBC control panel available in Applications Utilities ODBC Administrator x Applications LA Developer im Library 33 System im Users Utilities lo Address Book EB Activity Monitor Adobe El Adobe AIR n Installer Adobe Reader 9 EM Adobe AIR Urinstaller E AppleScript C Adobe Utilities iw Automator AirPort Uriliry Calculator A Audio MIDI Setup 4 Chess e Bluetooth File Exchange Dashboard Boot C
137. to contact the web services administrator and ask if the current configuration does support those headers If so you will only need to copy the published folder to the server otherwise few lines must be added to the server configuration as follow for the Apache web server the configuration file is called httod conf AddType image svg xml svg AddType image svg xml svgz AddEncoding gzip SVOZ lt FilesMatch svgz gt lt LtModule mod 9 21P gt mod gzip on No IfModule lt FilesMatch gt AddType application vnd google earth kml xm1 kml AddType application vnd google earth kmz kmz 84 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual If the correct header corresponding to the served file is not sent the final browser will likely not be able to show your maps and will complain that an unknown file format is encountered leaving the user puzzled 6 2 Publishing a new site Once you are happy with your finely tuned website you can proceed and publish it Click on the control panel publish page and two areas one for each consultation methods will appear gt Publish the query by earthquake part Time span filter from year to year apply the filter select all select none W 1373 03 03 02 Ribagor a Olivera et al 2006 W 1376 02 21 06 Probablement Pirineus Olivera et al 2006 1427 06 14 08 Caldes de Malavella Olivera et al 2006 4 1427 06 12 Ca
138. tor ODBC Configuration DE iei This dialog is used to add a Socket Applications MAMP tmp mysql mysql sock Data Source Name DSN Initial Statement Character Set utf8 SSL Key SSL Certificate SSL Certificate Authority SSL CA Path SSL Cipher Verify SSL Certificate Diagnostics gt gt Cancel Help ODBC Administrator User DSN System DSN Drivers Tracing Connecton Pooling About Description Driver Add MySQL ODBC 5 1 Driver Remove Configure An ODBC User data source stores information about how to connect to the indicated data provider A User data source is visible only to you 1 id CI ck the lock to prevent further changes NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual Create an OpenOffice Base file that is connected to MySql follow this procedure open OpenOffice Base and select to connect to an existing database via ODBC Moro Database Wizard Steps Welcome to the OpenOffice org Database Wizard 1 Select database Use the Database Wizard to create a new database open an existing database file or connect to a database stored on a server 2 Set up ODBC connection What do you want to do O Create a new database O Open an existing database file selected the previously stored ODBC connection midop on localhost 000 Database Wizard Steps Set up a connection to an ODBC database 1 Select database Enter t
139. ttp emidius mi ingv it DBMI08 223334 F 445 5 5 6 6 6 7 7 7 8 8 8 9 9 9 10 10 10 11 11 0 0008000008000 00 NF 1 i Hexadecimal codes RGB values RGB values Intensity value Fill Stroke AU Stroke Green Blue Green NF ZFFFFFF 255 255 255 2 ZFFFFFF 255 255 255 2 3 ZFFFFFF 255 255 255 3 ZFFFFFF 255 255 255 3 4 ZFFFFFF Z 9FFFF 255 255 255 121 255 255 F 95FFFF 149 255 255 4 Z9 5FFFF 149 255 255 4 5 95FFFF 69EB70 149 255 255 105 235 112 5 69EB70 105 235 112 5 6 HO9EB7O HFFFFOO 105 235 112 255 255 0 6 HFFFFOO 255 255 6 7 HFFFFOO FF9F40 255 255 255 159 64 7 FF9F40 255 159 64 7 8 FF9F40 FF0000 255 159 64 255 0 0 19 FF0000 FF0000 AC4DF4 AC4DF4 0303CD 0303CD 000000 AC4DF4 0303CD 000000 255 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual 205 NERIES NAA intensities set This symbol set is the official NERIES NA4 which was intended for covering as much as possible the intensity ranges of the entire Europe http emidius mi ingv it neries NAA NF 1 Intensity value Hexadecimal codes Fill HFFFFFF 9C9CFF 9C9CFF 6FFFFF 6FFFFF 3ABB4B 3ABB4B AOFF00 99F400 HFBF400 FBF400 FF9F40 FF9F40 FF0000 FF1515 941100 AA1500 5E0095 5E0095 000000 Stroke 95FFFF 3ABB4B 3ABB4B HAOFFOO FBF400 FF9F40 FF0000 9F1400 5E0095 000000
140. url http emidius mi ingv itineries NAd EMD i navigation bar 2 Li query by earthquake Ei Li query by place v Set the absolute URL where the final site will be published This information will be only used if the export to Google Earth is enabled enable disable the navigation bar in the upper part of the window it will contains e alink to the homepage e alink to each earthquake group created e alink to the places seismic history enable or disable the query by earthquake part if the website enable or disable the query by place Note that in order to enable these seismic histories places must have a unique identifier in table 1a b HTML frame structure Navigation bar frame height Left frame width Upper left frame EQ list header height Middle left frame height iJ navigation bar frame height 16 px o 1J left frame width 505 px v 2 upper left frame height 33 a o 2 EG list header height 50 px 4 middle left frame height 160 px Set the navigation bar frame height The number can be expressed as a percentage value where 100 is the window height or in number of pixels Set the horizontal width of the left part of the frameset the one containing the earthquake list upper left detailed earthquake information middle left and macroseismic observations lower left The number can be expressed as a percentage where 100 is the entire window width or in number of pixels Set the he
141. visable for the final publication as too many issues would arise among others security is surely one of the most sensitive subjects that will potentially affect the final product In order to keep satisfying performance quality and security MIDOP has a dedicated process called publication By using it the final output website will be a folder that can be simply copied in the final web server no installation will be required Experts that are taking care of the web services will surely appreciate the simple procedure The whole website is a passive folder no active pages will be dynamically generated by the server and no databases are queried By adopting this solution hacker attacks through the website are simply not possible Once published the MIDOP technology is based on the combination of SVG Scalable Vector Graphics and JavaScript and this guarantee a good level of user interactivity without the need of a powerful web server Once the map will reach the final user through the web every action such as zoom and pan will be executed directly by the final user browser This point will make happy the people that are taking care of the web services as any web server will be powerful enough to serve your final website there will be no need to buy and configure expensive hardware or software The only special configuration requested on the final web server is the ability to serve both SVG and KML headers correctly You will have
142. y i fill Iv erronon uw uw tr un uo iun aen q uw Medium zoom scale value Set the meaning of medium zoom in terms of zoom degree Detailed zoom scale value Set the meaning of detailed zoom in terms of zoom degree Manage which layers must be included with the generated maps Built in layers covers the following UTM zones 28 atlantic islands 30 Available layers for iberia or uk 31 france 32 italy 33 eastern_europe or fennoscandia covered area 34 aegean For further information on layers managements see chapter Advanced customization on off turn on or off the layer when creating an earthquake map rename Rename the layer file name the extension layer must be kept Layer file name files stored in data layers eq UTM covered area The level at which the layer will be inserted when creating the map is established by alphabetical sorting the list that s why buil in layers starts with a progressive number available layer files style Change the layer s appearance style Set when the layer will be shown always present shown at medium and detailed zoom only on detailed zoom code Edit the layer source code display delete Delete the layer file a requester will prevent accidental deletion vdapicad a never Load an additional layer file to MIDOP Layer files are basically i y uncompressed plain text containing SVG objects 61 NA4 D7 Part 2
143. ySQL connection collation utff_general_ci MySQL charset U midap utfa general ci Interface Web server d Language English k Apache 2 2 11 VI k MySQL client versig Theme Style Original 13227 gt Custom color Reset k PHP extension my k Font size 82 phpMyAdmin For every action requested by the user phpMyAdmin give a feedback message telling if the operation was successful or not Below a screenshot showing a correctly created database phpMyAdmin 8 Server localhost ts Database midop g Structure SOL Search Query Export FEslmport Operations Privileges Drop S Database midop has been created Database CREATE DATABASE midop DEFAULT CHARACTER SET uti COLLATE wets general ci midop Edit Create PHP Code midop 0 Mo tables found in database No tables found in 3 Create new table on database midop database Mame Number of fields 30 NA4 D7 Part 2 Improved macroseismic web mapping tool MIDOP manual MacOS x 1 In the MAMP window click on Open start page a new browser window will appear and the MAMP web control panel interface will appear and shows up click on phpMyAdmin Sy http localhost MAMP Br screenshot osx key Q lar era e sal REA phpinfo phpMyAdmin SQLiteManager FAQ Try MAMP PRO MAMP amp MAMP PRO powered by appsolute GmbH Welcome to MAMP t Q If you can see this page MAMP is installed i M on your Mac and every

Appendix - INGV - Istituto Nazionale di Geofisica e Vulcanologia

Contents

Download Pdf Manuals

Related Search

Related Contents