Sha Lek Highway

Sha Lek Highway (Chinese: 沙瀝公路) is a section of expressway in Sha Tin District, New Territories, Hong Kong. It runs 1.5 km from Tate's Cairn Highway in Siu Lek Yuen to Sha Tin Road and Sha Tin Wai Road and has a speed limit of 80 km/h. It is one of the only three expressways in Hong Kong not assigned to any numbered highway system (the others being Penny's Bay Highway and Hong Kong Link Road).

Sha Lek Highway
Sha Lek Highway
Route information
Maintained by Highways Department
Length2.2 km[1] (1.4 mi)
Major junctions
East end Route 2
West end Route 1
Highway system

Interchanges

The entire route is in Sha Tin District.

Locationkm[1]miDestinationsNotes
Siu Lek Yuen0.0–
0.9		0.0–
0.56		 Route 2 (Tate's Cairn Highway)Directional-T interchange
Sha Tin1.3–
1.9		0.81–
1.2		Sha Tin Wai RoadNo access from Sha Tin Wai Road eastbound to Sha Lek Highway westbound
2.21.4 Route 1 (Sha Tin Road)To/from Route 1 southbound only
1.000 mi = 1.609 km; 1.000 km = 0.621 mi
gollark: Slower, even.
gollark: Oops, it turns out I'm accidentally sorting by it instead of the rank, but it's equally slow after fixing that.
gollark: ```nonlocality=# EXPLAIN ANALYZE SELECT url, ts_rank(fts, query), ts_headline(fts::text, query, 'MaxWords=60') AS rank FROM pages, websearch_to_tsquery('bee') query WHERE fts @@ query ORDER BY rank LIMIT 1; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=860.92..860.92 rows=1 width=96) (actual time=8506.425..8506.427 rows=1 loops=1) -> Sort (cost=860.92..861.05 rows=52 width=96) (actual time=8506.423..8506.425 rows=1 loops=1) Sort Key: (ts_headline((pages.fts)::text, query.query, 'MaxWords=60'::text)) Sort Method: top-N heapsort Memory: 25kB -> Nested Loop (cost=688.65..860.66 rows=52 width=96) (actual time=1.362..8505.403 rows=348 loops=1) -> Function Scan on websearch_to_tsquery query (cost=0.25..0.26 rows=1 width=32) (actual time=0.023..0.025 rows=1 loops=1) -> Bitmap Heap Scan on pages (cost=688.40..846.49 rows=52 width=142) (actual time=0.353..1.502 rows=348 loops=1) Recheck Cond: (fts @@ query.query) Heap Blocks: exact=231 -> Bitmap Index Scan on page_search_index (cost=0.00..688.39 rows=52 width=0) (actual time=0.320..0.320 rows=387 loops=1) Index Cond: (fts @@ query.query) Planning Time: 0.190 ms Execution Time: 8506.463 ms(13 rows)```
gollark: It's not a condition, it's an extra row on the output, and I can see exactly what it does via `EXPLAIN ANALYZE`.
gollark: Maybe I need a better full text search backend?!

See also

References
  1. OpenStreetMap contributors. Sha Lek Highway (Map). OpenStreetMap. Retrieved 20 March 2016.


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.