Charleswood, Calgary

Charleswood is a residential neighbourhood in the northwest quadrant of Calgary, Alberta. It is located east of Crowchild Trail and the University of Calgary. It borders the Nose Hill Park to the north and the Confederation Park to the southeast.

Charleswood
Neighbourhood
Charleswood
Location of Charleswood in Calgary
Coordinates: 51°05′08″N 114°06′44″W
Country Canada
Province Alberta
City Calgary
QuadrantNW
Ward4
Established1959
Government
 • MayorNaheed Nenshi
 • Administrative bodyCalgary City Council
 • CouncillorSean Chu
Area
 • Total2.3 km2 (0.9 sq mi)
Elevation
1,105 m (3,625 ft)
Population
 (2006)[2]
 • Total3,503
 • Average Income
$63,828
WebsiteTriwood Community Association

Charleswood is represented in the Calgary City Council by the Ward 4 councillor.

Demographics

In the City of Calgary's 2012 municipal census, Charleswood had a population of 3,421 living in 1,494 dwellings, a 1.9% increase from its 2011 population of 3,357.[3] With a land area of 1.8 km2 (0.69 sq mi), it had a population density of 1,900/km2 (4,920/sq mi) in 2012.[4][3]

Residents in this community had a median household income of $63,828 in 2000, and there were 12.9% low income residents living in the neighbourhood.[5] As of 2000, 17.6% of the residents were immigrants. A proportion of 11.6% of the buildings were condominiums or apartments, and 18.4% of the housing was used for renting.[2]

Education

The community is served by Banff Trail Bilingual Elementary, Collingwood Elementary and Senator Patrick Burns Junior High public schools, as well as by St. Francis Senior High and St. Margaret Elementary & Junior High Catholic schools.

gollark: What? Why does it say it's doing a sequential scan now? Æ all is bee.
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`.

See also

References
  1. "Calgary Elections". City of Calgary. 2017. Retrieved November 12, 2017.
  2. City of Calgary (2006). "Charleswood Community Statistics" (PDF). Retrieved 2007-05-09.
  3. "2012 Civic Census Results" (PDF). City of Calgary. 2012. Retrieved February 4, 2013.
  4. "Community Boundaries" (Esri shapefile). City of Calgary. Retrieved February 5, 2013.
  5. City of Calgary (2004). "Ward 7 Profile" (PDF). Retrieved 2007-05-09.


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