shrug-l: need help joining tables

[Rick Labs]

Katherine,

Its been a while since I worked with those files, so I may not be fully 
current.

I think the Appraisers office inserted extra "=" signs into the .csv to 
get it to format correctly on some end user's spreadsheets. Those extra 
characters impede conventional SQL/text database imports.

I ended up cleaning those out of the .csv  prior to any further processing.

Often it was easier to do all the clean up and database work outside of 
the mapping software. Excel Power BI features and conventional SQL 
worked well. Even with a modest laptop I could get all the data from 
Leon into memory.

I also noticed about 100 duplicate PropertyID records that needed to be 
tidied up before I could enforce uniqueness on that field in the 
combined (parcel shapes and appraisers data) database.

There may also be an occasional "odd" parcel shape - a large area with 
little islands chopped out, multiple areas that are non adjacent - all 
under a single  PropertyID.

...a few things to keep you on your toes, but overall very good quality 
data.

Rick



On 3/2/2020 3:48 PM, Milla, Katherine A. wrote:
> Greetings all.  I have the Leon County tax parcels shapefile I downloaded from the property appraiser's web site.  I also downloaded the sales data tables (they are in .csv format).  I cannot get them to join in ArcGIS Pro on the parcel ID.  I have tried importing to an Excel file and exporting to different formats but nothing has worked.  Any advice out there?
>
> Thanks
>
> Katherine
>
> Katherine Milla, PhD
> Center for Water Resources
> 121 Perry-Paige Hall
> Florida A&M University
> Tallhassee, FL  32307
> 850-561-2221
>
>
> _______________________________________________
> SHRUG-L mailing list
> SHRUG-L at lists.dep.state.fl.us
> http://lists.dep.state.fl.us/mailman/listinfo/shrug-l

-- 
Richard J. Labs, CFA, CPA
CL&B Capital Management, LLC
Phone: 315-637-0915
E-mail (preferred for efficiency): rick at clbcm.com
3213 Yorktown Dr, Tallahassee, FL 32312-2015
June-August: 408B Holiday Harbour, Canandaigua, NY 14424

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20200302/060399a6/attachment.html>