The Matakana region offers a high level of competition in the commercial real estate market.
\n\nA spatial opportunity score of 65/100 indicates that CORBELL INVESTMENTS LIMITED has limited opportunities to differentiate itself from local competitors within a 5km radius.
\n\nHowever, their calculated digital presence score of 50/100 suggests that they have a relatively low online footprint compared to other businesses in the region.
\n\nThe Matakana area is characterized by a high density of commercial properties with few existing business ventures or residential developments within a 5km radius, which contributes to CORBELL INVESTMENTS LIMITED's competitive market position.
","cached_region_slug":"matakana","cached_suburb_slug":"matakana","cached_industry_slug":"investment-residential-property","cached_business_slug":"-9429031983679","gst_status":"Active","is_maori_business":false,"distance_meters":0.00089712},{"id":"39146","nzbn":"9429035476757","company_name":"No trading name","address_line_1":"Po Box 73","address_line_2":null,"address_line_3":"Matakana","address_line_4":null,"address_postcode":"0948","address_country":"NEW ZEALAND","nzbn_address":"po box 73 matakana","authoritative_address":"po box 73 matakana","latitude":-37.5600501,"longitude":176.06314581015363,"latlon":"0101000020E6100000A8AF5C4A050266408ECFBFB8AFC742C0","match_score":null,"merged_at":"2026-03-05T19:30:59.516Z","address_paf_id":null,"address_care_of":"Alexander Cropping Limited","industry_code":"A052963","industry_desc":"Horticultural services nec","website":"no website","email":null,"phone":null,"entity_status":"Registered","entity_type":"LTD","start_date":"17/03/2004","end_date":null,"directors":["Hamish John ALEXANDER","Robyn Janet ALEXANDER"],"metadata":{"nzbn":"9429035476757","type":"POSTAL","address_1":"Po Box 73","address_2":"","address_3":"Matakana","address_4":"","start_date":"03/05/2019","entity_name":"ALEXANDER CROPPING LIMITED","address_paf_id":"","address_care_of":"","address_country":"NEW ZEALAND","address_postcode":"0948"},"source_file":"table:nzbn_matching_stage_with_alias","source_timestamp":"2026-03-20T18:50:48.643Z","source_of_address":"nzbn","source_of_coordinates":"geocode_enrich","source_of_industry":"historical","last_enriched_at":"2026-06-06T18:21:11.111Z","last_source_update_at":"2026-03-20T18:50:48.643Z","entity_name":"ALEXANDER CROPPING LIMITED","trading_name":"","source_last_updated_at":"2026-03-20T18:50:48.643Z","address_suburb":null,"address_city":"Matakana","address_full":"po box 73 matakana","industry_description":"Horticultural services nec","website_verified":"not_valid","website_url":"no website","competitor_flags":null,"change_status":"updated","created_at":"2026-03-05T19:31:01.000Z","updated_at":"2026-06-06T18:21:11.111Z","stage5_run_id":"2779","change_fingerprint":"eadfcb3d98df76b5423ba25dfc04ef3d","address_hash":"b3e121bc2092b841bfd851e60ff5be5c","coordinate_hash":"0a8219abd60fdefc3db14aaf0cb5e58d","ready_for_scoring":true,"industry_confidence":"0.800","column_lineage":null,"src_raw_payload":null,"src_hash_key":"eacdce42e1a0f31f5106ef3a9a20c017","src_exact_address_key":"po box 73 matakana","src_norm_address_key":"pobox73matakana","src_norm_address_nopc_key":"pobox73matakana","src_canonical_address_key":"pobox73matakana","src_street_number_key":null,"src_house_number_key":null,"src_number_key":null,"src_unit_key":null,"src_level_key":null,"src_rd_key":null,"src_is_rural":false,"src_is_po_box":true,"src_is_private_bag":false,"src_po_box_key":"73","src_private_bag_key":null,"src_suburb_key":"matakana","src_street_key":null,"src_street_name_key":"pobox73matakana","src_postcode_key":"0948","src_has_unit":false,"src_has_number":false,"src_is_incomplete":true,"src_quality_score":0.5,"src_source_batch_id":null,"src_schema_version":null,"src_cleaning_rules_version":null,"src_email_is_valid":null,"src_phone_is_valid":null,"src_website_is_valid":null,"src_data_quality_score":null,"src_missing_field_count":null,"src_invalid_field_count":null,"src_duplicate_across_files":false,"src_is_valid_record":true,"src_error_bucket":null,"src_error_details":null,"src_clean_company_name":"9429035476757","src_clean_address_text":"po box 73 matakana","src_clean_street":null,"src_clean_house_number":null,"src_clean_unit":null,"src_clean_suburb":"matakana","src_clean_postcode":"0948","src_is_rural_delivery":false,"src_address_quality_score":0.6,"src_contact_quality_score":0,"src_cleaned_at":"2026-03-20T18:50:50.996Z","linz_match_id":null,"linz_matched_address":null,"linz_raw_match_score":null,"linz_raw_latitude":null,"linz_raw_longitude":null,"linz_nominatim_latitude":-37.5600501,"linz_nominatim_longitude":176.0631458,"linz_nominatim_confidence":"0.5000","linz_distance_meters":null,"linz_nominatim_display_name":"[opencage] Matakana Island, Kauri Point, Western Bay of Plenty District, New Zealand","linz_geocode_duration_ms":1131,"linz_match_gid":null,"linz_match_confidence":null,"linz_match_method":"opencage+linz_spatial","linz_matcher":"opencage+linz_spatial","linz_attempted_methods":[{"method":"linz_enhanced","status":"below_threshold","linz_score":0},{"method":"mcp","status":"failed"},{"method":"nominatim","status":"failed"},{"method":"opencage","status":"geocoded","provider":"opencage","confidence":0.5,"duration_ms":1204},{"method":"opencage","status":"geocoded"}],"linz_attempted_methods_count":5,"linz_match_tokens":"{\"po box 73 matakana alexander cropping limited\"}","linz_deterministic_match_key":"6c39cf38ec3311f8c2d5568fcb297d0c","linz_match_tier":2,"linz_match_confidence_category":null,"linz_score_explanation":{"summary":"No match found","provider":"opencage","match_tier":2,"match_score":null,"match_method":"opencage+linz_spatial","attempted_methods_count":5},"linz_match_mode":"strict","ovp_total_pois":null,"ovp_positive_pois":null,"ovp_competitors":null,"ovp_site_score":null,"ovp_building":null,"ovp_building_levels":null,"ovp_building_height":null,"ovp_landuse":null,"active":"true","address_clean":"po box 73 matakana","address_raw":"po box 73 matakana","first_seen_at":null,"last_seen_at":"2026-03-21 07:50:50.996208+13","last_updated_at":"2026-03-21 06:51:41.826651+13","opening_hours_text":null,"opening_hours_normalised":"Mon 09:00-17:00; Tue 09:00-17:00; Wed 09:00-17:00; Thu 09:00-17:00; Fri 09:00-17:00; Sat closed; Sun closed","opening_hours_source":"template","opening_hours_status":"template","opening_hours_confidence":0.3,"opening_hours_summary":"Mon 09:00-17:00; Tue 09:00-17:00; Wed 09:00-17:00; Thu 09:00-17:00; Fri 09:00-17:00; Sat closed; Sun closed","opening_hours_hash":"a3418d54492e84738b42ca71cb76b9ec","geocode_confidence":null,"industry_keywords":null,"name_tokens":"{\"legal\": \"alexander cropping limited\", \"tokens\": [\"alexander\", \"cropping\"], \"trading\": \"alexander cropping\", \"short_form\": \"alexander\"}","poi_context":null,"postcode_valid":"true","provenance_meta":"{\"source_file\": \"companies_public_address.csv\"}","road_class":null,"street_expanded":null,"suburb_boundary_flag":null,"address_graph":"{\"suburb\": \"matakana\", \"postcode\": \"0948\", \"address_norm\": \"po box 73 matakana\"}","address_type":"po_box","address_variants":"[\"po box 73 matakana\"]","address_variants_conf":"{\"po box 73 matakana\": 1.0}","category_hint":null,"cleanliness_audit":"{\"dup_score\": true, \"road_class\": false, \"enhanced_at\": \"2026-03-20T18:31:04Z\", \"name_tokens\": true, \"poi_context\": false, \"address_type\": true, \"address_graph\": true, \"category_hint\": false, \"domain_present\": false, \"postcode_valid\": true, \"provenance_meta\": true, \"street_expanded\": false, \"address_variants\": true, \"address_ambiguity\": false, \"industry_keywords\": false, \"geocode_confidence\": false, \"address_hash_stable\": true, \"suburb_boundary_flag\": false, \"address_quality_score\": true, \"address_variants_conf\": true}","domain_present":null,"dup_score":"0.0","flags":null,"website_phone_source":null,"website_phone_hash":null,"last_contact_enriched_at":null,"nz_addr_lat":null,"nz_addr_lon":null,"nz_addr_suburb":null,"nz_addr_district":null,"nz_addr_region":null,"nz_addr_verified":null,"nz_addr_confidence":null,"nz_addr_source":null,"nz_addr_hash":null,"last_nz_addr_verified_at":null,"ready_for_scoring_reason_code":"ready","website_canonical":null,"has_website":false,"has_phone":false,"has_email":false,"outreach_score":5,"phone_quality":"missing","address_confidence":null,"website_dup_count":0,"industry_group":"Horticultural services nec","address_normalisation_issue":null,"enrichment_geocode_updated_at":"2026-04-17T21:04:59.075Z","enrichment_overpass_updated_at":null,"enrichment_contact_updated_at":null,"source_updated_at_nzbn":"2026-03-20T18:50:48.643Z","source_updated_at_linz":"2026-03-20T18:50:48.643Z","source_updated_at_overpass":null,"linkedin_url":null,"cluster_key":"-37.5601,176.0631","anchor_business_score":0,"anchor_business_confidence":0.71,"anchor_business_source":"structured","anchor_business_summary":"ANCHOR|src=structured|c500=0|c1k=0|near=8660.8|super=0|gym=0|school=0|hosp=0|retail=0|score=0.0","anchor_business_hash":"5e20575e88bfb1d09f4bcb2be0cdb68b","anchor_business_count_500m":0,"anchor_business_count_1km":0,"anchor_business_nearest_m":8660.76199227,"anchor_supermarket_count_1km":0,"anchor_gym_count_1km":0,"anchor_school_count_1km":0,"anchor_hospital_count_1km":0,"anchor_retail_centre_count_1km":0,"location":"0101000020E6100000A8AF5C4A050266408ECFBFB8AFC742C0","transit_accessibility_score":0,"transit_accessibility_confidence":0,"transit_accessibility_source":"missing","transit_accessibility_summary":"TRANSIT|src=missing|bus=0|train=0|ferry=0|parkride=0|score=0.0|conf=0.00","transit_accessibility_hash":"8a7b8ede68df9173c6c88778b3ad3bec","transit_nearest_bus_stop_m":null,"transit_nearest_train_station_m":null,"transit_nearest_ferry_terminal_m":null,"transit_park_ride_count_1km":0,"transit_bus_stop_count_1km":0,"transit_train_station_count_1km":0,"transit_ferry_terminal_count_1km":0,"transit_stop_count_300m":0,"transit_stop_count_500m":0,"transit_stop_count_1km":0,"building_footprint_area_sqm":220,"building_levels":null,"building_use":"unknown_fallback","landuse_category":"unknown_fallback","landuse_area_sqm":null,"building_landuse_score":0.5462,"building_landuse_confidence":0.5973,"building_landuse_source":"inferred","building_landuse_summary":"BLD-LU|src=inferred|area=220|levels=n/a|bld=unknown_fallback|land=unknown_fallback|inf=building_type+default_landuse|score=0.546","building_landuse_hash":"8c359575297608180427cf727b9b5378","source_run_id":"a11c5ec18df6","company_website":null,"last_advanced_enriched_at":null,"h3_res7":"87bb56180ffffff","h3_res8":"88bb561855fffff","h3_res9":"89bb561854bffff","foot_traffic_score":2.66,"foot_traffic_density":"low","foot_traffic_confidence":0.194,"foot_traffic_source":"missing","foot_traffic_summary":"FOOT_TRAFFIC|src=missing|poi50=0|anchor=0.00|transit=0.00|score01=0.027|conf=0.19","foot_traffic_hash":"ded71eb6c439997f86ade1cd61a7cf59","foot_traffic_is_inferred":true,"foot_traffic_provenance":{"density":"low","score01":0.0266,"features":{"cluster_id":"ftc-5e38e632","building_area":45,"is_multi_unit":false,"synergy_score":0,"attractor_ratio":0,"day_night_ratio":1,"poi_density_50m":0,"poi_density_100m":0,"poi_density_200m":0,"similarity_score":0.4535,"street_closeness":0,"transit_distance":null,"corridor_strength":0,"event_venue_score":0,"walkability_score":0,"anchor_decay_score":0,"competitor_density":0,"street_betweenness":0,"building_usage_type":"other","competitor_distance":null,"has_pedestrian_path":false,"macroblock_activity":0.0004,"microblock_activity":0.0006,"poi_churn_intensity":0,"poi_diversity_index":0,"poi_freshness_score":0,"anchor_gravity_score":0,"flow_direction_score":0,"intersection_density":0,"transit_stop_density":0,"retail_frontage_length":4.02,"school_proximity_score":0,"weekend_activity_score":0,"opening_hours_intensity":0,"transit_frequency_score":0,"building_intensity_score":0.0025,"essential_services_score":0,"poi_temporal_churn_score":0,"hospitality_cluster_score":0,"competitor_viability_score":0.1266},"ft_count":0,"confidence":0.194,"source_type":"missing","nearest_ft_m":null,"ovp_positive":0,"ovp_site_score":0},"anchor_gravity_score":0,"poi_churn_intensity":0,"poi_density_50m":0,"poi_density_100m":0,"poi_density_200m":0,"poi_diversity_index":0,"competitor_density":0,"competitor_distance":null,"street_betweenness":0,"street_closeness":0,"has_pedestrian_path":false,"intersection_density":0,"building_area":45,"building_usage_type":"other","is_multi_unit":false,"retail_frontage_length":4.02,"transit_distance":null,"transit_stop_density":0,"transit_frequency_score":0,"opening_hours_intensity":0,"weekend_activity_score":0,"school_proximity_score":0,"hospitality_cluster_score":0,"essential_services_score":0,"event_venue_score":0,"poi_temporal_churn_score":0,"cluster_id":"ftc-5e38e632","similarity_score":0.4535,"corridor_strength":0,"attractor_ratio":0,"synergy_score":0,"building_intensity_score":0.0025,"microblock_activity":0.0006,"macroblock_activity":0.0004,"walkability_score":0,"flow_direction_score":0,"anchor_decay_score":0,"poi_freshness_score":0,"competitor_viability_score":0.1266,"day_night_ratio":1,"worker_population_headcount":22.2,"worker_population_estimate":22.2,"worker_population_source":"proxy","worker_population_summary":"HC|src=proxy|band=small|est=22|conf=0.500|sig=2","worker_population_hash":"3ef3c09bfcadf34fd320ac40590b23ad","headcount_final_estimate":22.2,"headcount_confidence":0.5,"headcount_sources_used":2,"is_scraped":false,"residential_density_score":0,"residential_density_confidence":0,"residential_density_source":"missing","residential_density_summary":"Residential demand none; src=missing; pop/km2=; dwell/km2=; mixed_use=no; uplift=0.80; score=0.000","residential_density_hash":"8b7d048358546efdc88e6ab2465ca578","residential_density_uplift_factor":0.8,"residential_meshblock_population":0,"residential_meshblock_dwellings":0,"residential_population_density_km2":null,"residential_dwelling_density_km2":null,"residential_cluster_count_300m":0,"residential_mixed_use_signal":false,"residential_inferred":false,"headcount_derived":17.76,"meshblock_id":null,"is_sponsored":false,"ai_overview_html":null,"cached_region_slug":"matakana","cached_suburb_slug":"all","cached_industry_slug":"horticultural-services-nec","cached_business_slug":"-9429035476757","gst_status":"Active","is_maori_business":false,"distance_meters":0.00089712},{"id":"81732","nzbn":"9429045859281","company_name":"No trading name","address_line_1":"Po Box 319","address_line_2":"Leigh","address_line_3":"Matakana","address_line_4":null,"address_postcode":"0948","address_country":"NEW ZEALAND","nzbn_address":"po box 319 matakana","authoritative_address":"po box 319 matakana","latitude":-37.5600501,"longitude":176.06314581015363,"latlon":"0101000020E6100000A8AF5C4A050266408ECFBFB8AFC742C0","match_score":null,"merged_at":"2026-03-05T19:31:10.163Z","address_paf_id":"2806539","address_care_of":null,"industry_code":"L671150","industry_desc":"Investment - residential property","website":"no website","email":null,"phone":null,"entity_status":"Registered","entity_type":"LTD","start_date":"02/12/2016","end_date":null,"directors":["Christopher George FLOYD"],"metadata":{"nzbn":"9429045859281","type":"POSTAL","address_1":"Po Box 319","address_2":"","address_3":"Matakana","address_4":"","start_date":"20/04/2020","entity_name":"KORORA INVESTMENTS LIMITED","address_paf_id":"","address_care_of":"","address_country":"NEW ZEALAND","address_postcode":"0948"},"source_file":"table:nzbn_matching_stage_with_alias","source_timestamp":"2026-03-20T18:50:48.643Z","source_of_address":"nzbn","source_of_coordinates":"geocode_enrich","source_of_industry":"historical","last_enriched_at":"2026-06-06T18:21:42.414Z","last_source_update_at":"2026-03-20T18:50:48.643Z","entity_name":"KORORA INVESTMENTS LIMITED","trading_name":"","source_last_updated_at":"2026-03-20T18:50:48.643Z","address_suburb":"Leigh","address_city":"Matakana","address_full":"po box 319 matakana","industry_description":"Investment - residential property","website_verified":"not_valid","website_url":"no website","competitor_flags":null,"change_status":"updated","created_at":"2026-03-05T19:31:11.000Z","updated_at":"2026-06-06T18:21:42.414Z","stage5_run_id":"2779","change_fingerprint":"f5b48b62921ed44e9206c63b945a24eb","address_hash":"0aa4e4c3556e7ada7a2dadf7060e2cf1","coordinate_hash":"0a8219abd60fdefc3db14aaf0cb5e58d","ready_for_scoring":true,"industry_confidence":"0.800","column_lineage":null,"src_raw_payload":null,"src_hash_key":"06c647de41374d25ba18da4d98e172d3","src_exact_address_key":"po box 319 matakana","src_norm_address_key":"pobox319matakana","src_norm_address_nopc_key":"pobox319matakana","src_canonical_address_key":"pobox319matakana","src_street_number_key":null,"src_house_number_key":null,"src_number_key":null,"src_unit_key":null,"src_level_key":null,"src_rd_key":null,"src_is_rural":false,"src_is_po_box":true,"src_is_private_bag":false,"src_po_box_key":"319","src_private_bag_key":null,"src_suburb_key":"matakana","src_street_key":null,"src_street_name_key":"pobox319matakana","src_postcode_key":"0948","src_has_unit":false,"src_has_number":false,"src_is_incomplete":true,"src_quality_score":0.5,"src_source_batch_id":null,"src_schema_version":null,"src_cleaning_rules_version":null,"src_email_is_valid":null,"src_phone_is_valid":null,"src_website_is_valid":null,"src_data_quality_score":null,"src_missing_field_count":null,"src_invalid_field_count":null,"src_duplicate_across_files":false,"src_is_valid_record":true,"src_error_bucket":null,"src_error_details":null,"src_clean_company_name":"9429045859281","src_clean_address_text":"po box 319 matakana","src_clean_street":null,"src_clean_house_number":null,"src_clean_unit":null,"src_clean_suburb":"matakana","src_clean_postcode":"0948","src_is_rural_delivery":false,"src_address_quality_score":0.6,"src_contact_quality_score":0,"src_cleaned_at":"2026-03-20T18:50:50.996Z","linz_match_id":null,"linz_matched_address":null,"linz_raw_match_score":null,"linz_raw_latitude":null,"linz_raw_longitude":null,"linz_nominatim_latitude":-37.5600501,"linz_nominatim_longitude":176.0631458,"linz_nominatim_confidence":"0.5000","linz_distance_meters":null,"linz_nominatim_display_name":"[opencage] Matakana Island, Kauri Point, Western Bay of Plenty District, New Zealand","linz_geocode_duration_ms":1022,"linz_match_gid":null,"linz_match_confidence":null,"linz_match_method":"opencage+linz_spatial","linz_matcher":"opencage+linz_spatial","linz_attempted_methods":[{"method":"linz_enhanced","status":"below_threshold","linz_score":0},{"method":"mcp","status":"failed"},{"method":"nominatim","status":"failed"},{"method":"opencage","status":"geocoded","provider":"opencage","confidence":0.5,"duration_ms":1119},{"method":"opencage","status":"geocoded"}],"linz_attempted_methods_count":5,"linz_match_tokens":"{\"po box 319 matakana korora investments limited\"}","linz_deterministic_match_key":"c16536e4711659fcd3aeca2296b788b7","linz_match_tier":2,"linz_match_confidence_category":null,"linz_score_explanation":{"summary":"No match found","provider":"opencage","match_tier":2,"match_score":null,"match_method":"opencage+linz_spatial","geocode_confidence":80,"attempted_methods_count":5},"linz_match_mode":"strict","ovp_total_pois":null,"ovp_positive_pois":null,"ovp_competitors":null,"ovp_site_score":null,"ovp_building":null,"ovp_building_levels":null,"ovp_building_height":null,"ovp_landuse":null,"active":"true","address_clean":"po box 319 matakana","address_raw":"po box 319 matakana","first_seen_at":null,"last_seen_at":"2026-03-21 07:50:50.996208+13","last_updated_at":"2026-03-21 06:51:41.826651+13","opening_hours_text":null,"opening_hours_normalised":"Mon 09:00-17:00; Tue 09:00-17:00; Wed 09:00-17:00; Thu 09:00-17:00; Fri 09:00-17:00; Sat closed; Sun closed","opening_hours_source":"template","opening_hours_status":"template","opening_hours_confidence":0.3,"opening_hours_summary":"Mon 09:00-17:00; Tue 09:00-17:00; Wed 09:00-17:00; Thu 09:00-17:00; Fri 09:00-17:00; Sat closed; Sun closed","opening_hours_hash":"a3418d54492e84738b42ca71cb76b9ec","geocode_confidence":null,"industry_keywords":null,"name_tokens":"{\"legal\": \"korora investments limited\", \"tokens\": [\"korora\", \"investments\"], \"trading\": \"korora investments\", \"short_form\": \"korora\"}","poi_context":null,"postcode_valid":"true","provenance_meta":"{\"source_file\": \"companies_public_address.csv\"}","road_class":null,"street_expanded":null,"suburb_boundary_flag":null,"address_graph":"{\"suburb\": \"matakana\", \"postcode\": \"0948\", \"address_norm\": \"po box 319 matakana\"}","address_type":"po_box","address_variants":"[\"po box 319 matakana\"]","address_variants_conf":"{\"po box 319 matakana\": 1.0}","category_hint":null,"cleanliness_audit":"{\"dup_score\": true, \"road_class\": false, \"enhanced_at\": \"2026-03-20T18:31:16Z\", \"name_tokens\": true, \"poi_context\": false, \"address_type\": true, \"address_graph\": true, \"category_hint\": false, \"domain_present\": false, \"postcode_valid\": true, \"provenance_meta\": true, \"street_expanded\": false, \"address_variants\": true, \"address_ambiguity\": false, \"industry_keywords\": false, \"geocode_confidence\": false, \"address_hash_stable\": true, \"suburb_boundary_flag\": false, \"address_quality_score\": true, \"address_variants_conf\": true}","domain_present":null,"dup_score":"0.0","flags":null,"website_phone_source":null,"website_phone_hash":null,"last_contact_enriched_at":null,"nz_addr_lat":null,"nz_addr_lon":null,"nz_addr_suburb":null,"nz_addr_district":null,"nz_addr_region":null,"nz_addr_verified":null,"nz_addr_confidence":null,"nz_addr_source":null,"nz_addr_hash":null,"last_nz_addr_verified_at":null,"ready_for_scoring_reason_code":"ready","website_canonical":null,"has_website":false,"has_phone":false,"has_email":false,"outreach_score":5,"phone_quality":"missing","address_confidence":null,"website_dup_count":0,"industry_group":"Investment - residential property","address_normalisation_issue":null,"enrichment_geocode_updated_at":"2026-04-17T21:04:59.075Z","enrichment_overpass_updated_at":null,"enrichment_contact_updated_at":null,"source_updated_at_nzbn":"2026-03-20T18:50:48.643Z","source_updated_at_linz":"2026-03-20T18:50:48.643Z","source_updated_at_overpass":null,"linkedin_url":null,"cluster_key":"-37.5601,176.0631","anchor_business_score":0,"anchor_business_confidence":0.71,"anchor_business_source":"structured","anchor_business_summary":"ANCHOR|src=structured|c500=0|c1k=0|near=8660.8|super=0|gym=0|school=0|hosp=0|retail=0|score=0.0","anchor_business_hash":"5e20575e88bfb1d09f4bcb2be0cdb68b","anchor_business_count_500m":0,"anchor_business_count_1km":0,"anchor_business_nearest_m":8660.76199227,"anchor_supermarket_count_1km":0,"anchor_gym_count_1km":0,"anchor_school_count_1km":0,"anchor_hospital_count_1km":0,"anchor_retail_centre_count_1km":0,"location":"0101000020E6100000A8AF5C4A050266408ECFBFB8AFC742C0","transit_accessibility_score":0,"transit_accessibility_confidence":0,"transit_accessibility_source":"missing","transit_accessibility_summary":"TRANSIT|src=missing|bus=0|train=0|ferry=0|parkride=0|score=0.0|conf=0.00","transit_accessibility_hash":"8a7b8ede68df9173c6c88778b3ad3bec","transit_nearest_bus_stop_m":null,"transit_nearest_train_station_m":null,"transit_nearest_ferry_terminal_m":null,"transit_park_ride_count_1km":0,"transit_bus_stop_count_1km":0,"transit_train_station_count_1km":0,"transit_ferry_terminal_count_1km":0,"transit_stop_count_300m":0,"transit_stop_count_500m":0,"transit_stop_count_1km":0,"building_footprint_area_sqm":220,"building_levels":null,"building_use":"unknown_fallback","landuse_category":"unknown_fallback","landuse_area_sqm":null,"building_landuse_score":0.5462,"building_landuse_confidence":0.5973,"building_landuse_source":"inferred","building_landuse_summary":"BLD-LU|src=inferred|area=220|levels=n/a|bld=unknown_fallback|land=unknown_fallback|inf=building_type+default_landuse|score=0.546","building_landuse_hash":"8c359575297608180427cf727b9b5378","source_run_id":"a11c5ec18df6","company_website":null,"last_advanced_enriched_at":null,"h3_res7":"87bb56180ffffff","h3_res8":"88bb561855fffff","h3_res9":"89bb561854bffff","foot_traffic_score":2.66,"foot_traffic_density":"low","foot_traffic_confidence":0.194,"foot_traffic_source":"missing","foot_traffic_summary":"FOOT_TRAFFIC|src=missing|poi50=0|anchor=0.00|transit=0.00|score01=0.027|conf=0.19","foot_traffic_hash":"ded71eb6c439997f86ade1cd61a7cf59","foot_traffic_is_inferred":true,"foot_traffic_provenance":{"density":"low","score01":0.0266,"features":{"cluster_id":"ftc-5e38e632","building_area":45,"is_multi_unit":false,"synergy_score":0,"attractor_ratio":0,"day_night_ratio":1,"poi_density_50m":0,"poi_density_100m":0,"poi_density_200m":0,"similarity_score":0.4535,"street_closeness":0,"transit_distance":null,"corridor_strength":0,"event_venue_score":0,"walkability_score":0,"anchor_decay_score":0,"competitor_density":0,"street_betweenness":0,"building_usage_type":"other","competitor_distance":null,"has_pedestrian_path":false,"macroblock_activity":0.0004,"microblock_activity":0.0006,"poi_churn_intensity":0,"poi_diversity_index":0,"poi_freshness_score":0,"anchor_gravity_score":0,"flow_direction_score":0,"intersection_density":0,"transit_stop_density":0,"retail_frontage_length":4.02,"school_proximity_score":0,"weekend_activity_score":0,"opening_hours_intensity":0,"transit_frequency_score":0,"building_intensity_score":0.0025,"essential_services_score":0,"poi_temporal_churn_score":0,"hospitality_cluster_score":0,"competitor_viability_score":0.1266},"ft_count":0,"confidence":0.194,"source_type":"missing","nearest_ft_m":null,"ovp_positive":0,"ovp_site_score":0},"anchor_gravity_score":0,"poi_churn_intensity":0,"poi_density_50m":0,"poi_density_100m":0,"poi_density_200m":0,"poi_diversity_index":0,"competitor_density":0,"competitor_distance":null,"street_betweenness":0,"street_closeness":0,"has_pedestrian_path":false,"intersection_density":0,"building_area":45,"building_usage_type":"other","is_multi_unit":false,"retail_frontage_length":4.02,"transit_distance":null,"transit_stop_density":0,"transit_frequency_score":0,"opening_hours_intensity":0,"weekend_activity_score":0,"school_proximity_score":0,"hospitality_cluster_score":0,"essential_services_score":0,"event_venue_score":0,"poi_temporal_churn_score":0,"cluster_id":"ftc-5e38e632","similarity_score":0.4535,"corridor_strength":0,"attractor_ratio":0,"synergy_score":0,"building_intensity_score":0.0025,"microblock_activity":0.0006,"macroblock_activity":0.0004,"walkability_score":0,"flow_direction_score":0,"anchor_decay_score":0,"poi_freshness_score":0,"competitor_viability_score":0.1266,"day_night_ratio":1,"worker_population_headcount":22.2,"worker_population_estimate":22.2,"worker_population_source":"proxy","worker_population_summary":"HC|src=proxy|band=small|est=22|conf=0.500|sig=2","worker_population_hash":"3ef3c09bfcadf34fd320ac40590b23ad","headcount_final_estimate":22.2,"headcount_confidence":0.5,"headcount_sources_used":2,"is_scraped":false,"residential_density_score":0.2531,"residential_density_confidence":0.9,"residential_density_source":"structured","residential_density_summary":"Residential demand low; src=structured; pop/km2=980.0; dwell/km2=406.7; mixed_use=no; uplift=0.94; score=0.253","residential_density_hash":"739ac8085f7b6404953f32805b74efe0","residential_density_uplift_factor":0.939,"residential_meshblock_population":441,"residential_meshblock_dwellings":183,"residential_population_density_km2":980,"residential_dwelling_density_km2":406.66666666666663,"residential_cluster_count_300m":0,"residential_mixed_use_signal":false,"residential_inferred":false,"headcount_derived":20.85,"meshblock_id":"leigh","is_sponsored":false,"ai_overview_html":null,"cached_region_slug":"matakana","cached_suburb_slug":"leigh","cached_industry_slug":"investment-residential-property","cached_business_slug":"-9429045859281","gst_status":"Active","is_maori_business":false,"distance_meters":0.00089712},{"id":"13176","nzbn":"9429031332316","company_name":"No trading name","address_line_1":"Po Box 69","address_line_2":"Matakana","address_line_3":"Matakana","address_line_4":null,"address_postcode":"0948","address_country":"NEW ZEALAND","nzbn_address":"po box 69 matakana matakana","authoritative_address":"po box 69 matakana matakana","latitude":-37.5600501,"longitude":176.06314581015363,"latlon":"0101000020E6100000A8AF5C4A050266408ECFBFB8AFC742C0","match_score":null,"merged_at":"2026-03-05T19:30:48.722Z","address_paf_id":"6007987","address_care_of":null,"industry_code":"K641965","industry_desc":"Trustee service","website":"no website","email":null,"phone":null,"entity_status":"Registered","entity_type":"LTD","start_date":"02/11/2010","end_date":null,"directors":["Robert Bruce GIBSON"],"metadata":{"nzbn":"9429031332316","type":"POSTAL","address_1":"Po Box 69","address_2":"Matakana","address_3":"Matakana","address_4":"","start_date":"30/04/2020","entity_name":"OBT LIMITED","address_paf_id":"6007987","address_care_of":"","address_country":"NEW ZEALAND","address_postcode":"0948"},"source_file":"table:nzbn_matching_stage_with_alias","source_timestamp":"2026-03-20T18:50:48.643Z","source_of_address":"nzbn","source_of_coordinates":"geocode_enrich","source_of_industry":"historical","last_enriched_at":"2026-06-06T18:20:52.440Z","last_source_update_at":"2026-03-20T18:50:48.643Z","entity_name":"OBT LIMITED","trading_name":"","source_last_updated_at":"2026-03-20T18:50:48.643Z","address_suburb":"Matakana","address_city":"Matakana","address_full":"po box 69 matakana matakana","industry_description":"Trustee service","website_verified":"not_valid","website_url":"no website","competitor_flags":{"source":"vendz.site_scores","site_score":0,"total_pois":0,"competitors":0,"positive_pois":0},"change_status":"updated","created_at":"2026-03-05T19:30:50.000Z","updated_at":"2026-06-06T18:20:52.440Z","stage5_run_id":"2779","change_fingerprint":"511422b97376d5214f9c9fc5828a1b5f","address_hash":"f6f88f0f3ee585db032e56ed169b2c33","coordinate_hash":"0a8219abd60fdefc3db14aaf0cb5e58d","ready_for_scoring":true,"industry_confidence":"0.800","column_lineage":null,"src_raw_payload":null,"src_hash_key":"c652f1ec607391c8ef6c57d859847aa8","src_exact_address_key":"po box 69 matakana matakana","src_norm_address_key":"pobox69matakanamatakana","src_norm_address_nopc_key":"pobox69matakanamatakana","src_canonical_address_key":"pobox69matakanamatakana","src_street_number_key":null,"src_house_number_key":null,"src_number_key":null,"src_unit_key":null,"src_level_key":null,"src_rd_key":null,"src_is_rural":false,"src_is_po_box":true,"src_is_private_bag":false,"src_po_box_key":"69","src_private_bag_key":null,"src_suburb_key":"matakana","src_street_key":null,"src_street_name_key":"pobox69matakanamatakana","src_postcode_key":"0948","src_has_unit":false,"src_has_number":false,"src_is_incomplete":true,"src_quality_score":0.5,"src_source_batch_id":null,"src_schema_version":null,"src_cleaning_rules_version":null,"src_email_is_valid":null,"src_phone_is_valid":null,"src_website_is_valid":null,"src_data_quality_score":null,"src_missing_field_count":null,"src_invalid_field_count":null,"src_duplicate_across_files":false,"src_is_valid_record":true,"src_error_bucket":null,"src_error_details":null,"src_clean_company_name":"9429031332316","src_clean_address_text":"po box 69 matakana matakana","src_clean_street":null,"src_clean_house_number":null,"src_clean_unit":null,"src_clean_suburb":"matakana","src_clean_postcode":"0948","src_is_rural_delivery":false,"src_address_quality_score":0.6,"src_contact_quality_score":0,"src_cleaned_at":"2026-03-20T18:50:50.996Z","linz_match_id":null,"linz_matched_address":null,"linz_raw_match_score":null,"linz_raw_latitude":null,"linz_raw_longitude":null,"linz_nominatim_latitude":null,"linz_nominatim_longitude":null,"linz_nominatim_confidence":null,"linz_distance_meters":null,"linz_nominatim_display_name":null,"linz_geocode_duration_ms":null,"linz_match_gid":null,"linz_match_confidence":null,"linz_match_method":"no_match","linz_matcher":"no_match","linz_attempted_methods":[{"method":"sql_native","status":"no_match","linz_score":0},{"method":"linz_enhanced","status":"no_match","linz_score":0},{"method":"no_match","status":"selected"}],"linz_attempted_methods_count":3,"linz_match_tokens":"{\"po box 69 matakana matakana obt limited\"}","linz_deterministic_match_key":"7b49772803f6fa96140b49c2b084ac4b","linz_match_tier":2,"linz_match_confidence_category":null,"linz_score_explanation":{"summary":"No match found","provider":null,"match_tier":2,"match_score":null,"match_method":"no_match","attempted_methods_count":3},"linz_match_mode":"strict","ovp_total_pois":"0","ovp_positive_pois":"0","ovp_competitors":"0","ovp_site_score":"0","ovp_building":null,"ovp_building_levels":null,"ovp_building_height":null,"ovp_landuse":null,"active":"true","address_clean":"po box 69 matakana matakana","address_raw":"po box 69 matakana matakana","first_seen_at":null,"last_seen_at":"2026-03-21 07:50:50.996208+13","last_updated_at":"2026-03-21 06:51:41.826651+13","opening_hours_text":null,"opening_hours_normalised":"Mon 09:00-17:00; Tue 09:00-17:00; Wed 09:00-17:00; Thu 09:00-17:00; Fri 09:00-17:00; Sat closed; Sun closed","opening_hours_source":"template","opening_hours_status":"template","opening_hours_confidence":0.3,"opening_hours_summary":"Mon 09:00-17:00; Tue 09:00-17:00; Wed 09:00-17:00; Thu 09:00-17:00; Fri 09:00-17:00; Sat closed; Sun closed","opening_hours_hash":"a3418d54492e84738b42ca71cb76b9ec","geocode_confidence":null,"industry_keywords":null,"name_tokens":"{\"legal\": \"obt limited\", \"tokens\": [\"obt\"], \"trading\": \"obt\", \"short_form\": null}","poi_context":null,"postcode_valid":"true","provenance_meta":"{\"source_file\": \"companies_public_address.csv\"}","road_class":null,"street_expanded":null,"suburb_boundary_flag":null,"address_graph":"{\"suburb\": \"matakana\", \"postcode\": \"0948\", \"address_norm\": \"po box 69 matakana matakana\"}","address_type":"po_box","address_variants":"[\"po box 69 matakana matakana\"]","address_variants_conf":"{\"po box 69 matakana matakana\": 1.0}","category_hint":null,"cleanliness_audit":"{\"dup_score\": true, \"road_class\": false, \"enhanced_at\": \"2026-03-20T18:30:56Z\", \"name_tokens\": true, \"poi_context\": false, \"address_type\": true, \"address_graph\": true, \"category_hint\": false, \"domain_present\": false, \"postcode_valid\": true, \"provenance_meta\": true, \"street_expanded\": false, \"address_variants\": true, \"address_ambiguity\": false, \"industry_keywords\": false, \"geocode_confidence\": false, \"address_hash_stable\": true, \"suburb_boundary_flag\": false, \"address_quality_score\": true, \"address_variants_conf\": true}","domain_present":null,"dup_score":"0.3","flags":null,"website_phone_source":null,"website_phone_hash":null,"last_contact_enriched_at":null,"nz_addr_lat":null,"nz_addr_lon":null,"nz_addr_suburb":null,"nz_addr_district":null,"nz_addr_region":null,"nz_addr_verified":null,"nz_addr_confidence":null,"nz_addr_source":null,"nz_addr_hash":null,"last_nz_addr_verified_at":null,"ready_for_scoring_reason_code":"ready","website_canonical":null,"has_website":false,"has_phone":false,"has_email":false,"outreach_score":5,"phone_quality":"missing","address_confidence":null,"website_dup_count":0,"industry_group":"Trustee service","address_normalisation_issue":null,"enrichment_geocode_updated_at":"2026-04-17T21:04:59.075Z","enrichment_overpass_updated_at":null,"enrichment_contact_updated_at":null,"source_updated_at_nzbn":"2026-03-20T18:50:48.643Z","source_updated_at_linz":"2026-03-20T18:50:48.643Z","source_updated_at_overpass":null,"linkedin_url":null,"cluster_key":"-37.5601,176.0631","anchor_business_score":0,"anchor_business_confidence":0.71,"anchor_business_source":"structured","anchor_business_summary":"ANCHOR|src=structured|c500=0|c1k=0|near=8660.8|super=0|gym=0|school=0|hosp=0|retail=0|score=0.0","anchor_business_hash":"5e20575e88bfb1d09f4bcb2be0cdb68b","anchor_business_count_500m":0,"anchor_business_count_1km":0,"anchor_business_nearest_m":8660.76199227,"anchor_supermarket_count_1km":0,"anchor_gym_count_1km":0,"anchor_school_count_1km":0,"anchor_hospital_count_1km":0,"anchor_retail_centre_count_1km":0,"location":"0101000020E6100000A8AF5C4A050266408ECFBFB8AFC742C0","transit_accessibility_score":0,"transit_accessibility_confidence":0,"transit_accessibility_source":"missing","transit_accessibility_summary":"TRANSIT|src=missing|bus=0|train=0|ferry=0|parkride=0|score=0.0|conf=0.00","transit_accessibility_hash":"8a7b8ede68df9173c6c88778b3ad3bec","transit_nearest_bus_stop_m":null,"transit_nearest_train_station_m":null,"transit_nearest_ferry_terminal_m":null,"transit_park_ride_count_1km":0,"transit_bus_stop_count_1km":0,"transit_train_station_count_1km":0,"transit_ferry_terminal_count_1km":0,"transit_stop_count_300m":0,"transit_stop_count_500m":0,"transit_stop_count_1km":0,"building_footprint_area_sqm":220,"building_levels":null,"building_use":"unknown_fallback","landuse_category":"unknown_fallback","landuse_area_sqm":null,"building_landuse_score":0.5462,"building_landuse_confidence":0.5973,"building_landuse_source":"inferred","building_landuse_summary":"BLD-LU|src=inferred|area=220|levels=n/a|bld=unknown_fallback|land=unknown_fallback|inf=building_type+default_landuse|score=0.546","building_landuse_hash":"8c359575297608180427cf727b9b5378","source_run_id":"a11c5ec18df6","company_website":null,"last_advanced_enriched_at":null,"h3_res7":"87bb56180ffffff","h3_res8":"88bb561855fffff","h3_res9":"89bb561854bffff","foot_traffic_score":2.66,"foot_traffic_density":"low","foot_traffic_confidence":0.194,"foot_traffic_source":"missing","foot_traffic_summary":"FOOT_TRAFFIC|src=missing|poi50=0|anchor=0.00|transit=0.00|score01=0.027|conf=0.19","foot_traffic_hash":"ded71eb6c439997f86ade1cd61a7cf59","foot_traffic_is_inferred":true,"foot_traffic_provenance":{"density":"low","score01":0.0266,"features":{"cluster_id":"ftc-5e38e632","building_area":45,"is_multi_unit":false,"synergy_score":0,"attractor_ratio":0,"day_night_ratio":1,"poi_density_50m":0,"poi_density_100m":0,"poi_density_200m":0,"similarity_score":0.4535,"street_closeness":0,"transit_distance":null,"corridor_strength":0,"event_venue_score":0,"walkability_score":0,"anchor_decay_score":0,"competitor_density":0,"street_betweenness":0,"building_usage_type":"other","competitor_distance":null,"has_pedestrian_path":false,"macroblock_activity":0.0004,"microblock_activity":0.0006,"poi_churn_intensity":0,"poi_diversity_index":0,"poi_freshness_score":0,"anchor_gravity_score":0,"flow_direction_score":0,"intersection_density":0,"transit_stop_density":0,"retail_frontage_length":4.02,"school_proximity_score":0,"weekend_activity_score":0,"opening_hours_intensity":0,"transit_frequency_score":0,"building_intensity_score":0.0025,"essential_services_score":0,"poi_temporal_churn_score":0,"hospitality_cluster_score":0,"competitor_viability_score":0.1266},"ft_count":0,"confidence":0.194,"source_type":"missing","nearest_ft_m":null,"ovp_positive":0,"ovp_site_score":0},"anchor_gravity_score":0,"poi_churn_intensity":0,"poi_density_50m":0,"poi_density_100m":0,"poi_density_200m":0,"poi_diversity_index":0,"competitor_density":0,"competitor_distance":null,"street_betweenness":0,"street_closeness":0,"has_pedestrian_path":false,"intersection_density":0,"building_area":45,"building_usage_type":"other","is_multi_unit":false,"retail_frontage_length":4.02,"transit_distance":null,"transit_stop_density":0,"transit_frequency_score":0,"opening_hours_intensity":0,"weekend_activity_score":0,"school_proximity_score":0,"hospitality_cluster_score":0,"essential_services_score":0,"event_venue_score":0,"poi_temporal_churn_score":0,"cluster_id":"ftc-5e38e632","similarity_score":0.4535,"corridor_strength":0,"attractor_ratio":0,"synergy_score":0,"building_intensity_score":0.0025,"microblock_activity":0.0006,"macroblock_activity":0.0004,"walkability_score":0,"flow_direction_score":0,"anchor_decay_score":0,"poi_freshness_score":0,"competitor_viability_score":0.1266,"day_night_ratio":1,"worker_population_headcount":22.2,"worker_population_estimate":22.2,"worker_population_source":"proxy","worker_population_summary":"HC|src=proxy|band=small|est=22|conf=0.500|sig=2","worker_population_hash":"3ef3c09bfcadf34fd320ac40590b23ad","headcount_final_estimate":22.2,"headcount_confidence":0.5,"headcount_sources_used":2,"is_scraped":false,"residential_density_score":0.1684,"residential_density_confidence":0.9,"residential_density_source":"structured","residential_density_summary":"Residential demand low; src=structured; pop/km2=640.0; dwell/km2=253.3; mixed_use=no; uplift=0.89; score=0.168","residential_density_hash":"60960dddd7a0bc41024e2860dbf437cb","residential_density_uplift_factor":0.893,"residential_meshblock_population":288,"residential_meshblock_dwellings":114,"residential_population_density_km2":640,"residential_dwelling_density_km2":253.33333333333331,"residential_cluster_count_300m":0,"residential_mixed_use_signal":false,"residential_inferred":false,"headcount_derived":19.82,"meshblock_id":"matakana","is_sponsored":false,"ai_overview_html":"\nOBT LIMITED is positioned in Matakana, a rural region with limited commercial activity, offering an opportunity for expansion into niche sectors.\n
\n\nThe company's calculated spatial opportunity score of 65/100 indicates moderate potential for growth due to its proximity to Auckland and the Matakana Corridor's increasing demand for logistics and industrial space.
\n\nCompared to the local market density of 0 competitors within 5km, OBT LIMITED offers a unique opportunity for differentiation in a relatively underserved region.
\n\nThe company's digital presence score of 50/100 suggests limited online engagement, hindering its ability to effectively promote its services and establish brand awareness in the area.
","cached_region_slug":"matakana","cached_suburb_slug":"matakana","cached_industry_slug":"trustee-service","cached_business_slug":"-9429031332316","gst_status":"Active","is_maori_business":false,"distance_meters":0.00089712}];