<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Hi Adi<br>
      <br>
      Here's how to interpret the 21 digit code:
      <a class="moz-txt-link-freetext" href="http://csg.dla.gov.za/21charac.htm">http://csg.dla.gov.za/21charac.htm</a><br>
      <br>
      In an up-to-date database representing a single time and status,
      the 21 digit code must be unique per parcel. If consolidations,
      subdivisions, etc. have not been updated or if your dataset
      represents a long time period and not just the current state or
      has multiple legal statuses, you might well get duplicates. e.g.
      if you get the national parcel database from the SG office you'll
      find thousands of duplicates. <br>
      <br>
      There's only one national cadastre so City of Cape Town will
      follow the same rules and structure as any other region. <br>
      <br>
      Gavin<br>
      <br>
      On 28/10/2014 11:16, Kristin Botes wrote:<br>
    </div>
    <blockquote
cite="mid:CABuys=kWZcHY3EFS1LzZkaZTkTEQ+HZ76Ah71bVCjn7dQribrA@mail.gmail.com"
      type="cite">
      <p dir="ltr">As already mentioned, the erven are unique per
        allotment. The first 8 digits of the SG Key is the allotment
        code.</p>
      <p dir="ltr">You can also request the Allotment / Farm layer from
        the City to get the names of the allotments.</p>
      <p dir="ltr">The land parcels layer should also have a Legal
        Status field which may cause a bit of overlap of parcels:</p>
      <p dir="ltr">Legal Status lookup:<br>
        1 - Final Approved<br>
        2 - Cancelled<br>
        3 - Lapsed<br>
        4 - SG Approved<br>
        5 - Registered<br>
        6 - History<br>
        7 - Withdrawn<br>
        8 - Excised<br>
        9 - Confirmed</p>
      <p dir="ltr">Kind regards, <br>
        Kristin<br>
        <br>
      </p>
      <div class="gmail_quote">On 28 Oct 2014 10:51 AM, "E. Ndava" <<a
          moz-do-not-send="true" href="mailto:erick.ndava@gmail.com">erick.ndava@gmail.com</a>>
        wrote:<br type="attribution">
        <blockquote class="gmail_quote" style="margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex">
          <div dir="ltr">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.<br>
          </div>
          <div class="gmail_extra"><br>
            <div class="gmail_quote">On 28 October 2014 10:47, S Coetzer
              <span dir="ltr"><<a moz-do-not-send="true"
                  href="mailto:geotech.sarel@gmail.com" target="_blank">geotech.sarel@gmail.com</a>></span>
              wrote:<br>
              <blockquote class="gmail_quote" style="margin:0 0 0
                .8ex;border-left:1px #ccc solid;padding-left:1ex">
                <p dir="ltr">Did you use key 21 aswell?</p>
                <div>
                  <div>
                    <div class="gmail_quote">On 28 Oct 2014 10:44, "Adi
                      Eyal" <<a moz-do-not-send="true"
                        href="mailto:adi@burgercom.co.za"
                        target="_blank">adi@burgercom.co.za</a>>
                      wrote:<br type="attribution">
                      <blockquote class="gmail_quote" style="margin:0 0
                        0 .8ex;border-left:1px #ccc
                        solid;padding-left:1ex">Here is an extract from
                        the erven file for erf no 30498<br>
                        <br>
                        <a moz-do-not-send="true"
                          href="https://www.dropbox.com/s/f8qyz0p55ed117g/erven.csv?dl=0"
                          target="_blank">https://www.dropbox.com/s/f8qyz0p55ed117g/erven.csv?dl=0</a><br>
                        <br>
                        How would I differentiate between them? They
                        tend to be in different suburbs.<br>
                        <br>
                        Adi<br>
                        <br>
                        On 28 October 2014 10:37, S Coetzer <<a
                          moz-do-not-send="true"
                          href="mailto:geotech.sarel@gmail.com"
                          target="_blank">geotech.sarel@gmail.com</a>>
                        wrote:<br>
                        > Hi<br>
                        ><br>
                        > Filter on parcel type<br>
                        ><br>
                        > Erf, fsrm portion, parent farm, public
                        places....<br>
                        ><br>
                        > On 28 Oct 2014 10:33, "Adi Eyal" <<a
                          moz-do-not-send="true"
                          href="mailto:adi@burgercom.co.za"
                          target="_blank">adi@burgercom.co.za</a>>
                        wrote:<br>
                        >><br>
                        >> Hi All<br>
                        >><br>
                        >> Hopefully someone on this list has
                        experience with how the City of<br>
                        >> Cape Town erven are arranged. I
                        received a shapefile containing all<br>
                        >> erven in the City of Cape Town from
                        City Maps. It seems that in Cape<br>
                        >> Town, erf numbers can be repeated and
                        it is not clear how to<br>
                        >> differentiate between them.<br>
                        >><br>
                        >> I know that this is a very vague
                        question, let me know if there is any<br>
                        >> more information that you need to
                        understand what I am talking about.<br>
                        >><br>
                        >> Many thanks<br>
                        >> Adi<br>
                        >><br>
                        >> --<br>
                        >> Adi Eyal<br>
                        >> Data Specialist<br>
                        >> phone: <a moz-do-not-send="true"
                          href="tel:%2B27%2078%20014%202469"
                          value="+27780142469" target="_blank">+27 78
                          014 2469</a><br>
                        >> skype: adieyalcas<br>
                        >> linkedin: <a moz-do-not-send="true"
                          href="http://za.linkedin.com/pub/dir/Adi/Eyal"
                          target="_blank">http://za.linkedin.com/pub/dir/Adi/Eyal</a><br>
                        >>
                        _______________________________________________<br>
                        >> Africa mailing list<br>
                        >> <a moz-do-not-send="true"
                          href="mailto:Africa@lists.osgeo.org"
                          target="_blank">Africa@lists.osgeo.org</a><br>
                        >> You can UNSUBSCRIBE at <a
                          moz-do-not-send="true"
                          href="http://lists.osgeo.org/mailman/listinfo/africa"
                          target="_blank">http://lists.osgeo.org/mailman/listinfo/africa</a><br>
                        ><br>
                        ><br>
                        >
                        _______________________________________________<br>
                        > Africa mailing list<br>
                        > <a moz-do-not-send="true"
                          href="mailto:Africa@lists.osgeo.org"
                          target="_blank">Africa@lists.osgeo.org</a><br>
                        > You can UNSUBSCRIBE at <a
                          moz-do-not-send="true"
                          href="http://lists.osgeo.org/mailman/listinfo/africa"
                          target="_blank">http://lists.osgeo.org/mailman/listinfo/africa</a><br>
                        <br>
                        <br>
                        <br>
                        --<br>
                        Adi Eyal<br>
                        Data Specialist<br>
                        phone: <a moz-do-not-send="true"
                          href="tel:%2B27%2078%20014%202469"
                          value="+27780142469" target="_blank">+27 78
                          014 2469</a><br>
                        skype: adieyalcas<br>
                        linkedin: <a moz-do-not-send="true"
                          href="http://za.linkedin.com/pub/dir/Adi/Eyal"
                          target="_blank">http://za.linkedin.com/pub/dir/Adi/Eyal</a><br>
                        _______________________________________________<br>
                        Africa mailing list<br>
                        <a moz-do-not-send="true"
                          href="mailto:Africa@lists.osgeo.org"
                          target="_blank">Africa@lists.osgeo.org</a><br>
                        You can UNSUBSCRIBE at <a
                          moz-do-not-send="true"
                          href="http://lists.osgeo.org/mailman/listinfo/africa"
                          target="_blank">http://lists.osgeo.org/mailman/listinfo/africa</a><br>
                      </blockquote>
                    </div>
                  </div>
                </div>
                <br>
                _______________________________________________<br>
                Africa mailing list<br>
                <a moz-do-not-send="true"
                  href="mailto:Africa@lists.osgeo.org" target="_blank">Africa@lists.osgeo.org</a><br>
                You can UNSUBSCRIBE at <a moz-do-not-send="true"
                  href="http://lists.osgeo.org/mailman/listinfo/africa"
                  target="_blank">http://lists.osgeo.org/mailman/listinfo/africa</a><br>
              </blockquote>
            </div>
            <br>
            <br clear="all">
            <br>
            -- <br>
----------------------------------------------------------------------------------------------------------------------------------------<br>
            Thou <i>art</i> my hiding place; thou shalt preserve me
            from trouble; thou shalt compass me about with songs of
            deliverance. Selah. Psalm 32:7<br>
          </div>
          <br>
          _______________________________________________<br>
          Africa mailing list<br>
          <a moz-do-not-send="true" href="mailto:Africa@lists.osgeo.org">Africa@lists.osgeo.org</a><br>
          You can UNSUBSCRIBE at <a moz-do-not-send="true"
            href="http://lists.osgeo.org/mailman/listinfo/africa"
            target="_blank">http://lists.osgeo.org/mailman/listinfo/africa</a><br>
        </blockquote>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Africa mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Africa@lists.osgeo.org">Africa@lists.osgeo.org</a>
You can UNSUBSCRIBE at <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/africa">http://lists.osgeo.org/mailman/listinfo/africa</a></pre>
    </blockquote>
    <br>
    <br>
    <div class="moz-signature">-- <br>
      <div style="text-align:center">
------------------------------------------------------------------------------------------</div>
      <div style="text-align:center"><img
          src="cid:part21.08050504.05000101@kartoza.com" height="40"
          width="200"></div>
      <div style="text-align:center">Gavin Fleming</div>
      <div style="text-align:center"><span style="text-align:start">Visit
        </span><a href="http://kartoza.com/" style="text-align:start"
          target="_blank">http://kartoza.com</a><span
          style="text-align:start"> to find out about open source:</span><br
          style="text-align:start">
        <span style="text-align:start"> * Desktop GIS programming
          services</span><br style="text-align:start">
        <span style="text-align:start"> * Geospatial web development</span></div>
      <div style="text-align:center"><span style="text-align:start">*
          GIS Training</span></div>
      <div style="text-align:center"><span style="text-align:start">*
          Consulting Services</span></div>
      <div style="text-align:center">
        <div>Skype: phlemingo</div>
        <div style="text-align:start">
          <div style="text-align:center">-------------------------------------------------------------------------------------------</div>
          <div style="text-align:center"><span style="text-align:start">Kartoza
              = Linfiniti ∪ Afrispatial</span></div>
        </div>
      </div>
    </div>
  </body>
</html>