Neighbourhood

App: housing

Core representation of a Cape Town neighbourhood with geographic, safety, rental, and property data.

Fields

Field	Type	Description
name	CharField	Display name
slug	SlugField	URL-safe unique identifier
district	ForeignKey(District)	Parent district/region
description	TextField	Full neighbourhood description
vibe	CharField	Short tagline (e.g. ‘Urban coastal buzz’)
best_for	CharField	Target audiences (comma-separated)
pros	TextField	Pipe-separated list of advantages
cons	TextField	Pipe-separated list of disadvantages
latitude	DecimalField	GPS latitude
longitude	DecimalField	GPS longitude
wards	JSONField	Legacy ward numbers list
wards_m2m	ManyToManyField(Ward)	Ward links via NeighbourhoodWard through table
safety_score	DecimalField	Composite safety score (0.0-10.0)
safety_level	CharField	Categorical safety level
violent_crime_score	DecimalField	Violent crime sub-score
property_crime_score	DecimalField	Property crime sub-score
gang_safety_score	DecimalField	Gang safety sub-score (10=none, 0=high)
gang_presence	TextField	Gang presence description
safety_reasoning	TextField	Safety assessment reasoning
tourist_relevance	CharField	Tourist relevance level
safety_map_color	CharField	Hex color for map marker
safety_source	CharField	Source of current safety_score
avg_rent_1br_min	IntegerField	1BR rent minimum (ZAR)
avg_rent_1br_max	IntegerField	1BR rent maximum (ZAR)
avg_rent_2br_min	IntegerField	2BR rent minimum (ZAR)
avg_rent_2br_max	IntegerField	2BR rent maximum (ZAR)
rental_yoy_change	DecimalField	Rental year-over-year change (%)
rent_1br_sample_size	PositiveIntegerField	Number of 1BR rental listings sampled
rent_1br_std_dev	IntegerField	1BR rent standard deviation (ZAR)
avg_property_price	IntegerField	Average property price (ZAR)
avg_property_price_1br	IntegerField	Median 1BR purchase price (ZAR)
price_1br_sample_size	PositiveIntegerField	Number of 1BR purchase listings sampled
price_1br_std_dev	IntegerField	1BR purchase price standard deviation (ZAR)
price_per_sqm	IntegerField	Price per m² (ZAR)
property_yoy_change	DecimalField	Property year-over-year change (%)
airbnb_listings	IntegerField	Number of Airbnb listings
airbnb_avg_nightly	IntegerField	Airbnb average nightly rate (ZAR)
listing_url	URLField	External listing URL
blog_post	ForeignKey(BlogPost)	Primary blog guide for this neighbourhood
blog_post_identifier	CharField	Deprecated: use blog_post FK instead
blog_post_path	CharField	Deprecated: use blog_post FK instead
image_url	URLField	Image URL
blog_safety_score	DecimalField	Legacy blog safety score
safety_year	CharField	Year/period of safety assessment
is_active	BooleanField	Whether neighbourhood is active
order	PositiveIntegerField	Display ordering
metrics_as_of	DateField	Date when rental/property data was collected
updated_at	DateTimeField	Last update timestamp (auto)

Relationships

• District

• Ward

• NeighbourhoodWard

• NeighbourhoodHighlight

• PropertySnapshot

• BlogPost