[OSGeo Africa] Erven in Cape Town

[Adi Eyal]

Thanks everyone for your responses. From the discussion it seems like
I might find joining the erven database with my valuations database to
be non-trivial. See an extract for the same erf in the valuations
database here: https://www.dropbox.com/s/p59qgifjeqwsvdk/valuations.csv?dl=0

Regards
Adi

On 28 October 2014 11:31, Kristin Botes <kristin.botes at gmail.com> wrote:
> Hi,
>
> Please find attached a list of the Allotment names with their codes.
>
> You can create a new field in the land parcel shapefile, e.g. Allotment Code
> Then you can calculate the Allotment Code by extracting it from the SG26 key
> with this expression: Left([SG26_CODE],8)
> You can then do an attribute join from the Land Parcels layer on the
> Allotment Code to the Allotment Code in the attached table.
>
> Hope it helps.
>
> Kind regards,
> Kristin
>
>
> On Tue, Oct 28, 2014 at 11:16 AM, Kristin Botes <kristin.botes at gmail.com>
> wrote:
>>
>> As already mentioned, the erven are unique per allotment. The first 8
>> digits of the SG Key is the allotment code.
>>
>> You can also request the Allotment / Farm layer from the City to get the
>> names of the allotments.
>>
>> The land parcels layer should also have a Legal Status field which may
>> cause a bit of overlap of parcels:
>>
>> Legal Status lookup:
>> 1 - Final Approved
>> 2 - Cancelled
>> 3 - Lapsed
>> 4 - SG Approved
>> 5 - Registered
>> 6 - History
>> 7 - Withdrawn
>> 8 - Excised
>> 9 - Confirmed
>>
>> Kind regards,
>> Kristin
>>
>> On 28 Oct 2014 10:51 AM, "E. Ndava" <erick.ndava at gmail.com> wrote:
>>>
>>> To add to it. Erven are numbered per what are called Allotments.
>>> (Pseudo-Suburbs). If the dataset you have lacks the SG codes mentioned by
>>> others. You may want to get the Allotments (spatial)  layer as well. Erven
>>> numbers are unique in an Allotment.
>>>
>>> On 28 October 2014 10:47, S Coetzer <geotech.sarel at gmail.com> wrote:
>>>>
>>>> Did you use key 21 aswell?
>>>>
>>>> On 28 Oct 2014 10:44, "Adi Eyal" <adi at burgercom.co.za> wrote:
>>>>>
>>>>> Here is an extract from the erven file for erf no 30498
>>>>>
>>>>> https://www.dropbox.com/s/f8qyz0p55ed117g/erven.csv?dl=0
>>>>>
>>>>> How would I differentiate between them? They tend to be in different
>>>>> suburbs.
>>>>>
>>>>> Adi
>>>>>
>>>>> On 28 October 2014 10:37, S Coetzer <geotech.sarel at gmail.com> wrote:
>>>>> > Hi
>>>>> >
>>>>> > Filter on parcel type
>>>>> >
>>>>> > Erf, fsrm portion, parent farm, public places....
>>>>> >
>>>>> > On 28 Oct 2014 10:33, "Adi Eyal" <adi at burgercom.co.za> wrote:
>>>>> >>
>>>>> >> Hi All
>>>>> >>
>>>>> >> Hopefully someone on this list has experience with how the City of
>>>>> >> Cape Town erven are arranged. I received a shapefile containing all
>>>>> >> erven in the City of Cape Town from City Maps. It seems that in Cape
>>>>> >> Town, erf numbers can be repeated and it is not clear how to
>>>>> >> differentiate between them.
>>>>> >>
>>>>> >> I know that this is a very vague question, let me know if there is
>>>>> >> any
>>>>> >> more information that you need to understand what I am talking
>>>>> >> about.
>>>>> >>
>>>>> >> Many thanks
>>>>> >> Adi
>>>>> >>
>>>>> >> --
>>>>> >> Adi Eyal
>>>>> >> Data Specialist
>>>>> >> phone: +27 78 014 2469
>>>>> >> skype: adieyalcas
>>>>> >> linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal
>>>>> >> _______________________________________________
>>>>> >> Africa mailing list
>>>>> >> Africa at lists.osgeo.org
>>>>> >> You can UNSUBSCRIBE at
>>>>> >> http://lists.osgeo.org/mailman/listinfo/africa
>>>>> >
>>>>> >
>>>>> > _______________________________________________
>>>>> > Africa mailing list
>>>>> > Africa at lists.osgeo.org
>>>>> > You can UNSUBSCRIBE at http://lists.osgeo.org/mailman/listinfo/africa
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Adi Eyal
>>>>> Data Specialist
>>>>> phone: +27 78 014 2469
>>>>> skype: adieyalcas
>>>>> linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal
>>>>> _______________________________________________
>>>>> Africa mailing list
>>>>> Africa at lists.osgeo.org
>>>>> You can UNSUBSCRIBE at http://lists.osgeo.org/mailman/listinfo/africa
>>>>
>>>>
>>>> _______________________________________________
>>>> Africa mailing list
>>>> Africa at lists.osgeo.org
>>>> You can UNSUBSCRIBE at http://lists.osgeo.org/mailman/listinfo/africa
>>>
>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------------------------------------------------------------
>>> Thou art my hiding place; thou shalt preserve me from trouble; thou shalt
>>> compass me about with songs of deliverance. Selah. Psalm 32:7
>>>
>>> _______________________________________________
>>> Africa mailing list
>>> Africa at lists.osgeo.org
>>> You can UNSUBSCRIBE at http://lists.osgeo.org/mailman/listinfo/africa
>
>
>
> _______________________________________________
> Africa mailing list
> Africa at lists.osgeo.org
> You can UNSUBSCRIBE at http://lists.osgeo.org/mailman/listinfo/africa



-- 
Adi Eyal
Data Specialist
phone: +27 78 014 2469
skype: adieyalcas
linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal