The Nature Conservancy TNC, NorthEast Secure land .zip file can be download here
https://tnc.app.box.com/s/xrnnprrrrhx3tmz0zi3s8o355phzihi7
 
Note:  
NorthEast secure land is from The Center for Resilient Conservation Science (CRCS) 
NorthEast secure land exclude following: 
1)  Exclude :  The Nature Conservancy TNC fee and easement ( processing separately )
                             https://www.arcgis.com/home/item.html?id=fd185c3879e84f59b2bec28e5a392cfa
2) Exclude : VT vermont, because Vermont has more detailed data in a separate feature class ( processing separately )
3) Exclude : NY New York State, because New York State data is directly from NY Heritage ( processing separately )

 
 

 
Initial FME workflow

 
 
 
Next Step : 
What field need to be standardized

 
 
 
 
 
1) Manager Name field comes from Local Manager field need standardized. Run Python Script 

Result is here, create 2 column
 
 
 
 
 
 
2) Owner Name field comes from standardized Local owner field, run this python

Result is here, create 2 column

 
 
3) Designation type comes from standardized local designation, run this python

Result is here, create 1 column
