Geocoding

2017-03-06 21:53:31   0  举报





仅支持查看

Geocoding是将地理坐标（如经纬度）转换为地址的过程。它是一种将地理位置信息从一种格式转换为另一种格式的技术，通常用于地图、导航和位置服务等领域。例如，如果您有一个包含经纬度坐标的数据集，您可以使用geocoding工具将这些坐标转换为相应的地址字符串，以便在地图上显示或进行进一步分析。此外，geocoding还可以用于反向操作，即将地址转换为对应的地理坐标。这种技术在许多领域都有广泛的应用，包括城市规划、交通管理、紧急响应和物流等。总之，geocoding是一种强大的工具，可以帮助我们更好地理解和利用地理信息。

作者其他创作

大纲/内容

19. GetGeometryFromPlaceX

13. GetPlaceIdsFromLocationPropertyOsmline

select count(*) from pg_tables where tablename = @tableName

PreferableCountryCodes != null && PreferableCountryCodes.Count != 0

select place_id from placex where country_code=@countryCode and rank_search = 4order by st_area(geometry) desc limit 1;

string.IsNullOrEmpty(search.Operator) || search.Operator == nameKey

14. GetPlaceIdsFromLocationPropertyAux

18. IsTableExists

UseAuxLocationData && placeIDs.Count == 0

4. Get place_id by countrycode

select distinct place_id from location_property_osmline where parent_place_id in ({0}) and (interpolationtype='{0}' or interpolationtype='all') and @houseNumber>=startnumber and @houseNumber<=endnumber

23. GetResultsCore

6. Get count(*) from pg_tables

11. Get place_id by search_name

UseUSTigerData && placeIDs.Count == 0

!string.IsNullOrEmpty(search.HouseNumber) && placeIDs.Count != 0

3. Get place_id by countrycode

!string.IsNullOrEmpty(search.Class) && placeIDs.Count != 0 && string.IsNullOrEmpty(search.CountryCode)

select place_id from {0} ct join placex using (place_id) where country_code in ({0}) limit 1

select place_id from placex where country_code=@countryCode and rank_search = 4 and country_code in ({0})order by st_area(geometry) desc limit 1;

select place_id from placex where class=@class and type=@type and linked_place_id is null and country_code in ({0}) limit 40

select place_id from placex where place_id in ({0}) and rank_search < @maxRank

select place_id from placex where parent_place_id in ({0}) and transliteration(housenumber) ~* E'{0}' limit 40

12. Get place_id from placex

16. FilterPlaceIdsFromPlaceX

21. GetPlaceIdsByGeometry

search.Names.Count == 0 && search.Addresses.Count == 0

2. GBPostcodeCalculate

select place_id from location_property_aux where parent_place_id in ({0}) and housenumber = @houseNumber

IsTableExists

select place_id from placex where place_id in ({0}) and class=@class and type=@type and linked_place_id is null order by rank_search asc limit 40

17. GetMaxRank

!string.IsNullOrEmpty(search.CountryCode) && string.IsNullOrEmpty(search.Class) && string.IsNullOrEmpty(search.HouseNumber)

5. Get place_id by class_type

15. GetPlaceIdsFromTigerData

select min(rank_search) from placex where place_id in ({0})

22. GetPlaceIdsByrange

20. FilterPlaceIdsByMaxRank

10. Get place_id

ContainsPostcode

string.IsNullOrEmpty(placeGeom)

8. Get place_id

1. GetValidToken

string.IsNullOrEmpty(search.Operator) || search.Operator == nearKey

7. Get place_id

tableExists

select distinct place_id from location_property_tiger where parent_place_id in ({0}) and (interpolationtype='{0}' or interpolationtype='all') and ((@houseNumber>=startnumber and @houseNumber<=endnumber) or (@houseNumber>=endnumber and @houseNumber<=startnumber))

MaxRank < 9 && tableExists

select place_id from {0} ct limit 40

placeIDs.Count == 0

select place_id from placex where class=@class and type=@type and linked_place_id is null limit 40

9. Get place_id