TREE

Tree Inventory

Field Name	Caption	Mask	Description	Field Type
TR_ACT_CD	Activity	nnn	Activity Code	Integer
TR_ACT_TY	Activity Text	25x	Activity Text	Text
TR_AD_CD	Approved/Deny	nnn	Approved/Deny	Integer
TR_AD_TY	Approved/Deny Text	25x	Approved/Deny Text	Text
TR_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
TR_ADR_B22	Street Post Bldg No 2	8x	Street Post Building No 2	Text
TR_ADR_BDG	Address	nnnnnn	Address	Long Integer
TR_ADR_DIR	Street Direction	2x	Street Direction	Text
TR_ADR_PT	Street Prefix Type	5x	Street Prefix Type	Text
TR_ADR_SFX	Street Suffix	5x	Street Suffix	Text
TR_ADR_STR	Street Name	50x	Street Name	Text
TR_ADR_TY	Street Type	5x	Street Type	Text
TR_ADR2_PT	Street 2 Prefix Type	5x	Street 2 Prefix Type	Text
TR_ADRDIR2	Cross Street	2x	Cross Street	Text
TR_ADRSFX2	Street Suffix 2	5x	Street Suffix 2	Text
TR_ADRSTR2	Street Name 2	50x	Street Name 2	Text
TR_ADRTY2	Street Type 2	5x	Street Type 2	Text
TR_AGE	Age	nnnn.nn	Age	Double
TR_APPEAL	Appealed		Appealed	Boolean
TR_APPL_DT	Appeal Date	mm/dd/yyyy	Appealed Date	Date/Time
TR_AREA	LA Area	nnnnn.nn	LA Area	Double
TR_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
TR_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
TR_BR_CD	Default WO Cat	10x	Category	Text
TR_BR_TY	Default WO Cat Text	60x	Category Text	Text
TR_BRACECD	Bracing Type	nnn	Bracing Type	Integer
TR_BRACETY	Bracing Type Text	25x	Bracing Type Text	Text
TR_CC_ID	Circuit #	nnnnnnnn	Link to ELCIRCT.CC_ID	Long Integer
TR_CLEARCD	Clearance	nnn	Clearance	Integer
TR_CLEARTY	Clearance Text	25x	Clearance Text	Text
TR_CN_ID	Conduit #	nnnnnnnn	Link to SMVCONDT.CN_ID	Long Integer
TR_CODE	Tree Code	20x	Tree Code	Text
TR_COMMON	Common Name	75x	Common Name	Text
TR_COND_CD	Tree Condition	nnn	Tree Condition	Integer
TR_COND_TY	Tree Condition Text	25x	Tree Condition Text	Text
TR_COST	Cost	nnnnnn.nn	Cost	Double
TR_COUN_DT	Council Approved	mm/dd/yyyy	Council Approved	Date/Time
TR_CRT_BY	Created By	25x	Created By	Text
TR_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
TR_CSHAP_CD	Canopy Shape	nnn	Canopy Shape	Integer
TR_CSHAP_TY	Canopy Shape Text	25x	Canopy Shape Text	Text
TR_CULTIVR	Cultivar	30x	Cultivar	Text
TR_DESIGCD	Designation	nnn	Designation	Integer
TR_DESIGTY	Designation Text	25x	Designation Text	Text
TR_DIA	Trunk Dia	nnn.n	Trunk Dia	Double
TR_DIA_LA	LA Diameter	nnnn.n	LA Diameter	Double
TR_DN_ID	Storm Detention Basin #	nnnnnnnn	Link to SMVDBASN.DN_ID	Long Integer
TR_DOC_FLG	Document Available		Document Available	Boolean
TR_ELEV	Ground Elevation	nnnnn.nn	Ground Elevation	Double
TR_FAC_CD	City	nnn	Facility	Integer
TR_FAC_TY	City Text	50x	Facility Text	Text
TR_FASSET	Fixed Asset ID	nnnnnnnn	Fixed Asset ID	Long Integer
TR_FEEWVD	Fee Waived		Fee Waived	Boolean
TR_GENUS	Genus	50x	Genus	Text
TR_GPS	GPS Flag		GPS Flag	Boolean
TR_GRID	Grid Location	10x	Grid Location	Text
TR_HEIGHT	Height	nnn.n	Height	Double
TR_ID	Tree Rec #	nnnnnnnn	Tree No.	Long Integer
TR_IFREQ	Inspection Freq	nnn	Inspection Freq	Integer
TR_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Integer
TR_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
TR_IMG_FLG			Image Available	Boolean
TR_INMAP	In Map Flag		In Map Flag	Boolean
TR_INSP_DT	Last Inspection	mm/dd/yyyy	Last Inspection	Date/Time
TR_LAND_CD	Landscaping	nnn	Landscaping	Integer
TR_LAND_TY	Landscaping Type	25x	Landscaping Type	Text
TR_LAWN_CD	Lawn Width	nnn	Lawn Width	Integer
TR_LAWN_TY	Lawn Width Text	25x	Lawn Width Text	Text
TR_LENGTH	LA Length	nnnn.n	LA Length	Double
TR_LOC_CD	Location	nnn	Location	Integer
TR_LOC_TY	Location Text	25x	Location Text	Text
TR_LOCATION	Gen. Location	100x	Location	Text
TR_LWOT_DT	Last WO Task Date	mm/dd/yyyy	Last WO Task Date	DateTime
TR_MAIN_CD	Maintenance	nnn	Maintenance	Integer
TR_MAIN_TY	Maintenance Type	25x	Maintenance Type	Text
TR_MAPNO	Map Number	30x	Map No	Text
TR_MOD_BY	Last Modified By	25x	Last Modified By	Text
TR_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
TR_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
TR_MOTION	Motion	250x	Motion	Text
TR_MOV_FLG			Movie Available	Boolean
TR_MOVE_CD	Moved By	nnn	Moved By	Integer
TR_MOVE_TY	Moved By Text	25x	Moved By Text	Text
TR_MTG_DT	Commission Mtg	mm/dd/yyyy	Commission Mtg	Date/Time
TR_MULCHCD	Mulch Type	nnnn	Mulch Type	Integer
TR_MULCHTY	Mulch Type Text	25x	Mulch Type Text	Text
TR_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
TR_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
TR_NOWORK	No WO/PM/Req		No WO/PM/Req	Boolean
TR_NUM	Alt Tree ID	20x	Alt Tree ID	Text
TR_NXTINSP	Next Inspection	mm/dd/yyyy	Next Inspection	Date/Time
TR_OTRR_CD	Risk Assessment Overall Rating		Risk Assessment Overall Rating	Small Integer
TR_OTRR_TY	Risk Assessment Overall Rating Text	25x	Risk Assessment Overall Rating Text	String
TR_OWN_CD	Owner	nnn	Owner	Integer
TR_OWN_TY	Owner Type	25x	Owner Type	Text
TR_PASSED	Motion Passed	30x	Motion Passed	Text
TR_PG_ID	Parking Lot Rec #	nnnnnnnn	Link to PKPGLOT.PG_ID	Long Integer
TR_PK_ID	Park Rec #	nnnnnnnn	Link to PKPARK.PK_ID	Long Integer
TR_PLANT_DT	Date Planted	mm/dd/yyyy	Date Planted	Date/Time
TR_PLANTDIA	Planted Dia	nnn.n	Planted Dia	Double
TR_PLNTLCD	Plant Loc	nnn	Plant Loc	Integer
TR_PLNTLTY	Plant Loc Text	25x	Plant Loc Text	Text
TR_PREVNUM	Previous Tree #	nnnnnnnn	Previous Tree #	Long Integer
TR_PRIORS	Prior Submittal		Prior Submittal	Boolean
TR_PROPTAG	Property ID Tag	52x	Property ID Tag	Text
TR_RAIFREQ	Risk Assessment Inspection Frequency		Risk Assessment Inspection Frequency	Small Integer
TR_RAIFREQ_CD	Risk Assessment Inspection Frequency Units		Risk Assessment Inspection Frequency Units	Small Integer
TR_RAIFREQ_TY	Risk Assessment Inspection Frequency Text	25x	Risk Assessment Inspection Frequency Text	String
TR_RAINSP_DT	Risk Assessment Inspection Date	mm/dd/yyyy hh:mm am	Risk Assessment Inspection Date	DateTime
TR_RANEXT_DT	Risk Assessment Next Inspection Date	mm/dd/yyyy hh:mm am	Risk Assessment Next Inspection Date	DateTime
TR_REAS_CD	Request Reason	nnn	Request Reason	Integer
TR_REAS_TY	Request Reason Text	25x	Request Reason Text	Text
TR_RECPT	Receipt #	30x	Receipt #	Text
TR_REM_DT	Removal Date	mm/dd/yyyy	Removal Date	Date/Time
TR_ROWVER			Rowversion for optimistic locking	Date/Time
TR_SECD_CD	Seconded By	nnn	Seconded By	Integer
TR_SECD_TY	Seconded By Text	25x	Seconded By Text	Text
TR_SIDE	Street Side	10x	Street Side	Text
TR_SN_COM	Segment ID	20x	Segment Common ID	Text
TR_SN_ID	Street Rec #		Link to STNET.SN_ID	Long Integer
TR_SN1_ID	Structure #	nnnnnnnn	Link to SMVSTRUC.SN_ID	Long Integer
TR_SPECIES	Species	30x	Species	Text
TR_SPREAD	Crown Spread	nnn.n	Crown Spread	Double
TR_SPRINKC	Sprinkler System	nnn	Sprinkler System	Integer
TR_SPRINKT	Sprinkler Sys Text	25x	Sprinkler System Type	Text
TR_STAKECD	Stake Type	nnn	Stake Type	Integer
TR_STAKETY	Stake Type Text	25x	Stake Type Text	Text
TR_STAT_CD	Status	nnn	Status	Integer
TR_STAT_TY	Status Text	25x	Status Text	Text
TR_STYPE_CD	Sub Type	nnn	Sub Type	Integer
TR_STYPE_TY	GIS Sub Type	25x	Sub Type Text	Text
TR_SW_ID	Sidewalk #	nnnnnnnn	Link to STSWINV.SW_ID	Long Integer
TR_SWAT_DT	Watch Date	mm/dd/yyyy	Watch Date	Date/Time
TR_SWATCH	On Special Watch		On Special Watch	Boolean
TR_THEIGHT	Trunk Height	-nnnnnnnn.nn	Trunk Height	Double
TR_TYPE_CD	Tree Type	nnn	Tree Type	Integer
TR_TYPE_TY	Tree Type Text	25x	Tree Type Text	Text
TR_TZ_ID	Tree Code Rec #		Link to Tree Code	Long Integer
TR_USER1CD	User 1	nnn	User 1	Integer
TR_USER1TY	User 1 Text	25x	User 1 Text	Text
TR_USER2CD	User 2	nnn	User 2	Integer
TR_USER2TY	User 2 Text	25x	User 2 Text	Text
TR_USER3CD	User 3	nnn	User 3	Integer
TR_USER3TY	User 3 Text	25x	User 3 Text	Text
TR_USER4	User 4	30x	User 4	Text
TR_USER5	User 5	30x	User 5	Text
TR_USER6	User 6	30x	User 6	Text
TR_USER7	User 7	-nnnnnnnn.nn	User 7	Double
TR_USER8	User 8	-nnnnnnnn.nn	User 8	Double
TR_USER9	User 9	-nnnnnnnn.nn	User 9	Double
TR_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
TR_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
TR_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
TR_USER13	User 13		User 13	Boolean
TR_USER14	User 14		User 14	Boolean
TR_USER15	User 15		User 15	Boolean
TR_USER16CD	User 16	nnn	User 16	Integer
TR_USER16TY	User 16 Text	50x	User 16 Text	String
TR_USER17CD	User 17	nnn	User 17	Integer
TR_USER17TY	User 17 Text	50x	User 17 Text	String
TR_USER18CD	User 18	nnn	User 18	Integer
TR_USER18TY	User 18 Text	50x	User 18 Text	String
TR_USER19CD	User 19	nnn	User 19	Integer
TR_USER19TY	User 19 Text	50x	User 19 Text	String
TR_USER20CD	User 20	nnn	User 20	Integer
TR_USER20TY	User 20 Text	50x	User 20 Text	String
TR_USER21	User 21	50x	User 21	String
TR_USER22	User 22	50x	User 22	String
TR_USER23	User 23	50x	User 23	String
TR_USER24	User 24	50x	User 24	String
TR_USER25	User 25	50x	User 25	String
TR_USER26	User 26	nnnnnnnn.nn	User 26	Double
TR_USER27	User 27	nnnnnnnn.nn	User 27	Double
TR_USER28	User 28	nnnnnnnn.nn	User 28	Double
TR_USER29	User 29	nnnnnnnn.nn	User 29	Double
TR_USER30	User 30	nnnnnnnn.nn	User 30	Double
TR_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
TR_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
TR_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
TR_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
TR_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
TR_USER36	User 36		User 36	Boolean
TR_USER37	User 37		User 37	Boolean
TR_USER38	User 38		User 38	Boolean
TR_USER39	User 39		User 39	Boolean
TR_USER40	User 40		User 40	Boolean
TR_UUTILCD	UG Utility	nnn	UG Utility	Integer
TR_UUTILTY	UG Utility Text	25x	UG Utility Text	Text
TR_VALUE	Tree Value	nnnn.	Tree Value	Double
TR_WEED_CD	Weed Control	nnn	Weed Control	Integer
TR_WEED_TY	Weed Control Type	25x	Weed Control Type	Text
TR_WHEIGHT	Wire Height	nnn.n	Wire Height	Double
TR_WIDTH	LA Width	nnn.n	LA Width	Double
TR_WIRE_CD	Overhead Wire	nnn	Overhead Wire	Integer
TR_WIRE_TY	Overhead Wire Text	25x	Overhead Wire Text	Text
TR_WO_COMM	WO Comment	255x	WO Comment	Text
TR_WPRES_CD	Wires Present	nnn	Wires Present	Integer
TR_WPRES_TY	Wires Present Text	25x	Wires Present Text	Text
TR_X	X Coordinate	-nnnnnnnnn.nnnnnnnn	X Coordinate	Double
TR_Y	Y Coordinate	-nnnnnnnnn.nnnnnnnn	Y Coordinate	Double