]> git.openstreetmap.org Git - nominatim.git/blob - website/hierarchy.php
introduce chksql function for website code and move other fail functions
[nominatim.git] / website / hierarchy.php
1 <?php
2         @define('CONST_ConnectionBucket_PageType', 'Details');
3
4         require_once(dirname(dirname(__FILE__)).'/settings/settings.php');
5         require_once(CONST_BasePath.'/lib/init-website.php');
6         require_once(CONST_BasePath.'/lib/log.php');
7         require_once(CONST_BasePath.'/lib/PlaceLookup.php');
8         require_once(CONST_BasePath.'/lib/output.php');
9         ini_set('memory_limit', '200M');
10
11         $oDB =& getDB();
12
13         $sOutputFormat = getParamSet('format', array('html', 'json'), 'html');
14
15         $aLangPrefOrder = getPreferredLanguages();
16         $sLanguagePrefArraySQL = "ARRAY[".join(',',array_map("getDBQuoted",$aLangPrefOrder))."]";
17
18         $sPlaceId = getParamString('place_id');
19         $sOsmType = getParamSet('osmtype', array('N', 'W', 'R'));
20         $iOsmId = getParamInt('osmid', -1);
21         if ($sOsmType && $iOsmId > 0)
22         {
23                 $sPlaceId = chksql($oDB->getOne("select place_id from placex where osm_type = '".$sOsmType."' and osm_id = ".$iOsmId." order by type = 'postcode' asc"));
24
25                 // Be nice about our error messages for broken geometry
26                 if (!$sPlaceId)
27                 {
28                         $aPointDetails = chksql($oDB->getRow("select osm_type, osm_id, errormessage, class, type, get_name_by_language(name,$sLanguagePrefArraySQL) as localname, ST_AsText(prevgeometry) as prevgeom, ST_AsText(newgeometry) as newgeom from import_polygon_error where osm_type = '".$sOsmType."' and osm_id = ".$iOsmId." order by updated desc limit 1"));
29                         if ($aPointDetails) {
30                                 if (preg_match('/\[(-?\d+\.\d+) (-?\d+\.\d+)\]/', $aPointDetails['errormessage'], $aMatches))
31                                 {
32                                         $aPointDetails['error_x'] = $aMatches[1];
33                                         $aPointDetails['error_y'] = $aMatches[2];
34                                 }
35                                 include(CONST_BasePath.'/lib/template/details-error-'.$sOutputFormat.'.php');
36                                 exit;
37                         }
38                 }
39         }
40
41         if (!$sPlaceId) userError("Please select a place id");
42
43         $iPlaceID = (int)$sPlaceId;
44
45         if (CONST_Use_US_Tiger_Data)
46         {
47                 $iParentPlaceID = chksql($oDB->getOne('select parent_place_id from location_property_tiger where place_id = '.$iPlaceID));
48                 if ($iParentPlaceID) $iPlaceID = $iParentPlaceID;
49         }
50
51         if (CONST_Use_Aux_Location_data)
52         {
53                 $iParentPlaceID = chksql($oDB->getOne('select parent_place_id from location_property_aux where place_id = '.$iPlaceID));
54                 if ($iParentPlaceID) $iPlaceID = $iParentPlaceID;
55         }
56
57         $oPlaceLookup = new PlaceLookup($oDB);
58         $oPlaceLookup->setLanguagePreference($aLangPrefOrder);
59         $oPlaceLookup->setIncludeAddressDetails(true);
60         $oPlaceLookup->setPlaceId($iPlaceID);
61
62         $aPlaceAddress = array_reverse($oPlaceLookup->getAddressDetails());
63
64         if (!sizeof($aPlaceAddress)) userError("Unknown place id.");
65
66         $aBreadcrums = array();
67         foreach($aPlaceAddress as $i => $aPlace)
68         {
69                 if (!$aPlace['place_id']) continue;
70                 $aBreadcrums[] = array('placeId'   => $aPlace['place_id'],
71                                        'osmType'   => $aPlace['osm_type'],
72                                        'osmId'     => $aPlace['osm_id'],
73                                        'localName' => $aPlace['localname']);
74
75                 if ($sOutputFormat == 'html')
76                 {
77                         $sPlaceUrl = 'hierarchy.php?place_id='.$aPlace['place_id'];
78                         if ($i) echo " &gt; ";
79                         echo '<a href="'.$sPlaceUrl.'">'.$aPlace['localname'].'</a> ('.osmLink($aPlace).')';
80                 }
81         }
82
83
84         if ($sOutputFormat == 'json')
85         {
86                 header("content-type: application/json; charset=UTF-8");
87                 $aDetails = array();
88                 $aDetails['breadcrumbs'] = $aBreadcrums;
89                 javascript_renderData($aDetails);
90                 exit;
91         }
92
93         $aRelatedPlaceIDs = chksql($oDB->getCol($sSQL = "select place_id from placex where linked_place_id = $iPlaceID or place_id = $iPlaceID"));
94
95         $sSQL = "select obj.place_id, osm_type, osm_id, class, type, housenumber, admin_level, rank_address, ST_GeometryType(geometry) in ('ST_Polygon','ST_MultiPolygon') as isarea,  st_area(geometry) as area, ";
96         $sSQL .= " get_name_by_language(name,$sLanguagePrefArraySQL) as localname, length(name::text) as namelength ";
97         $sSQL .= " from (select placex.place_id, osm_type, osm_id, class, type, housenumber, admin_level, rank_address, rank_search, geometry, name from placex ";
98         $sSQL .= " where parent_place_id in (".join(',',$aRelatedPlaceIDs).") and name is not null order by rank_address asc,rank_search asc limit 500) as obj";
99         $sSQL .= " order by rank_address asc,rank_search asc,localname,class, type,housenumber";
100         $aParentOfLines = chksql($oDB->getAll($sSQL));
101
102         if (sizeof($aParentOfLines))
103         {
104                 echo '<h2>Parent Of:</h2>';
105                 $aClassType = getClassTypesWithImportance();
106                 $aGroupedAddressLines = array();
107                 foreach($aParentOfLines as $aAddressLine)
108                 {
109                         if (isset($aClassType[$aAddressLine['class'].':'.$aAddressLine['type'].':'.$aAddressLine['admin_level']]['label'])
110                               && $aClassType[$aAddressLine['class'].':'.$aAddressLine['type'].':'.$aAddressLine['admin_level']]['label'])
111                         {
112                                 $aAddressLine['label'] = $aClassType[$aAddressLine['class'].':'.$aAddressLine['type'].':'.$aAddressLine['admin_level']]['label'];
113                         }
114                         elseif (isset($aClassType[$aAddressLine['class'].':'.$aAddressLine['type']]['label'])
115                                 && $aClassType[$aAddressLine['class'].':'.$aAddressLine['type']]['label'])
116                         {
117                                 $aAddressLine['label'] = $aClassType[$aAddressLine['class'].':'.$aAddressLine['type']]['label'];
118                         }
119                         else $aAddressLine['label'] = ucwords($aAddressLine['type']);
120
121                         if (!isset($aGroupedAddressLines[$aAddressLine['label']])) $aGroupedAddressLines[$aAddressLine['label']] = array();
122                                 $aGroupedAddressLines[$aAddressLine['label']][] = $aAddressLine;
123                 }
124
125                 foreach($aGroupedAddressLines as $sGroupHeading => $aParentOfLines)
126                 {
127                         echo "<h3>$sGroupHeading</h3>";
128                         foreach($aParentOfLines as $aAddressLine)
129                         {
130                                 $aAddressLine['localname'] = $aAddressLine['localname']?$aAddressLine['localname']:$aAddressLine['housenumber'];
131                                 $sOSMType = formatOSMType($aAddressLine['osm_type'], false);
132
133                                 echo '<div class="line">';
134                                 echo '<span class="name">'.(trim($aAddressLine['localname'])?$aAddressLine['localname']:'<span class="noname">No Name</span>').'</span>';
135                                 echo ' (';
136                                 echo '<span class="area">'.($aAddressLine['isarea']=='t'?'Polygon':'Point').'</span>';
137                                 if ($sOSMType) echo ', <span class="osm"><span class="label"></span>'.$sOSMType.' '.osmLink($aAddressLine).'</span>';
138                                 echo ', <a href="hierarchy.php?place_id='.$aAddressLine['place_id'].'">GOTO</a>';
139                                 echo ', '.$aAddressLine['area'];
140                                 echo ')';
141                                 echo '</div>';
142                         }
143                 }
144                 if (sizeof($aParentOfLines) >= 500) {
145                         echo '<p>There are more child objects which are not shown.</p>';
146                 }
147                 echo '</div>';
148         }