Here is a workspace I use to update parcel data. It is a one click operation that is executed by a workspace. It won't attach, so I'll paste it here. Key features to note are the backup of the existing table, the re registration of an access table and its deletion at the end, turning undo off and fast edit on, dropping and adding indexes other than PID (the join column), and of course, the update expressions. The SQL which selects objects with "14" as the first 2 characters of the Property ID (PID) selects only parcel regions. The table holds regions other than parcels (such as ROW regions in subdivisions and leased property for tax purposes). If your table holds mixed object types, such as Poly lines and regions, you also need to update a homogenous data set. One could also use WHERE STR(OBJ)= "REGION" or whatever object type you are updating.
************************* !Workspace !Version 600 !Charset WindowsLatin1 Register Table "X:\MAPINFO\Eq Imports\Names_Values.mdb" Type ACCESS Table "MapInfo_Update" Into "X:\MAPINFO\Eq Imports\MapInfo_Update.TAB" Open Table "Z:\MAPINFO\UNIONTWP\Parcels" As Parcels Interactive Commit Table Parcels As "Z:\MAPINFO\Eq Imports\Parcels_Backup_Before_Update.TAB" TYPE NATIVE Charset "WindowsLatin1" Open Table "Z:\MAPINFO\UNIONTWP\MapInfo_Update" As MapInfo_Update Interactive Set Window MapBasic Position (0.09375,3.3125) Units "in" Width 4.88542 Units "in" Height 1.95833 Units "in" Open Window MapBasic set table Parcels fastedit on undo off drop index Parcels (Owner) drop index Parcels (PropertyAddress) drop index Parcels (OwnerAddr01) Select * from Parcels where Left$(PID,2)="14" order by PID into PID_14 Add Column "PID_14" (Owner) From MapInfo_Update Set To Owner Where COL1 = COL1 Dynamic Add Column "PID_14" (Owner_Line_2) From MapInfo_Update Set To Owner_Line_2 Where COL1 = COL1 Dynamic Add Column "PID_14" (PropStNumber) From MapInfo_Update Set To PropStNumber Where COL1 = COL1 Dynamic Add Column "PID_14" (PropStDir) From MapInfo_Update Set To PropStDir Where COL1 = COL1 Dynamic Add Column "PID_14" (PropStreet) From MapInfo_Update Set To PropStreet Where COL1 = COL1 Dynamic Add Column "PID_14" (Apt#) From MapInfo_Update Set To Apt# Where COL1 = COL1 Dynamic Add Column "PID_14" (PropertyAddress) From MapInfo_Update Set To PropertyAddress Where COL1 = COL1 Dynamic Add Column "PID_14" (OwnerCareOf) From MapInfo_Update Set To OwnerCareOf Where COL1 = COL1 Dynamic Add Column "PID_14" (OwnerAddr01) From MapInfo_Update Set To OwnerAddr01 Where COL1 = COL1 Dynamic Add Column "PID_14" (OwnerCity) From MapInfo_Update Set To OwnerCity Where COL1 = COL1 Dynamic Add Column "PID_14" (OwnerState) From MapInfo_Update Set To OwnerState Where COL1 = COL1 Dynamic Add Column "PID_14" (OwnerZip) From MapInfo_Update Set To OwnerZip Where COL1 = COL1 Dynamic Add Column "PID_14" (Taxpayer_Name) From MapInfo_Update Set To Taxpayer_Name Where COL1 = COL1 Dynamic Add Column "PID_14" (Assessment)From MapInfo_Update Set To Assessment Where COL1 = COL1 Dynamic Add Column "PID_14" (SEV)From MapInfo_Update Set To SEV Where COL1 = COL1 Dynamic Add Column "PID_14" (Cap)From MapInfo_Update Set To Cap Where COL1 = COL1 Dynamic Add Column "PID_14" (Taxable)From MapInfo_Update Set To Taxable Where COL1 = COL1 Dynamic Add Column "PID_14" (AtlasAcres)From MapInfo_Update Set To AtlasAcres Where COL1 = COL1 Dynamic Add Column "PID_14" (DateSplit)From MapInfo_Update Set To DateSplit Where COL1 = COL1 Dynamic Add Column "PID_14" (ParentPID)From MapInfo_Update Set To ParentPID Where COL1 = COL1 Dynamic Add Column "PID_14" (ParentAcres)From MapInfo_Update Set To ParentAcres Where COL1 = COL1 Dynamic Add Column "PID_14" (Left2Split)From MapInfo_Update Set To Left2Split Where COL1 = COL1 Dynamic Add Column "PID_14" (XferRights)From MapInfo_Update Set To XferRights Where COL1 = COL1 Dynamic Add Column "PID_14" (DivUnallocated)From MapInfo_Update Set To DivUnallocated Where COL1 = COL1 Dynamic Add Column "PID_14" (UnallocatedXfer)From MapInfo_Update Set To UnallocatedXfer Where COL1 = COL1 Dynamic Add Column "PID_14" (FormDate)From MapInfo_Update Set To FormDate Where COL1 = COL1 Dynamic Add Column "PID_14" (CourtesySplit)From MapInfo_Update Set To CourtesySplit Where COL1 = COL1 Dynamic Add Column "PID_14" (Taxpayer_Care_Of)From MapInfo_Update Set To Taxpayer_Care_Of Where COL1 = COL1 Dynamic Add Column "PID_14" (Taxpayer_Street)From MapInfo_Update Set To Taxpayer_Street Where COL1 = COL1 Dynamic Add Column "PID_14" (Taxpayer_City)From MapInfo_Update Set To Taxpayer_City Where COL1 = COL1 Dynamic Add Column "PID_14" (Taxpayer_State)From MapInfo_Update Set To Taxpayer_State Where COL1 = COL1 Dynamic Add Column "PID_14" (Taxpayer_Zip)From MapInfo_Update Set To Taxpayer_Zip Where COL1 = COL1 Dynamic Add Column "PID_14" (Send_Bill_To)From MapInfo_Update Set To Send_Bill_To Where COL1 = COL1 Dynamic Add Column "PID_14" (Dt_Nm_Ch)From MapInfo_Update Set To Dt_Nm_Ch Where COL1 = COL1 Dynamic Add Column "PID_14" (Owner_Country)From MapInfo_Update Set To Owner_Country Where COL1 = COL1 Dynamic Add Column "PID_14" (Record_Updated)From MapInfo_Update Set To Record_Updated Where COL1 = COL1 Dynamic Add Column "PID_14" (RecordStatus)From MapInfo_Update Set To RecordStatus Where COL1 = COL1 Dynamic Add Column "PID_14" (SchoolDistrict)From MapInfo_Update Set To SchoolDistrict Where COL1 = COL1 Dynamic Add Column "PID_14" (PropertyClass)From MapInfo_Update Set To PropertyClass Where COL1 = COL1 Dynamic Add Column "PID_14" (HomesteadPercent)From MapInfo_Update Set To HomesteadPercent Where COL1 = COL1 Dynamic Commit Table Parcels Create Index On Parcels (Owner) Create Index On Parcels (PropertyAddress) Create Index On Parcels (OwnerAddr01) set table Parcels fastedit off undo on Drop Table MapInfo_Update ************************************** William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Lars V. Nielsen (GisPro) [mailto:[EMAIL PROTECTED] Sent: June 14, 2004 02:17 To: Pclifton Cc: [EMAIL PROTECTED] Subject: Re: MI-L Column Update--a simple solution? Hi "Pclifton", If what you want to do with a single table is described in these two steps : 1. Select * From table2Bupdated, tableWithValues Where table2Bupdated.joinColumn = tableWithValues.joinColumn 2. Update Selection set column2update = columnWithValue then I'll suggest that you add these two lines 50 times to a new text file, change the tabel/column names appropriately throughout the file (e.g. 50 different tables to update with), and insert these three lines at the very top of the file : !Workspace !Version 500 !Charset WindowsLatin1 and save the file as *.WOR. Then you can execute the 100 commands in one go by "opening" the created "workspace" file. Using a join ensures that you only update the rows that correspond to value in the updater table. Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://www.gispro.dk/ ----- Original Message ----- From: "Pclifton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 14, 2004 8:03 AM Subject: MI-L Column Update--a simple solution? > I have a table with about 10,000 unique names in Column 1, and I wish to > update data in Column 2 from about 50 other tables. The common link is the > names in Column 1. Using Update Column, the second update erases the data > from the first update, and so on. It is not feasible to concatanate the > tables, and I don't want to go through a multistep process in SQL for each > table. dBase handles this type of job with ease--what is the easy solution > in MapInfo? > > > _____________________________________________________________ > Great Basin Internet Services Webmail (http://greatbasin.net) > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 12178 > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12179 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12202
