]> git.openstreetmap.org Git - nominatim.git/blob - website/details.php
option to get list of search keywords
[nominatim.git] / website / details.php
1 <?php
2         require_once(dirname(dirname(__FILE__)).'/lib/init-website.php');
3         require_once(CONST_BasePath.'/lib/log.php');
4
5         $sOutputFormat = 'html';
6 /*
7         $fLoadAvg = getLoadAverage();
8         if ($fLoadAvg > 3)
9         {
10                 echo "Page temporarily blocked due to high server load\n";
11                 exit;
12         }
13 */
14         ini_set('memory_limit', '200M');
15
16         $oDB =& getDB();
17
18         if (isset($_GET['osmtype']) && isset($_GET['osmid']) && (int)$_GET['osmid'] && ($_GET['osmtype'] == 'N' || $_GET['osmtype'] == 'W' || $_GET['osmtype'] == 'R'))
19         {
20                 $_GET['place_id'] = $oDB->getOne("select place_id from placex where osm_type = '".$_GET['osmtype']."' and osm_id = ".(int)$_GET['osmid']." order by type = 'postcode' asc");
21         }
22
23         if (!isset($_GET['place_id']))
24         {
25                 echo "Please select a place id";
26                 exit;
27         }
28
29         $iPlaceID = (int)$_GET['place_id'];
30
31         $iParentPlaceID = $oDB->getOne('select parent_place_id from location_property_tiger where place_id = '.$iPlaceID);
32         if ($iParentPlaceID) $iPlaceID = $iParentPlaceID;
33         $iParentPlaceID = $oDB->getOne('select parent_place_id from location_property_aux where place_id = '.$iPlaceID);
34         if ($iParentPlaceID) $iPlaceID = $iParentPlaceID;
35
36         $aLangPrefOrder = getPrefferedLangauges();
37         $sLanguagePrefArraySQL = "ARRAY[".join(',',array_map("getDBQuoted",$aLangPrefOrder))."]";
38
39         $hLog = logStart($oDB, 'details', $_SERVER['QUERY_STRING'], $aLangPrefOrder);
40
41         // Make sure the point we are reporting on is fully indexed
42         //$sSQL = "UPDATE placex set indexed = true where indexed = false and place_id = $iPlaceID";
43         //$oDB->query($sSQL);
44
45         // Get the details for this point
46         $sSQL = "select place_id, osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, importance,";
47         $sSQL .= " parent_place_id, rank_address, rank_search, get_searchrank_label(rank_search) as rank_search_label, get_name_by_language(name,$sLanguagePrefArraySQL) as localname, ";
48         $sSQL .= " ST_GeometryType(geometry) in ('ST_Polygon','ST_MultiPolygon') as isarea,ST_GeometryType(geometry) as geotype, ST_Y(ST_Centroid(geometry)) as lat,ST_X(ST_Centroid(geometry)) as lon ";
49         $sSQL .= " from placex where place_id = $iPlaceID";
50         $aPointDetails = $oDB->getRow($sSQL);
51         IF (PEAR::IsError($aPointDetails))
52         {
53                 var_dump($aPointDetails);
54                 exit;
55         }
56         $aPointDetails['localname'] = $aPointDetails['localname']?$aPointDetails['localname']:$aPointDetails['housenumber'];
57         $fLon = $aPointDetails['lon'];
58         $fLat = $aPointDetails['lat'];
59         $iZoom = 14;
60
61         $aClassType = getClassTypesWithImportance();
62         $aPointDetails['icon'] = $aClassType[$aPointDetails['class'].':'.$aPointDetails['type']]['icon'];
63
64         // Get all alternative names (languages, etc)
65         $sSQL = "select (each(name)).key,(each(name)).value from placex where place_id = $iPlaceID order by (each(name)).key";
66         $aPointDetails['aNames'] = $oDB->getAssoc($sSQL);
67
68         // Extra tags
69         $sSQL = "select (each(extratags)).key,(each(extratags)).value from placex where place_id = $iPlaceID order by (each(extratags)).key";
70         $aPointDetails['aExtraTags'] = $oDB->getAssoc($sSQL);
71
72         // Get the bounding box and outline polygon
73         $sSQL = "select ST_AsText(geometry) as outlinestring,";
74         $sSQL .= "ST_Y(ST_PointN(ExteriorRing(ST_Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ExteriorRing(ST_Box2D(geometry)),2)) as maxlat,";
75         $sSQL .= "ST_X(ST_PointN(ExteriorRing(ST_Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ExteriorRing(ST_Box2D(geometry)),3)) as maxlon";
76         $sSQL .= " from placex where place_id = $iPlaceID";
77         $aPointPolygon = $oDB->getRow($sSQL);
78         IF (PEAR::IsError($aPointPolygon))
79         {
80                 var_dump($aPointPolygon);
81                 exit;
82         }
83         if (preg_match('#POLYGON\\(\\(([- 0-9.,]+)#',$aPointPolygon['outlinestring'],$aMatch))
84         {
85                 preg_match_all('/(-?[0-9.]+) (-?[0-9.]+)/',$aMatch[1],$aPolyPoints,PREG_SET_ORDER);
86         }
87         elseif (preg_match('#MULTIPOLYGON\\(\\(\\(([- 0-9.,]+)#',$aPointPolygon['outlinestring'],$aMatch))
88         {
89                 // TODO: this just takes the first ring
90                 preg_match_all('/(-?[0-9.]+) (-?[0-9.]+)/',$aMatch[1],$aPolyPoints,PREG_SET_ORDER);
91         }
92         elseif (preg_match('#POINT\\((-?[0-9.]+) (-?[0-9.]+)\\)#',$aPointPolygon['outlinestring'],$aMatch))
93         {
94                 $fRadius = 0.01;
95                 if ($aPointDetails['rank_search'] > 20) $fRadius = 0.0001;
96                 $iSteps = min(max(($fRadius * 40000)^2,16),100);
97                 $fStepSize = (2*pi())/$iSteps;
98                 $aPolyPoints = array();
99                 for($f = 0; $f < 2*pi(); $f += $fStepSize)
100                 {
101
102                         $aPolyPoints[] = array('',$aMatch[1]+($fRadius*sin($f)),$aMatch[2]+($fRadius*cos($f)));
103                 }
104                 $aPointPolygon['minlat'] = $aPointPolygon['minlat'] - $fRadius;
105                 $aPointPolygon['maxlat'] = $aPointPolygon['maxlat'] + $fRadius;
106                 $aPointPolygon['minlon'] = $aPointPolygon['minlon'] - $fRadius;
107                 $aPointPolygon['maxlon'] = $aPointPolygon['maxlon'] + $fRadius;
108         }
109
110         // Address
111         $aAddressLines = getAddressDetails($oDB, $sLanguagePrefArraySQL, $iPlaceID, $aPointDetails['country_code'], true);
112
113         // All places this is an imediate parent of
114         $sSQL = "select placex.place_id, osm_type, osm_id, class, type, housenumber, admin_level, rank_address, ST_GeometryType(geometry) in ('ST_Polygon','ST_MultiPolygon') as isarea, st_distance(geometry, placegeometry) as distance, ";
115         $sSQL .= " get_name_by_language(name,$sLanguagePrefArraySQL) as localname, length(name::text) as namelength ";
116         $sSQL .= " from placex, (select geometry as placegeometry from placex where place_id = $iPlaceID) as x";
117         $sSQL .= " where parent_place_id = $iPlaceID";
118 //      $sSQL .= " and type != 'postcode'";
119         $sSQL .= " order by rank_address asc,rank_search asc,get_name_by_language(name,$sLanguagePrefArraySQL),housenumber";
120         $aParentOfLines = $oDB->getAll($sSQL);
121
122         $aPlaceSearchNameKeywords = false;
123         $aPlaceSearchAddressKeywords = false;
124         if (isset($_GET['keywords']) && $_GET['keywords'])
125         {
126                 $sSQL = "select * from search_name where place_id = $iPlaceID";
127                 $aPlaceSearchName = $oDB->getRow($sSQL);
128                 $sSQL = "select * from word where word_id in (".substr($aPlaceSearchName['name_vector'],1,-1).")";
129                 $aPlaceSearchNameKeywords = $oDB->getAll($sSQL);
130                 $sSQL = "select * from word where word_id in (".substr($aPlaceSearchName['nameaddress_vector'],1,-1).")";
131                 $aPlaceSearchAddressKeywords = $oDB->getAll($sSQL);
132         }
133
134         logEnd($oDB, $hLog, 1);
135
136         include(CONST_BasePath.'/lib/template/details-'.$sOutputFormat.'.php');