NOTE: WHERE WE HAVE BEEN ABLE TO IDENTIFY AN ACTUAL MANAGEMENT COMPANY IN THE "A" AND "M" RECORDS, THE MANAGEMENT COMPANY IS NOW LISTED INSTEAD OF AN INDIVIDUAL MANAGER OR COMPANY CEO'S NAME.
Twelve [12] Data Fields
Data Samples:
"PROJECT NAME","CAREOF","ADDRESS","CITY", "STATE", "ZIP","COUNTY","ADDRTYPE", "UNITS", " TELE", "MANAGEMENT TYPE"
Self-managed:
"1001 WILDER","ROBERT KUNZ","1001 WILDER AVE STE 105", "HONOLULU", "HI", "96822", "HONOLULU", "CON", "69","8085383466","SELF"
"1001 WILDER","EDWARD LAUER","1001 WILDER AVE STE 105","HONOLULU", HI", "96822", "HONOLULU","MGR", "69", "8085383466","SELF"
"1001 WILDER","JOHN WRAY","1001 WILDER AVE STE 901", "HONOLULU","HI","96822", "HONOLULU","PRES", "69","","SELF"
"1001 WILDER","","1001 WILDER AVE","HONOLULU"," HI", "96822", "HONOLULU", "PROP", "69","","SM"
Managed (MC):
"PRINCESS LEILANI","GWYN FOWLER-BUTCHKA","1580 MAKALOA ST STE 1130", "HONOLULU", "HI", "96814", "HONOLULU", "CON", "136","8089473331","MC"
"PRINCESS LEILANI","ALII OHANA PROPERTY MANAGEMENT INC","1580 MAKALOA ST STE 1130", "HONOLULU", "HI", "96814","HONOLULU","MGR","136","8089473331" ,"MC"
"PRINCESS LEILANI","LILA CHRYSTAL","1561 KANUNU ST STE 804", "HONOLULU", "HI","96814","HONOLULU","PRES","136","" ","MC"
"PRINCESS LEILANI"," ","1561 KANUNU ST","HONOLULU","HI", "96814", "HONOLULU", "PROP","136","" ","MC"
General Manager:
"KUKUI PLAZA","ALDEN KAMAUNU (GM)","1255 NUUANU AVE", "HONOLULU", "HI", "96817","HONOLULU","CON","1848","8085241255 ","GM"
"KUKUI PLAZA","ALDEN KAMAUNU (GM)","1255 NUUANU AVE", "HONOLULU", "HI", "96817","HONOLULU","MGR","1848","8085241255 ","GM"
"KUKUI PLAZA", "LORETTA POE","1255 NUUANU AVE", "HONOLULU", "HI", "96817", "HONOLULU","PRES","1848"," ","GM"
"KUKUI PLAZA", "1255 NUUANU AVE", "HONOLULU", "HI", "96817", "HONOLULU", "PROP","1848"," ","GM"
Explanation of Data Fields:
|
FIELD
|
MEANING
|
| "PROPERTY NAME" |
Property name |
| "CAREOF" |
Designates "in-care-of" corresponds to the "ADDRTYPE" (may be blank) |
| "ADDRESS" |
Street or PO mailing address corresponding to the "ADDRTYPE" |
| "CITY" |
City corresponding to the record address |
| "STATE" |
State corresponding to the record address |
| "ZIP" |
ZIP Code |
| "COUNTY" |
County location |
| "ADDRTYPE" |
Record Type Contact "CON"; Management "MGT";and Officer?Other "OFFICER/OTHER"; PROJECT INFORMATION "PROJ" |
| "TYPE OFFICER/OTHER" |
“PRES/VICE-PRES/SEC/TREAS/DEVELOPER/GM/PARTNER/SOLE OWNER |
| "UNITS" |
Number of units |
| "TELE" |
Manager Type - Self-managed "SELF"; Management Company "MCOM"; Other "OTHER" |
| "MGR TYPE" |
Date of last corporate filing (MM/DD/YYYY) |
| "TYPE" |
CONDO |
Note: Properties listed as "100% Sole-owned" are classified as Self-managed "SELF". The "Manager" may not be a management company - it may be an on-site manager, a law firm, CPA, member of the Board of Directors, etc. In those cases where the association also has an identifiable management company – we have listed the name and address of the firm in the "M" record. A designation as "self-managed " may mean the Association has an on-site manager or a Board member is acting as the agent; or the project was classified as 100% Owned or AOAO. Additionally, the president may have elected to receive all association related mail addressed, in their name, at the address of the manager, if managed. CID-DATA.COM™ has no control over this selection.
Accuracy of the Data
Our goal is to provide you the highest quality data at the most economical price. CID-DATA.COM™ data is derived from the Common Interest Developments (CIDs) submitted to the Hawaii Department of Real Estate, Association of Apartment Owners (AOAO) filings in accordance with.
CID-DATA.COM™ has no control over the following activities, which may introduce inaccuracies in the data:
- How the agent for the association completed the form.
- Whether the agent submitted the form in a timely manner.
- The address used for the President. This address may also be the agent's address, if the agent (manager) filled out the form.
- The accuracy of the data as it was entered into Department of Real Estate, Association of Apartment Owners (AOAO) master database by their data entry personnel.
- The accuracy of the data contained in Department of Real Estate, Association of Apartment Owners (AOAO master database at any given time. If fields were left blank in the submission to Department of Real Estate, Association of Apartment Owners (AOAO, then the respective field in our database may be empty.
Note: In order to provide you with the most accurate data avaulable, we have reviewed ALL entries and attempted to correct obvious inaccuracies in the original data received. We have also endeavored to locate and include any missing data.
Using the Data.
There are many uses for information contained in the CID-DATA.COM™ databases. They include: various statistical, business planning and marketing analyses; direct mail marketing - customizing your own labels, envelopes, post cards; telemarketing in conjunction with a telephone number database; etc.
Business Planning Analysis. The CID-DATA.COM™ Hawaii database identifies whether the association has a management company or is self-managed. Additionally, it provides the county corresponding to each record address and the number of housing units. Using this data, you may perform a variety of analyses depending to suit your business needs.
Direct Mail Marketing. If you are using the database for direct mail marketing - we suggest that you select the appropriate "ADDRTYPE" (CON, MGR, PRES or PROJ) that best suits your marketing requirements. While we have made every effort to help you ensure the best results for your marketing effort, based on the factors that we have no control over, we suggest you add "RETURN SERVICE REQUESTED" or "ADDRESS
Mailing Labels. We suggest that you use an 8-9 point font and a 1"x 4" label, as some association names are very long and this size label presents the best appearance. We recommend that you pre-print and review a sample of the label content, format and position on standard 8.5"x11" plain paper before printing the actual labels.
As noted, we have included the respective "COUNTY" corresponding to the "Property" address. You can sort on the "COUNTY" field and determine the number of properties currently on file for that county.
Installation Note
CID-DATA.COM ™ provides data to our clients on Compact Disc (CD) in two formats - Comma Delimited text (.csv); and in a Microsoft EXCEL (.xls) format
Compact Discs (CDs) are screened for viruses before shipping. However, we recommend you always screen for viruses when installing any CD or diskette in your computer!
Data format (.txt)
If the data file on the CD or diskette you receive has an extension of ".txt," it is a comma delimited text file, and no expansion is required in either a Windows or Macintosh environment. This data file is ready to be placed on your hard drive and then imported into the data management application program you are using.
Data Format (.xls)
We are also providing the file in an Microsoft EXCEL (.xls) format. Field names are provided in the first row of the data. Please note, later versions of EXCEL have a capability for exporting the data into Microsoft ACCESS.
Importing the Data
The "comma delimited format," allows you to import the data into virtually any database management or database (contact management) capable program you may have. The data fields in the application you are importing the data to, must match one-to-one with the eleven (11) data fields indicated on the first page of this 'help guide." Some applications will do this automatically. Please see the instructions for the particular application program you will be using. Please note, you will be able to manipulate the data to suit your various business needs in a data base management or contact management program. The data can be imported into spread sheet and word processing programs but your ability to filter, search, format, and manipulate the data may be very limited.
We recommend the use of a relational database management program such as Microsoft Access, FileMaker Pro or similar programs. These programs allow you to filter and select record data based on several parameters and have built-in layout/formatting capabilities for using the data in letters, and to print envelopes, labels, post-cards and more.
The "EXCEL (.xls)" data is ready to use and the field names are listed in the first row of the spreadsheet. Once you open the EXCEL file you may save it in any number of other formats to suite your needs.
Using the CID-DATA.COM™ Databases
After you have imported the data into your database application program, please take a moment to review and become familiar with the contents. Then review the database application program documentation to understand the capabilities of the program to sort, filter and manipulate the data for analysis or to produce labels, lists and other formats for the information that you may require.
Technical Assistance
Limited technical assistance is provided by calling 1-800-350-8333 between 9:00 AM-12:00 PM PST or by e-mailing support@cid-data.com. Instructions for importing the data files into Microsoft Access 97 are included on the CD.
USE OF THIS DATA CONSTITUTES AGREEMENT TO THE FOLLOWING CONDITIONS
Copyright
CID-DATA.COM™ - Databases are copyrighted and provided for your sole use. You may not assign, transfer, distribute, or copy and resell the data to a third party. You may not use the data, in whole or in part, as a derivative or basis for another product, without the express, written permission of CID-DATA.COM™.
Hold Harmless Notice
By using your CID-DATA.COM™ - Databases, you agree to hold CID-DATA.COM™ and all associated parties harmless for any damages in using the data or software. The data files and diskette or CD ROM are provided to you on an "as-is" basis. CID-DATA.COM™ disclaims all other warranties, either expressed or implied, including but not limited to warranties of merchantability and fitness for a particular purpose with respect to the data or accompanying written materials. CID-DATA.COM™ does not warrant or guarantee, or make any representations regarding the use or the results of the use of this product. In no event will CID-DATA.COM™, its owners, employees or agents, be liable to you for any consequential or indirect damage resulting from the use of this product.
Damaged/Unreadable CD - Policy
In the rare event you receive a damaged or unreadable CD , please return the original CD to us, so that we can determine the cause of damage, and we will provide you a replacement.