[OSGeo Africa] Erven in Cape Town

Kristin Botes kristin.botes at gmail.com
Tue Oct 28 02:31:20 PDT 2014


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
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20141028/65e8afaa/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Allotments.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 12306 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20141028/65e8afaa/attachment-0001.xlsx>


More information about the Africa mailing list