Contribuir para o Nominatim - Revision history

Jgrocha: /* Undo */

2018-03-08T00:10:06Z

Undo

2018-03-07T23:51:07Z

Undo

2018-03-07T23:29:29Z

Teste do build

2018-03-07T23:15:16Z

Dependências

2018-03-07T23:02:43Z

Dependências

2018-03-07T23:01:52Z

Teste do build

2018-03-07T00:34:26Z

Teste do build

2018-03-07T00:30:56Z

Teste do build

2018-03-07T00:13:09Z

Teste do build

2018-03-07T00:03:25Z

Teste do build

← Older revision		Revision as of 00:10, 8 March 2018
Line 168:		Line 168:
	</syntaxhighlight>		</syntaxhighlight>

		+
		+	==== Queries à base de Dados nominatim ====
		+
		+	<syntaxhighlight lang="sql">
		+	SELECT l.* FROM public.planet_osm_rels l, unnest(tags) a WHERE lower(a) LIKE '%prefix%';
		+	SELECT l.* FROM public.planet_osm_ways l, unnest(tags) a WHERE lower(a) LIKE '%prefix%';
		+	select * from public.place limit 20;
		+	</syntaxhighlight>

	==== IDE CLion ====		==== IDE CLion ====

@@ Line 167: / Line 167: @@
 postgres=# \q
 </syntaxhighlight>
 ==== Contribuições ====

@@ Line 129: / Line 129: @@
 <syntaxhighlight lang="apache2">
          Alias /nominatim /home/jgr/dev/Nominatim/build/website
-         <Directory /home/jgr/WebstormProjects>
+         <Directory /home/jgr/dev/Nominatim/build/website>
-                 Options +Indexes
+                 Options +Indexes +FollowSymLinks
                  Require all granted
          </Directory>
@@ Line 139: / Line 139: @@
 </syntaxhighlight>
-Abrir: http://localhost/nominatim
+<syntaxhighlight lang="bash">
 ==== Undo ====

@@ Line 92: / Line 92: @@
 <syntaxhighlight lang="bash">
-sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql php-pear php-pgsql
+sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql php-pear php-pgsql php-intl
 sudo pear install DB
 </syntaxhighlight>

@@ Line 92: / Line 92: @@
 <syntaxhighlight lang="bash">
-sudo apt-get install php-pear php-pgsql
+sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql php-pear php-pgsql
 sudo pear install DB
 </syntaxhighlight>

@@ Line 112: / Line 112: @@
 </syntaxhighlight>
-Atenção: a importação é bastante demorada...
+Atenção: a importação é bastante demorada (aprox. 25 minutos para importar Portugal)
 <syntaxhighlight lang="bash">

@@ Line 100: / Line 100: @@
 <syntaxhighlight lang="bash">
 sudo su postgres
-createuser --createdb --pwprompt -s jgr
+createuser --createdb --pwprompt --superuser jgr
 Enter password for new role: nominatim
 Enter it again: nominatim
 exit
 </syntaxhighlight>
@@ Line 112: / Line 114: @@
 <syntaxhighlight lang="bash">
 cd ..
-./build/utils/setup.php --osm-file portugal-latest.osm.pbf --all
+wget -O data/portugal-latest.osm.pbf http://download.geofabrik.de/europe/portugal-latest.osm.pbf
-</syntaxhighlight>
+wget -O data/country_osm_grid.sql.gz https://www.nominatim.org/data/country_grid.sql.gz
+./build/utils/setup.php --osm-file data/portugal-latest.osm.pbf --all
 </syntaxhighlight>