Buildings User Guide - Government of Ontario
Contents
1. 30 Example of a Non identifying 30 Model Diagram Relationship Symbology 30 ArcMap s Rotate function 32 List of Acronyms BUILDSCA Short Name for Building to Scale Data Class BUILDSYM Short Name for Building as Symbol Data Class GIS Geographic Information System LIO Land Information Ontario MNRF Ontario Ministry of Natural Resources and Forestry OBM Ontario Base Map OGF Ontario Geospatial Feature SDI Spatial Data Infrastructure 1 Introduction The majority of data for Building as Symbol and Building to Scale was collected during the Ontario Base Map OBM program A building is defined as a structure with permanent walls and roofed construction In Figure 1 as seen in the LIO Make a Topographic Map viewer large buildings e g apartment buildings are represented to scale while smaller buildings e g residential houses are represented as symbols Figure 1 Buildings represented to scale and as symbols in the Peterborough area For more information about the Building data classes contact sdi ontario ca 2 Objectives This guide is intended for users with a general interest in the Building as Symbol and Building to Scale LIO Data Classes The remainder of this document describes the exten2. 8 Building as Symbol BUILDSYM ino trato ttr Eme dui aie com tetro rane 8 Building to Scale 5 0000040000 0 0 8 4 Model Diagram Building as Symbol BUILDSYM Building to Scale BUILDSCA 9 E TTE 10 BUILDING AS 10 BUILDING TO SCALE TET acce tem wie teste ee tee 11 6 Links to Additional Information 16 APPENDIX A LIO Lookup Tables 17 BUILDING TYPE areis EDS 17 BUILDING TYPE 22 LOCATION ACCURACY LIST eee 27 APPENDIX B Table Key Dependency and Relationship Index 29 Lookup Table INdeEXES a 31 APPENDIX C Frequently Asked 4444242244 422 32 How do rotate a building point 32 List of Figures Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Buildings represented to scale and as symbols in the Peterborough area 7 Primary Key example accesso reb e RE eee ei ee 29 Foreign Key example Pen 29 Alternate Key example rer rrr i eee 29 Example of an Identifying Relationship
3. Ontario User Guide for Building as Symbol and Building to Scale LIO Data Classes Spatial Data Infrastructure Mapping and Information Resources Branch Corporate Management and Information Division Ministry of Natural Resources and Forestry 2015 07 29 Disclaimer This technical documentation has been prepared by Her Majesty the Queen in right of Ontario as represented by the Ministry of Natural Resources and Forestry the Ministry No warranties or representations express or implied statutory or otherwise shall apply or are being made by the Ministry with respect to the documentation its accuracy or its completeness In no event will the Ministry be liable or responsible for any lost profits loss of revenue or earnings claims by third parties or for any economic indirect special incidental consequential or exemplary damage resulting from any errors inaccuracies or omissions in this documentation and in no event will the Ministry s liability for any such errors inaccuracies or omissions on any particular claim proceeding or action exceed the actual consideration paid by the claimant involved to the Ministry for the materials to which this instructional documentation relates Save and except for the liability expressly provided for above the Ministry shall have no obligation duty or liability whatsoever in contract tort or otherwise including any liability or negligence The limitations exclusions and disc
4. Not applicable Not applicable Commercial Building A building used for commercial retail e g grocery hardware alcohol convenience stores etc Not applicable Not applicable Commercial Multi Use A building primarily used for commercial purposes including a secondary outlet e g Postal Alcohol Not applicable Not applicable Community Center A public building in which community gatherings and or sporting activities are held Not applicable Not applicable Cottage A dwelling typically in a rural or semi rural location usually for vacation use Not applicable Not applicable Courthouse A public building housing the judicial courts Not applicable Not applicable Customs Post Where travelers and vehicles crossing an international border are inspected Not applicable Not applicable Dome A building with arched roof used for storing salt or sand for road maintenance Not applicable Not applicable Education Building An institution for elementary secondary or post secondary education Not applicable Not applicable Electric Power Station A building where electricity is generated Not applicable Not applicable Financial Institution A building used for financial management e g banks credit unions investment houses Not applicable Not applicable Fire Station A building housing fire fighting equipment N
5. Not applicable Not applicable Hall A building used for public assembly Not applicable Not applicable Highway Service Centre A building which provides automotive services and restaurant facilities Not applicable Not applicable Highway Weigh Scale A complex along a highway for weighing commercial vehicles Not applicable Not applicable Hospital An institution where sick or injured people receive medical care Not applicable Not applicable Industrial Building A building for processing preserving raw materials manufacture products or produce energy outputs Not applicable Not applicable BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Library A building in which books periodicals newspapers and audio visual media are stored for loan Not applicable Not applicable Lodging Facilities A building where sleeping accommodations are rented Not applicable Not applicable Medical Centre Replaces a full service hospital in satellite communities or other area without hospital services Not applicable Not applicable Where the main offices of a municipal Municipal Hall administration are located Not applicable Not applicable A public building set aside for the exhibition of Museu natural historic artistic or scientific objects Movapplicable Not applicable Observatory A bu
6. An institution for elementary secondary or post secondary education Not applicable Not applicable Electric Power Station A building where electricity is generated Not applicable Not applicable BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Financial Institution A building used for financial management e g banks credit unions investment houses Not applicable Not applicable Fire Station A building housing fire fighting equipment Not applicable Not applicable Fish Hatchery A facility where fish are hatched under controlled conditions Not applicable Not applicable Gas and Oil Facility A structure dedicated to the production or distribution of gas and oil products Not applicable Not applicable Generic Unknown A unspecified building Not applicable Not applicable Government Federal A building operated by the Federal Government Not applicable Not applicable Government Municipal A building operated by a Municipal Government Not applicable Not applicable Government Provincial A building operated by the Provincial Government Not applicable Not applicable Grain Elevator Used for the storage of grain usually located along a railway Not applicable Not applicable Greenhouse A building covered with a transparent material in which plants are grown
7. Mandatory Short Name Description SENSITIVITY_RATIONALE VARCHAR2 50 Yes SENS RAT The primary reason for the information sensitivity classification Where Sensitivity Class NON SENSITIVE No Restriction Needed Where Sensitivity Class LOW Data Provider Agreement Protect Feature Type Protect Single Feature Legislative or Legal Reqt Other Where Sensitivity Class MEDIUM Legislative or Legal Reqt VTE Species Note For Species at Risk SAR features please use Legislative or Legal Reqt as a rationale When Other is chosen the user must describe it in RATIONALE OTHER DESCRIPTION VALID VALUES e VTE Species e Data Provider Agreement e No Restriction Needed e Protect Feature Type e Protect Single Feature Legislative or Legal Reqt e Other Column Name Column Type Mandatory Short Name Description Description of the reason s for the information classification SENS RATIONALE OTHER DESCR VARCHAR2 250 No SENS DESCR when Other a the rationale An indication as to whether a qualified employee has verified the existence of the geographic unit VERIFICATION STATUS FLG VARCHAR2 10 No VERISTT FL VALID VALUES e Verified e Unverified VERIFICATION_STATUS_DATE DATE No VERISTT DT Date that the geographic unit was verified validated Indication of whether the business effective date is an actual or estimated value B
8. STABLE ID NUMBER 13 NOT NULL TABLE BODY COLUMN 1 VARCHAR 10 NULL TABLE BODY COLUMN 2 NUMBER 22 NULL Figure 2 Primary Key example Foreign Key FK When a Primary Key from a Parent Table appears as a column in the Child Table it is referred to as a Foreign Key FK The FK may retain the same name of the Parent Table column or it may be renamed PARENT TABLE CHILD TABLE PARENT TABLE ID NUMBER 13 NOT NULL X CHILD TABLE 10 NUMBER 13 NOT NULL PARENT TABLE ID NUMBER 13 NULL FK Figure 3 Foreign Key example Alternate Key AK Alternate Keys AK are secondary unique identifiers in a Parent Table A Child Table can link to a Parent Table AK and use it as a Foreign Key FK The FK may retain the same name of the Parent Table column or it may be renamed Alternate Keys allow null values PARENT_TABLE CHILD_TABLE SSPARENT_TABLE_ID NUMBER 13 NOT NULL SS CHILD_TABLE_ID NUMBER 13 NOT NULL PARENT TABLE TYPE VARCHAR2 10 NULL AK1 1 PARENT TABLE TYPE VARCHAR2 10 NULL FK Figure 4 Alternate Key example 29 There are two relationship type options identifying and non identifying which are described below An Identifying Relationship occurs when a column from the Parent Table is added to the key section of the Child Table Though technically a Foreign Key FK in the child table it now forms part of the Primary Key PK Identifying Relationships are symbolized wi
9. A description of the building type Date time the record was created or last modified EFFECTIVE DATETIME DATE Yes EFF DATE in the source database DEFAULT SYSDATE EXPIRY DATETIME DATE No EXP DATE Date time that the record was expired from use BUILDING TYPE LIST Permissible Values BUILDING TYPE BUILDING TYPE DESCR EFFECTIVE DATETIME EXPIRY DATETIME Airport Hangar A building used to house maintain aircraft Not applicable Not applicable Airport Terminal A building used to process passengers and cargo for flight transportation Not applicable Not applicable Arena An enclosed large surface used for sporting activities Not applicable Not applicable Armoury A building used by the militia Not applicable Not applicable Barn Machinery Shed A large utility building on a farm complex Not applicable Not applicable Boathouse A building near water in which watercraft and or water related equipment is stored Not applicable Not applicable 22 BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Cabin A building in a remote or wilderness area Not applicable Not applicable City Hall A building where the principal offices of a city administration are located Not applicable Not applicable Coast Guard Station A building housing the Coast Guard administrative offices
10. DATE SHAPE NUMBER 38 No SHAPE Geometry attribute BUILDING_TO_SCALE_FT A building is defined as a structure with permanent walls and roofed construction When structures have one dimension larger than 50 metres for the 1 20000 scale and larger than 30 metres for the 1 10000 scale they are considered to be polygons Smaller structures should be considered points and entered in the Building as Symbol data class Column Name Column Type Mandatory Short Name Description Ontario Geospatial Feature identifier OGF ID A unique NUMBER mes SON numeric provincial identifier assigned to each object A general classification of a building often by use such as educational building religious building residence police BUILDING TYPE CODE VARCHAR2 30 No BLDG TYP C station hospital or fire station See table BUILDING TYPE in Appendix for list of valid values LOCATION DESCR VARCHAR2 2000 No LOC DES Description of the area or directions on how to get to the site GEOG UNIT DESCR VARCHAR2 2000 No GUNT DES Detailed description of the Geographic Unit The degree of conformity or closeness of a measurement within the database to its true value in the world LOCATION ACCURACY VARCHAR2 25 NO ACCURACY See table LOCATION ACCURACY LIST in Appendix for list of valid values Column Name Column Type Mandatory Short Name Description SENSITIVITY_CLASS VARCHAR2 15 Yes
11. G_TYPE A general classification of a building often by use such as educational building religious building residence police station hospital or fire station Column Name Column Type Mandatory Short Name Description A general classification of a building often by use such as educational building BUILDING_TYPE_CODE VARCHAR2 30 Yes BUILDING_T religious building residence police station hospital or fire station BUILDING_TYPE_DESCR VARCHAR2 100 Yes BUILDING D A description of the building type Date time the record was created or last EFFECTIVE_DATETIME DATE Yes EFF_DATE modified in the source database DEFAULT SYSDATE EXPIRY_DATETIME DATE No EXP DATE that the record was expired from BUILDING_TYPE Permissible Values BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Airport Hangar A building used to house maintain aircraft Not applicable Not applicable Airport Terminal A building used to process passengers and cargo for flight transportation Not applicable Not applicable Arena An enclosed large surface used for sporting activities Not applicable Not applicable Armoury A building used by the militia Not applicable Not applicable BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Barn Machinery Shed A large utility building on a farm complex No
12. SENS_CLASS The sensitivity ranking of the information embodied in the feature Often wide spread knowledge of the location of some rare aspect of our natural heritage will endanger it On the other hand this knowledge by some parties is also extremely important for its protection High information that is extremely sensitive and intended for use by named individuals only Refers to information that could have negative impacts on human life or health if released Currently no data classes meet this ranking Medium information that is sensitive and intended for use only by specified groups of employees and approved agents of the Crown For OLIW NRVIS refers to information where the entire data type has been flagged as sensitive i e Stick Nests for Vulnerable Threatened and Endangered VTE species Low information generally available to employees and approved agents of the Crown Refers to sensitive features within a data type not normally sensitive i e specific instances of Pileated Woodpecker Non Sensitive data and information that does not fall into any of the three sensitivity levels If disclosed will not result in any injury to individuals government or private sector institutions i e base data VALID VALUES e High e Medium e Low Non Sensitive SENSITIVITY DATE DATE Yes SENS DATE The date that the sensitivity classification was established Column Name Column Type
13. TION ACCURACY LIST BUILDING SCALE FT NUMBER 13 NOT NULL BUILDING TYPE BUILDING TYPE CODE VARCHAR2 30 NULL FK LOCATION_DESCR VARCHAR2 2000 NULL GEOG_UNIT_DESCR VARCHAR2 2000 NULL LOCATION_ACCURACY VARCHAR2 25 FK SENSITIVITY_CLASS VARCHAR2 15 NOT NULL SENSITIVITY_DATE DATE NOT NULL SENSITIVITY_RATIONALE VARCHAR2 50 NOT NULL SENS RATIONALE OTHER DESCR VARCHAR2 280 NULL VERIFICATION STATUS FLG VARCHAR2 10 NULL VERIFICATION STATUS DATE DATE NULL BUSINESS EFF DATE FLG VARCHAR2 10 NULL BUSINESS_EFFECTIVE_DATE DATE NULL BUSINESS_EXPIRY_DATE DATE NULL SYSTEM_CALCULATED_AREA NUMBER 18 3 NULL SYSTEM CALCULATED LENGTH NUMBER 18 3 NULL USER CALCULATED METRIC NUMBER 18 3 NULL GENERAL COMMENTS VARCHAR2 2000 NULL GEOMETRY UPDATE DATETIME DATE NULL EFFECTIVE DATETIME DATE NOT NULL SYSTEM DATETIME DATE NOT NULL SHAPE SDO GEOMETRY NULL 5 Data Description The main business area table s for this model can be found below Associated lookup tables will be listed in Appendix A of this document and are hyperlinked where referenced in this section BUILDING_AS_SYMBOL_FT A building is defined as a structure with permanent walls and roofed construction Small structures including buildings less than 50 square metres are not shown unless they constitute a point of orientation When structures have one dimension larger than 50 metres for the 1 20000 source scale and larger than 30 metres fo
14. USINESS EFF DATE FLG VARCHAR2 10 BUSEFFDTFL VALID VALUES e Actual e Estimated Date that the record becomes effective in relation to the BUSINESS_EFPECTIVE_DATE DATE Ne BUSLEFFZDT business i e the date MNR became aware of its existence BUSINESS EXPIRY DATE DATE No BUS EXP DT ae indicating when the record was determined to be SYSTEM CALCULATED AREA NUMBER 16 3 No SYS AREA 4 of a polygon measured square metres by the SYSTEM_CALCULATED_LENGTH NUMBER 16 3 No SYS_LENGTH ora polygon or lengit ota line The length perimeter or area of an object in metres or square USER_CALCULATED_METRIC NUMBER 16 3 No USER_CALC metres as measured or provided by the user GENERAL_COMMENTS VARCHAR2 2000 No GNL_CMT General comments Column Name Column Type Mandatory Short Name Description GEOMETRY UPDATE DATETIME DATE No GEO UPD DT Date time the geometry was created or last modified in the source database EFFECTIVE DATETIME DATE Yes EFF DATE Date time the record was created or last modified in the source database SYSTEM DATETIME DATE Yes SYS DATE Date time the record was loaded into or last modified in the LIO database SHAPE SDO GEOMETRY No SHAPE Geometry attribute 6 Links to Additional Information e Official LIO Metadata Record for Building as Symbol e Official LIO Metadata Record for Building to Scale 16 APPENDIX A LIO Lookup Tables and Values BUILDIN
15. ble Shopping Centre A building which contains a large number of individual retail outlets Not applicable Not applicable Sportsplex Provides facilities for various sporting and recreational activities Not applicable Not applicable Tobacco Kiln A permanent heated enclosure used for drying tobacco Not applicable Not applicable Trading Post A building in a remote area where goods are purchased or exchanged Not applicable Not applicable Warden Ranger Station A building housing national provincial park or forestry administrative offices Not applicable Not applicable Youth Camp An area used for commercial tourist operations with a focus on outdoor activities for youth Not applicable Not applicable 26 LOCATION_ACCURACY_LIST List of valid location accuracies Column Name Column Type Mandatory Short Name Description The accuracy of the location of the feature at an LOCATION_ACCURACY VARCHAR2 25 Yes ACCURACY OBM scale The degree of conformity or closeness of a measurement to the true value Date time the record was created or last modified in EFFECTIVE DATETIME DATE Yes EFF DATE the source database Default SYSDATE EXPIRY DATETIME DATE No EXP DATE Date time that the record was expired from use LOCATION ACCURACY LIST Permissible Values LOCATION ACCURACY EXPIRY DATETIME Not Applicable N
16. eps for using Rotation e Right click on BUILDING AS SYMBOL FT and choose Properties e Click the Symbology tab e Choose Features single symbol and assign a symbol for buildings e Click Advanced and choose Rotation e Select the Rotation field from the list e Choose Arithmetic counter clockwise rotation e Click OK Rotate x Rotate Points by Angle in this field Rotation hy Rotation Style 0 90 90 0 270 180 180 270 Geographic Arithmetic Random Minimums 0 00 Maximum 360 00 ces Figure 8 ArcMap s Rotate function 32 Version 1516 1 33
17. ilding equipped for astronomical observations Not applicable Not applicable Outbuilding An outbuilding i e garage shed outhouse Not applicable Not applicable sauna Parliament Building Where the elected or appointed members of provincial or federal governments meet and enact laws Not applicable Not applicable Penal Building A facility for confining or rehabilitating persons convicted of breaking the law Not applicable Not applicable Police Station The main offices of a local or regional police force including RCMP Not applicable Not applicable Post Office A building used or under licence by Canada Post for sending and receiving mail and or parcels Not applicable Not applicable Railway Station A building along a railway where the train stops to load and unload passengers or freight Not applicable Not applicable 20 BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Religious Building A building serving as a place of worship or residence for a religious order Not applicable Not applicable Residence A private dwelling place Not applicable Not applicable Sanatorium A building used for the care and rehabilitation of people with mental or physical disorders Not applicable Not applicable Satellite Tracking Station A building containing receiving devices to record informat
18. ion from satellites Not applicable Not applicable Senior Citizens Home A residence where care is provided to the elderly Not applicable Not applicable Sewage Plant A building primarily used for the collection and treatment of sewage Not applicable Not applicable Shopping Centre A building which contains a large number of individual retail outlets Not applicable Not applicable Sportsplex Provides facilities for various sporting and recreational activities Not applicable Not applicable Tobacco Kiln A permanent heated enclosure used for drying tobacco Not applicable Not applicable Trading Post A building in a remote area where goods are purchased or exchanged Not applicable Not applicable Warden Ranger Station A building housing national provincial park or forestry administrative offices Not applicable Not applicable 21 BUILDING_TYPE_LIST A general classification of a building often by use such as educational building religious building residence police station hospital or fire station Column Name Column Type Mandatory Short Name Description A general classification of a building often by use BUILDING_TYPE VARCHAR2 30 Yes BUILDING T such as educational building religious building residence police station hospital or fire station BUILDING TYPE DESCR VARCHAR2 100 Yes TYPE DESCR
19. laimers expressed above shall apply irrespective of the nature of any cause of action demand or action including but not limited to breach of contract negligence strict liability tort or any other legal theory and shall survive any fundamental breach or breaches Cette publication sp cialis e n est disponible qu en anglais Additional Information For more information about this document please contact Spatial Data Infrastructure at sdi ontario ca 2015 Queen s Printer for Ontario 2 Executive Summary Key Words Base Data Base Mapping Building Land Management Land Use Planning Municipal Planning OBM Ontario Base Mapping Planning Development SDI Spatial Data Infrastructure Abstract This user guide details the specifications for the Building as Symbol BUILDSYM and Building to Scale BUILDSCA Land Information Ontario LIO Data Classes Table of Contents ccc ces ee th 2 Additional RR IET 2 Executive 3 VON E REEE 3 ASIE D DN NM ERR ERE ne M MEM EM UNE 3 Fable of COnt ntS tee ke 4 List Of ONT oo otc tate E EE E 5 List of QU E 6 c e 7 2 eI M 7 3 Data Classes Building
20. law Not applicable Not applicable Police Station The main offices of a local or regional police force including RCMP Not applicable Not applicable Post Office A building used or under licence by Canada Post for sending and receiving mail and or parcels Not applicable Not applicable Railway Station A building along a railway where the train stops to load and unload passengers or freight Not applicable Not applicable Recreation Camp An area used for commercial tourist operations with a focus on outdoor activities Not applicable Not applicable Religious Building A building serving as a place of worship or residence for a religious order Not applicable Not applicable Residence A private dwelling place Not applicable Not applicable 25 BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Sanatorium A building used for the care and rehabilitation of people with mental or physical disorders Not applicable Not applicable Satellite Tracking Station A building containing receiving devices to record information from satellites Not applicable Not applicable Senior Citizens Home A residence where care is provided to the elderly Not applicable Not applicable Sewage Plant A building primarily used for the collection and treatment of sewage Not applicable Not applica
21. ot applicable Not applicable 23 BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Fish Hatchery A facility where fish are hatched under controlled conditions Not applicable Not applicable Gas and Oil Facility A structure dedicated to the production or distribution of gas and oil products Not applicable Not applicable Generic Unknown A unspecified building Not applicable Not applicable Government Federal A building operated by the Federal Government Not applicable Not applicable Government Municipal A building operated by a Municipal Government Not applicable Not applicable Government Provincial A building operated by the Provincial Government Not applicable Not applicable Grain Elevator Used for the storage of grain usually located along a railway Not applicable Not applicable Greenhouse A building covered with a transparent material in which plants are grown Not applicable Not applicable Hall A building used for public assembly Not applicable Not applicable Highway Service Centre A building which provides automotive services and restaurant facilities Not applicable Not applicable Highway Weigh Scale A complex along a highway for weighing commercial vehicles Not applicable Not applicable Hospital An institution where sick or injured peo
22. ot applicable Over 10 000 metres Not applicable Within 1 metre Not applicable Within 10 metres Not applicable Within 10 000 metres Not applicable Within 100 metres Not applicable Within 1000 metres Not applicable Within 2 metres Not applicable Within 20 metres Not applicable LOCATION_ACCURACY EXPIRY_DATETIME Within 200 metres Not applicable Within 2000 metres Not applicable Within 5 metres Not applicable Within 50 metres Not applicable Within 500 metres Not applicable Within 5000 metres Not applicable AC Accurate to 10m 2007 01 12 AP Approximate to 500m 2007 01 12 GE General to 10 000m 2007 01 12 MO Moderate to 1000m 2007 01 12 RE Reliable to 100m 2007 01 12 VA Very Accurate to 2m 2007 01 12 VG Vague to 100 000m 2007 01 12 Data Load 2007 01 12 28 APPENDIX B Table Key Dependency and Relationship Index Keys are used to link or make relationships between tables through one or more columns A Parent Table is the source of unique key columns used by a Child Table The main key types are described below Primary Key PK A Primary Key PK is a column that uniquely identifies each record in a table There can be more than one PK defined for a table when additional rules for record uniqueness are needed Primary Keys cannot contain null values TABLE
23. ple receive medical care Not applicable Not applicable Industrial Building A building for processing preserving raw materials manufacture products or produce energy outputs Not applicable Not applicable Library A building in which books periodicals newspapers and audio visual media are stored for loan Not applicable Not applicable Lodging Facilities A building where sleeping accommodations are rented Not applicable Not applicable 24 BUILDING_TYPE BUILDING_TYPE_DESCR EFFECTIVE_DATETIME EXPIRY_DATETIME Medical Centre Replaces a full service hospital in satellite communities or other area without hospital services Not applicable Not applicable Where the main offices of a municipal Municipal Hall Not applicable Not applicable A public building set aside for the exhibition of Sout natural historic artistic or scientific objects Notapplleaple Observatory A building equipped for astronomical observations Not applicable Not applicable Outbuilding garage Sued Not applicable Not applicable sauna Parliament Building Where the elected or appointed members of provincial or federal governments meet and enact laws Not applicable Not applicable Penal Building A facility for confining or rehabilitating persons convicted of breaking the
24. r the 1 10000 source scale they are considered to be polygons and entered as Building to Scale Column Name Column Type Mandatory Short Name Description OGF_ID NUMBER 13 Yes OGF_ID Ontario Geospatial Feature identifier OGF ID A unique numeric provincial identifier assigned to each object BUILDING_TYPE VARCHAR2 30 No BUILDING_T A general classification of a building often by use such as educational building religious building residence police station hospital or fire station See table BUILDING TYPE LIST in Appendix for list of valid values ROTATION NUMBER 3 Yes ROTATION Amount in degrees that the representation of the feature should be rotated with 0 representing no rotation LOCATION_ACCURACY VARCHAR2 25 No ACCURACY The degree of conformity or closeness of a measurement within the database to its true value in the world See table LOCATION ACCURACY LIST in Appendix for list of valid values GEOMETRY_UPDATE_DATETIME DATE No GEO UPD DT Date time the geometry was created or last modified in the source database Column Name Column Type Mandatory Short Name Description EFFECTIVE_DATETIME DATE Ves EFF_DATE Date time the record was created or last modified in the source database Date time the record was loaded into or last modified in the SYSTEM_DATETIME DATE Yes SYS_DATE LIO database DEFAULT SYS
25. rmissible values Note Relationship type reference is either Identifying I or Non Identifying NI Parent Table BUILDING TYPE Primary Key s BUILDING TYPE CODE Data Type VARCHAR2 30 Parent to Child Child to Parent Child Table Migrated Foreign Key Rel Type Relationship Relationship BUILDING_TO_SCALE_FT BUILDING_TYPE_CODE NI Optional 1 to many Optional 1 to1 Parent Table BUILDING TYPE LIST Primary Key s BUILDING TYPE Data Type VARCHAR2 30 Parent to Child Child to Parent Child Table Migrated Foreign Key Rel Type Relationship Relationship BUILDING AS SYMBOL FT BUILDING TYPE NI Optional 1 to many Optional 1 to1 Parent Table LOCATION ACCURACY LIST Primary Key s LOCATION ACCURACY Data Type VARCHAR2 25 Parent to Child Child to Parent Child Table Migrated Foreign Key Rel Type Relationship Relationship BUILDING AS SYMBOL FT LOCATION ACCURACY NI Optional 1 to many Optional 1 to1 BUILDING TO SCALE FT LOCATION ACCURACY NI Optional 1 to many Optional 1 to1 31 APPENDIX C Frequently Asked Questions How I rotate a building point feature ArcMap provides two options for rotation Geographic and Arithmetic Geographic rotates clockwise and has the origin at zero degrees while Arithmetic rotates counter clockwise and has the origin at ninety degrees Arithmetic will align building symbols to road features St
26. t and context of the information collected in these data classes 3 Data Classes Building Building as Symbol BUILDSYM Small structures including buildings less than 50 square metres are not shown unless they constitute a point of orientation When structures have one dimension larger than 50 metres for the 1 20 000 source scale and larger than 30 metres for the 1 10 000 source they are represented as points Building as Symbol locations are represented and maintained as point features in this data class Building to Scale BUILDSCA When structures have one dimension larger than 50 metres for the 1 20 000 scale and larger than 30 metres for the 1 10 000 scale they are represented as polygons Smaller structures should be considered points and entered in the Building as Symbol data class Building to Scale locations are represented and maintained as polygon features in this data class 4 Model Diagram Building as Symbol BUILDSYM Building to Scale BUILDSCA Model Effective Date 2012 JUN 14 Table names with _LIST suffix are lookup tables with permissible values BUILDING AS SYMBOL FT BUILDING LIST Socr ID NUMBER 13 NOT NULL BUILDING_TYPE VARCHAR2 30 NULL ROTATION NUMBER S NOT NULL LOCATION_ACCURACY VARCHAR2 25 NULL GEOMETRY_UPDATE_DATETIME DATE NULL EFFECTIVE_DATETIME DATE NOT NULL SYSTEM DATETIME DATE NOT NULL f SHAPE NUMBER 38 NULL LOCA
27. t applicable Not applicable A building near water in which watercraft and or Boathouse water related equipment is stored Not applicable Not applicable Cabin A building in a remote or wilderness area Not applicable Not applicable City Hall A building where the principal offices of a city Not applicable Not applicable administration are located Coast Guard Station A building housing the Coast Guard administrative offices Not applicable Not applicable Commercial Building A building used for commercial retail e g grocery hardware alcohol convenience stores etc Not applicable Not applicable Commercial Multi Use A building primarily used for commercial purposes including a secondary outlet e g Postal Alcohol Not applicable Not applicable Community Center A public building in which community gatherings and or sporting activities are held Not applicable Not applicable Cottage A dwelling typically in a rural or semi rural location usually for vacation use Not applicable Not applicable Courthouse A public building housing the judicial courts Not applicable Not applicable Customs Post Where travelers and vehicles crossing an international border are inspected Not applicable Not applicable Dome A building with arched roof used for storing salt or sand for road maintenance Not applicable Not applicable Education Building
28. th a solid line PARENT_TABLE CHILD_TABLE PARENT TABLE ID NUMBER 13 NOT NULL COLOUR VARCHAR S NOT NULL PARENT TABLE ID NUMBER 13 NOT NULL FK Figure 5 Example of an Identifying Relationship A Non identifying Relationship occurs when a column from the Parent Table is added to the main body of the Child Table where it is treated as a Foreign Key FK Non identifying Relationships are symbolized with a dashed line PARENT TABLE CHILD TABLE PARENT TABLE ID NUMBER 13 NOT NULL CHILD TABLE ID NUMBER 13 NOT NULL PARENT TABLE ID NUMBER 13 NOT NULL FK Figure 6 Example of a Non identifying Relationship The relationships between tables are set up with cardinality rules describing if the feature record in the Parent Table can relate to zero one or more records in the associated Child Table and vice versa These rules are symbolized in the model diagram as follows Definiton Zero or one optional 1 to 1 or more mandatory one to many 4 Nulls not allowed mandatory 1 to 1 Figure 7 Model Diagram Relationship Symbology Table The following section is an index of parent table primary keys identifying where applicable associated child table dependencies that have been implemented for the Building data classes 30 Lookup Table Indexes Where a lookup table primary key PK is used as a foreign key FK in other main business area tables in order to control pe
Download Pdf Manuals
Related Search