Standard Jet DBnb` Ugr@?~1y0̝cßFNl7ӜS(!`{6`߱cCZ83y["|*|̂f_Љ$g'DeFx -bT4.0dv YXkCM@S XX Y   Y tY  Y Y  Y  uY  Y  l Y s Y n Y l Y n Y 2eY  Y  S Y  aY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OYܦ=>SWY Y Y  Y 2dACMFInheritableObjectIdSIDd/'d/'d YObjectId Yd]]SdY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -Y]]SY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship@3 dd ddd dYYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/ `R @w:}}@     @@   @  @@  @@   @@@ Wx`QJbkMdobmv^dMJmYdbSJMmdiWxfMmMdbmQbmdSkmioMmoiQqJ^oQWxiQf^JMQ`QbmMdkmWxkhSmSJMmdik`JkmQiSdi`iQ^JmYdbkWYfkSdiLYimLYimbdUoY^Yb\+Jkki^Yb\+OLd^Yb\+dOLMJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+66iQk8+Oidf+kh+SWx`QJbkMdobmv^dMJmYdbSJMmdi+kh+SWxfMmMdbmQbmdSkmioMmoiQqJ^oQ+kh+SWxiQf^JMQ`QbmMdkm+kh+SWxkhSmSJMmdik 66iQk8+OQ^!66iQk8+Ybk"66iQk8+`QJbk#66iQk8+kQ^$66iQk8+ofO%68WxiQf^JMQ`QbmMdkm+m&6:WxQufdkoiQdMMofm+m'6JMJ^MQufdkoiQ)6>MJ^MQufdkoiQ*6@JMimJLQufdkoiQ+6@MJ^MQufdkoiQmdmJ^6@MimJLQufdkoiQ6@ofOQufdkoiQ6BWxfMmMdbmQbmdSkmioMmoiQqJ^oQ+m6DWxfMmMdbmQbmdSkmioMmoiQqJ^oQ+m+MidkkmJL6FMJ^MMdbmQbmQufdkoiQ6HMJ^MMdbmQbmQufdkoiQmdmJ^6HMimJLMdbmQbmQufdkoiQ6HofOMdbmQbmQufdkoiQ86JWxkhSddmJUQdMMofm+m 86LWxkhSddmJUQdMMofm+m 86ofOkhSddmJUQ 88WxkhSmSJMmdik+m 8:WxkhSmSJMmdik+m+MidkkmJL 8JofOL^OUMdobm8>MJ^ML^OUMdobmmdmJ^8>MimJLL^OUMdobm8>ofOL^OUMdobmL^OUMdobmMdbmQbmQufdkoiQOd`YbJbm+MdOd`YbJbm+Md+OQ^Od`YbJbm+Md+YbkOd`YbJbm+Md+`QJbkQufdkoiQWxMdobmvWx`QJbkMdobmv^dMJmYdbSJMmdiWx`QJbkMdobmvsYmWbJ`QkWxfMmMdbmQbmdSkmioMmoiQqJ^oQWxiQf^JMQ`QbmMdkmWxkhSmSJMmdikYbbQi+WxL^OUMdobmdMMofm YbbQi+WxkhSddmJUQdMMofm!^Jkm+ki"`kvkJMMQkkdL[QMmk#`kvkJMMQkku`^$`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkdomQi+WxL^OUMdobmdMMofm%domQi+WxkhSddmJUQdMMofm&iQk8+f^JMQWd^OQi'mdmJ^+Jkki+WxL^OUMdobmdMMofmmdmJ^+Jkki+WxkhSddmJUQdMMofmmdmJ^+OLd+WxL^OUMdobmdMMofmmdmJ^+OLd+WxkhSddmJUQdMMofmJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO  @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$%&'()*+,- . / 0 1 23456789: ;!<%=&>?@A"$,29<BEILOUX"\#' @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP        !!!" "!""###$#%$&$'$(%)%*%+&,&-&.'/'0'1(2(3(4)5)6)7*8*9*:+;+<+=,>,?,@-A-B-C.D.E.F/G/H/I0J0011122233 3 4 4 4 5556667778889 9!9":;:<:=;>;?;@< < < = ==>>>???@@@AAAJ "G"H"I,,,2229#9$9%<&<'<(B)B*B+E,E-E.I/I0I1L2L3L4O5O6O7U8U9U:XAXBXC\D\E\F  !"#q ' @!$ '+-$/2 (5*+    !"$%&'(#)+,-*.01234/57896:<=>; ? A B C D E  F  G @!H!J!K!!!!!!!!!!  !  !  !  !  !!!!!!!!!!!!!!!!!!!  !!!!""!#!$!I"%"'"(")"*"+","-"."/"0"1" " " " " """"" " " " " """""""""" "!"""""&#### #!#"###$#%#&#'# (# )# *# +# ,#-#.#/#0#1#2#3#4#5##########  #! #" #$ $$$$$$$$$$ $ $ $ $ $$$$$    0,d _ Z g  ~K ; K nyuFEd`DCA ##ZFM@~FM@P05#'f@f@P05ACRTABExposure*@`@ZNNBBBBBBB@ @"+p@b$@04CalcExposure^@`@VJJ>>>>>>>< @  Fϣ.o@*@03hzReplacementCost_T_Crosstab@`@vjj^^^^^^^\ @렮o@xAX@02hzExposureOccupT_T@`@bVVJJJJJJJH @0d@(@01hzReplacementCost_T@`@dXXLLLLLLLJ @#쭱@ r@00RES1_SEL[@`@NBB66666664 @Z8@78@000RES1_MEANS@@RFF:::::::8 @P@@@00RES1_INS@`@NBB66666664 @f{"@f{"@~sq_fhzSqftFactors4MR2KeepLocal TFFFFFFFD @X9l@X9l@~sq_fhzReplacementCost4MR2KeepLocal TNNNNNNNL @yK@yK@~sq_fhzMeansCountyLocationFactor4MR2KeepLocal Tbbbbbbb` @ ~kt@UN@AdminTk8,,,,,,,,,* Be@Be@LINK_ODBC44444444442 H@H@LINK_DBO22222222220  ba@ ba@LINK_ASSR44444444442  @ @BIRTNoGUI44444444442 g+u@g+u@Relationships for BIRTT@ZZZNNNNNNNL @ 3R@3R@MasterFormT@BBB66666664 @ @c@@c@hzSqftFactors@HHH<<<<<<<: @ 8l@8l@hzReplacementCostB@PPPDDDDDDDB @  @ @hzPctContentOfStructureValue6@fffZZZZZZZX @ }H[@}H[@hzMeansCountyLocationFactor@dddXXXXXXXV @ E9j@E9j@UserDefinedA@DDD88888886 @ E9j@SI_@SummaryInfoZ@DDD88888886 @E9j@E9j@SysRel.........., E9j@E9j@Scripts0000000000. E9j@E9j@Reports0000000000. E9j@E9j@Modules0000000000. E9j@E9j@Forms,,,,,,,,,,* zj@zj@DataAccessPages@@@@@@@@@@> E9j@E9j@MSysRelationshipsDDDDDDDDDDB E9j@E9j@MSysQueries88888888886 E9j@E9j@MSysACEs22222222220 E9j@E9j@MSysObjects88888888886 E9j@ޓ@MSysDb@:::......., @E9j@E9j@Relationships<<<<<<<<<<: E9j@E9j@Databases44444444442 E9j@E9j@Tables.........., L`B$b  r T 6  H H d % n P  d~A q3[=hJ,lN0h4rT!10AhzSqFootageOccupT_TB??= !03hzReplacementCost_T_CrosstabXOOM ! ! G T.[OCC Code]+ g  T.fakeID' g T.[OCC Code]+ g  T.fakeID' g AvgOfMeansCostAvg(T.[Means Cost 2005])S-- o 01hzReplacementCost_TT==;   G    GfakeID1+ odbo_hzExposureOccupT.*5 gdbo_hzExposureOccupT999   GfakeID1+ ohzReplacementCost.*2 ghzReplacementCost333   GhzReplacementCostRES1_PLACEHOLDERb@_S3 hzReplacementCost.Means Cost 2005D@_S wRES1_PLACEHOLDER111 hzReplacementCost333  G  G occ="RES1") 'RES1_USD_per_SQFT0 gRES1_PLACEHOLDER111   GRES1_PLACEHOLDERDOMINANT_CO_MEANS`@_S1 RES1_PLACEHOLDER.RES1_USD_per_SQFT@aU wDOMINANT_CO_MEANS333 RES1_PLACEHOLDER111  G  G(((S!RES1F)<>0))/ 'ESE.Tract=S.Tract2 FakeID "99999"2 oocc"RES1"+ oRES1_USD_per_SQFTAvg(E!RES1I/S!RES1F)U33 odbo_hzSqFootageOccupTS==; dbo_hzExposureOccupTE;;9 RES1_PLACEHOLDER111 O  GRES1_PLACEHOLDER.*1 gRES1_PLACEHOLDER111  G  GhzSqftFactors+++   G  GhzReplacementCost333   G  GhzPctContentOfStructureValueIII   G  GhzMeansCountyWithNames===   G  G:drop table RES1_PLACEHOLDER;W g  GLVALxr0  D n R0lZ^8ASSR_hzBldgCountOccupT.Tract=dbo_hzBldgCountOccupT.TractCOUNT(ASSR_hzBldgCountOccupT.Tract)ASSR_hzSqFootageOccupT.Tract=dbo_hzSqFootageOccupT.TractCOUNT(ASSR_hzSqFootageOccupT.Tract)ASSR_hzBldgCountOccupT.Tract=dbo_hzBldgCountOccupT.TractCOUNT(ASSR_hzBldgCountOccupT.Tract)Int(c.IND1I+c.IND2I+c.IND3I+c.IND4I+c.IND5I+c.IND6I)Int(c.COM1I+c.COM2I+c.COM3I+c.COM4I+c.COM5I+c.COM6I+c.COM7I+c.COM8I+c.COM9I+c.COM10I)Int(c.RES1I+c.RES2I+c.RES3AI+c.RES3BI+c.RES3CI+c.RES3DI+c.RES3EI+c.RES3FI+c.RES4I+c.RES5I+c.RES6I)Int([RESI]+[COMI]+[INDI]+[AGRI]+[RELI]+[GOVI]+[EDUI])a.IND1F+a.IND2F+a.IND3F+a.IND4F+a.IND5F+a.IND6Fa.COM1F+a.COM2F+a.COM3F+a.COM4F+a.COM5F+a.COM6F+a.COM7F+a.COM8F+a.COM9F+a.COM10Fa.RES1F+a.RES2F+a.RES3AF+a.RES3BF+a.RES3CF+a.RES3DF+a.RES3EF+a.RES3FF+a.RES4F+a.RES5F+a.RES6Fa.RES1F+a.RES2F+a.RES3AF+a.RES3BF+a.RES3CF+a.RES3DF+a.RES3EF+a.RES3FF+a.RES4F+a.RES5F+a.RES6F+a.COM1F+a.COM2F+a.COM3F+a.COM4F+a.COM5F+a.COM6F+a.COM7F+a.COM8F+a.COM9F+a.COM10F+a.IND1F+a.IND2F+a.IND3F+a.IND4F+a.IND5F+a.IND6F+a.AGR1F+a.REL1F+a.GOV1F+a.GOV2F+a.EDU1F+a.EDU2FInt(c.IND1I+c.IND2I+c.IND3I+c.IND4I+c.IND5I+c.IND6I)Int(c.COM1I+c.COM2I+c.COM3I+c.COM4I+c.COM5I+c.COM6I+c.COM7I+c.COM8I+c.COM9I+c.COM10I)Int(c.RES1I+c.RES2I+c.RES3AI+c.RES3BI+c.RES3CI+c.RES3DI+c.RES3EI+c.RES3FI+c.RES4I+c.RES5I+c.RES6I)Int([RESI]+[COMI]+[INDI]+[AGRI]+[RELI]+[GOVI]+[EDUI])INT(e.IND1I+e.IND2I+e.IND3I+e.IND4I+e.IND5I+e.IND6I)INT(e.COM1I+e.COM2I+e.COM3I+e.COM4I+e.COM5I+e.COM6I+e.COM7I+e.COM8I+e.COM9I+e.COM10I)INT(e.RES1I+e.RES2I+e.RES3AI+e.RES3BI+e.RES3CI+e.RES3DI+e.RES3EI+e.RES3FI+e.RES4I+e.RES5I+e.RES6I)INT([RESI]+[COMI]+[INDI]+[AGRI]+[RELI]+[GOVI]+[EDUI])X.COM10*B.COM10F*M.MeansAdjNonResX.COM10*B.COM10F*M.MeansAdjNonResRES1_PLACEHOLDER.occ=hzReplacementCost.[OCC Code]RES1_PLACEHOLDER.RES1_USD_per_SQFTRES1_PLACEHOLDER.FakeID=DOMINANT_CO_MEANS.FakeIDRES1_PLACEHOLDER.RES1_USD_per_SQFT/DOMINANT_CO_MEANS.MeansAdjustment 2/1 / 5 9 : ; [\]^ s0L{)}'{"RES3EI X.RES3E*B.RES3EF*M.MeansAdjResI o"RES3DI X.RES3D*B.RES3DF*M.MeansAdjResI o"RES3CI X.RES3C*B.RES3CF*M.MeansAdjResI o"RES3BI X.RES3B*B.RES3BF*M.MeansAdjResI o"RES3AI X.RES3A*B.RES3AF*M.MeansAdjResI o"RES2IX.RES2*B.RES2F*M.MeansAdjResE o"RES1IX.RES1*B.RES1F*M.MeansAdjResE o" B.Tract& g"hzMeansCountyWithNamesM??= "10BhzSqFootageOccupT_TB??= "03hzReplacementCost_T_CrosstabXOOM " " G!BMB.FIPS=M.CountyFips6 !XBX.fakeID=B.fakeID4 !"EDU2I!X.EDU2*B.EDU2F*M.MeansAdjNonResH o!!EDU1I!X.EDU1*B.EDU1F*M.MeansAdjNonResH o! GOV2I!X.GOV2*B.GOV2F*M.MeansAdjNonResH o!GOV1I!X.GOV1*B.GOV1F*M.MeansAdjNonResH o!REL1I!X.REL1*B.REL1F*M.MeansAdjNonResH o!AGR1I!X.AGR1*B.AGR1F*M.MeansAdjNonResH o!IND6I!X.IND6*B.IND6F*M.MeansAdjNonResH o!IND5I!X.IND5*B.IND5F*M.MeansAdjNonResH o!IND4I!X.IND4*B.IND4F*M.MeansAdjNonResH o!IND3I!X.IND3*B.IND3F*M.MeansAdjNonResH o!IND2I!X.IND2*B.IND2F*M.MeansAdjNonResH o!IND1I!X.IND1*B.IND1F*M.MeansAdjNonResH o!COM10IB@) o!COM9I!X.COM9*B.COM9F*M.MeansAdjNonResH o!COM8I!X.COM8*B.COM8F*M.MeansAdjNonResH o!COM7I!X.COM7*B.COM7F*M.MeansAdjNonResH o!COM6I!X.COM6*B.COM6F*M.MeansAdjNonResH o!COM5I!X.COM5*B.COM5F*M.MeansAdjNonResH o!COM4I!X.COM4*B.COM4F*M.MeansAdjNonResH o!COM3I!X.COM3*B.COM3F*M.MeansAdjNonResH o!COM2I!X.COM2*B.COM2F*M.MeansAdjNonResH o! COM1I!X.COM1*B.COM1F*M.MeansAdjNonResH o! RES6IX.RES6*B.RES6F*M.MeansAdjResE o! RES5IX.RES5*B.RES5F*M.MeansAdjResE o! RES4IX.RES4*B.RES4F*M.MeansAdjResE o! RES3FI X.RES3F*B.RES3FF*M.MeansAdjResI o!RES3EI X.RES3E*B.RES3EF*M.MeansAdjResI o!RES3DI X.RES3D*B.RES3DF*M.MeansAdjResI o!RES3CI X.RES3C*B.RES3CF*M.MeansAdjResI o!RES3BI X.RES3B*B.RES3BF*M.MeansAdjResI o!RES3AI X.RES3A*B.RES3AF*M.MeansAdjResI o!RES2IX.RES2*B.RES2F*M.MeansAdjResE o!RES1IX.RES1*B.RES1F*M.MeansAdjResE o! B.Tract& g!hzMeansCountyWithNamesM??= -6X_  ` a , - . /DY&]I>x6p.#COM10IInt(e.COM10I)8 o#COM9IInt(e.COM9I)5 o#COM8IInt(e.COM8I)5 o#COM7IInt(e.COM7I)5 o#COM6IInt(e.COM6I)5 o#COM5IInt(e.COM5I)5 o#COM4IInt(e.COM4I)5 o#COM3IInt(e.COM3I)5 o#COM2IInt(e.COM2I)5 o# COM1IInt(e.COM1I)5 o# RES6IInt(e.RES6I)5 o# RES5IInt(e.RES5I)5 o# RES4IInt(e.RES4I)5 o# RES3FIInt(e.RES3FI)8 o#RES3EIInt(e.RES3EI)8 o#RES3DIInt(e.RES3DI)8 o#RES3CIInt(e.RES3CI)8 o#RES3BIInt(e.RES3BI)8 o#RES3AIInt(e.RES3AI)8 o#RES2IInt(e.RES2I)5 o#RES1IInt(e.RES1I)5 o# e.Tract& g#04ACalcExposuree11/ #Exposure!!! O# # G"BMB.FIPS=M.CountyFips6 "XBX.fakeID=B.fakeID4 ""EDU2I!X.EDU2*B.EDU2F*M.MeansAdjNonResH o"!EDU1I!X.EDU1*B.EDU1F*M.MeansAdjNonResH o" GOV2I!X.GOV2*B.GOV2F*M.MeansAdjNonResH o"GOV1I!X.GOV1*B.GOV1F*M.MeansAdjNonResH o"REL1I!X.REL1*B.REL1F*M.MeansAdjNonResH o"AGR1I!X.AGR1*B.AGR1F*M.MeansAdjNonResH o"IND6I!X.IND6*B.IND6F*M.MeansAdjNonResH o"IND5I!X.IND5*B.IND5F*M.MeansAdjNonResH o"IND4I!X.IND4*B.IND4F*M.MeansAdjNonResH o"IND3I!X.IND3*B.IND3F*M.MeansAdjNonResH o"IND2I!X.IND2*B.IND2F*M.MeansAdjNonResH o"IND1I!X.IND1*B.IND1F*M.MeansAdjNonResH o"COM10IB@) o"COM9I!X.COM9*B.COM9F*M.MeansAdjNonResH o"COM8I!X.COM8*B.COM8F*M.MeansAdjNonResH o"COM7I!X.COM7*B.COM7F*M.MeansAdjNonResH o"COM6I!X.COM6*B.COM6F*M.MeansAdjNonResH o"COM5I!X.COM5*B.COM5F*M.MeansAdjNonResH o"COM4I!X.COM4*B.COM4F*M.MeansAdjNonResH o"COM3I!X.COM3*B.COM3F*M.MeansAdjNonResH o"COM2I!X.COM2*B.COM2F*M.MeansAdjNonResH o" COM1I!X.COM1*B.COM1F*M.MeansAdjNonResH o" RES6IX.RES6*B.RES6F*M.MeansAdjResE o" RES5IX.RES5*B.RES5F*M.MeansAdjResE o" RES4IX.RES4*B.RES4F*M.MeansAdjResE o" RES3FI X.RES3F*B.RES3FF*M.MeansAdjResI o?|:t2 l * p =  m - ]  O ;u3m+e#ZRJ\ %RES1IInt(e.RES1I)5 o% e.Tract& g%04CalcExposuree//- %Exposure!!! O% % G$*EDU2IINT(e.EDU2I)5 o$)EDU1IINT(e.EDU1I)5 o$(GOV2IINT(e.GOV2I)5 o$'GOV1IINT(e.GOV1I)5 o$&REL1IINT(e.REL1I)5 o$%AGR1IINT(e.AGR1I)5 o$$IND6IINT(e.IND6I)5 o$#IND5IINT(e.IND5I)5 o$"IND4IINT(e.IND4I)5 o$!IND3IINT(e.IND3I)5 o$ IND2IINT(e.IND2I)5 o$IND1IINT(e.IND1I)5 o$COM10IINT(e.COM10I)8 o$COM9IINT(e.COM9I)5 o$COM8IINT(e.COM8I)5 o$COM7IINT(e.COM7I)5 o$COM6IINT(e.COM6I)5 o$COM5IINT(e.COM5I)5 o$COM4IINT(e.COM4I)5 o$COM3IINT(e.COM3I)5 o$COM2IINT(e.COM2I)5 o$COM1IINT(e.COM1I)5 o$RES6IINT(e.RES6I)5 o$RES5IINT(e.RES5I)5 o$RES4IINT(e.RES4I)5 o$RES3FIINT(e.RES3FI)8 o$RES3EIINT(e.RES3EI)8 o$RES3DIINT(e.RES3DI)8 o$RES3CIINT(e.RES3CI)8 o$ RES3BIINT(e.RES3BI)8 o$ RES3AIINT(e.RES3AI)8 o$ RES2IINT(e.RES2I)5 o$ RES1IINT(e.RES1I)5 o$ EDUIINT(e.EDU1I+e.EDU2I); o$GOVIINT(e.GOV1I+e.GOV2I); o$RELIINT(e.REL1I)3 o$AGRIINT(e.AGR1I)3 o$INDIh@ % o$COMI@% o$RESI@% o$TotalExpj@-!! o$ e.Tract& g$04CalcExposuree//- $ $ G#"EDU2IInt(e.EDU2I)5 o#!EDU1IInt(e.EDU1I)5 o# GOV2IInt(e.GOV2I)5 o#GOV1IInt(e.GOV1I)5 o#REL1IInt(e.REL1I)5 o#AGR1IInt(e.AGR1I)5 o#IND6IInt(e.IND6I)5 o#IND5IInt(e.IND5I)5 o#IND4IInt(e.IND4I)5 o#IND3IInt(e.IND3I)5 o#IND2IInt(e.IND2I)5 o#IND1IInt(e.IND1I)5 oC(N o a ]L W k gJ } H2h~E=CqmC.A uJM@uJM@RES1_PLACEHOLDER֯@_@RES1_PLACEHOLDER@NNNBBBBBBB@ @=@@kuLP@OUTER_hzSqFootageOccupT4@`@h\\PPPPPPPN @" @ @MSysAccessXML4MR2KeepLocal  T|||<<<<<<<: @\l-CM@\EM@MSysAccessObjectsDDDDDDDDDDB XMD8@*Zz@LAST_SR@<<<0000000. @;vB@LH@INNER_hzSqFootageOccupTb@`@h\\PPPPPPPN @UZu@L@hzSqftFactorsC@HHH<<<<<<<: @Oq'd@3j˯@hzReplacementCost0@PPPDDDDDDDB @L-u@|z \d@hzPctContentOfStructureValue@fffZZZZZZZX @IuK@[K@hzMeansCountyWithNames"@ZZZNNNNNNNL @Eg@Lō@hzMeansCountyLocationFactorg@dddXXXXXXXV @<T@T@Exposure22222222220 9> @Z8@DOMINANT_CO_MEANS@PPPDDDDDDDB @9F@{?@@DOMINANT_CO_INS@`@XLL@@@@@@@> @8X@]@ DOMINANT_CO_DEL@`@XLL@@@@@@@> @7U0*@RL@DOMINANT_CO@|@PDD88888886 @2ض(@ض(@ContentExposure@@@@@@@@@@> ,@%ۄ@BldgCount44444444442 50O@p@P14CRTABBldgCountM @|@ZNNBBBBBBB@ @4p t@[VG@14CalcBldgCountTotal @`@ bVVJJJJJJJH @3r޽@YR;@014AUPDBldgCount@`@ XLL@@@@@@@> @2}s@@13CalcBldgCount@`@XLL@@@@@@@> @ 0vr@as@11hzSqftFactors_T@`@\PPDDDDDDDB @/%~X@hN"@010UPDSqFootage@`@VJJ>>>>>>>< @.lbp@Dž@10BhzSqFootageOccupT_T@`@fZZNNNNNNNL @-wC|p@!@10AhzSqFootageOccupT_T@`@fZZNNNNNNNL @ +kQ@C4Y@P09CRTABContentExposure8@`@fZZNNNNNNNL @*[cr@AQ@09CalcContentExposureTotalu`@nbbVVVVVVVT @)VAr@{@08CalcContentExposurek@dXXLLLLLLLJ @(,bq@8Br@07hzPctContentOfStructureValue_T_CrosstabF@`@tttttttr @ &Y@]@005UPDExposure@`@THH<<<<<<<: @%|Q@NY@P05CRTABExposure k`@XLL@@@@@@@> @$xq@W@05CalcExposureTotalk`@`TTHHHHHHHF @ @ @ @ @ @ @ @ @ @ @ @ @ @ @      !"$%&'(#)+,-*.01234/57896:<=>; ? A B C D E  F  G @!H!J!K!!!!!!!!!!  !  !  !  !  !!!!!!!!!!!!!!!!!!!  !!!!""!#!$!I"%"'"(")"*"+","-"."/"0"1" " " " " """"" " " " " """""""""" "!"""""&#### #!#"###$#%#&#'# (# )# *# +# ,#-#.#/#0#1#2#3#4#5##########  #! #" #$ $$$$$$$$$$ $ $ $ $ $$$$$  @ @ @ @ @ @ @ @ @ @ @ @ @ @!!  !!!!""!#!$!I"%"'"(")"*"+","-"."/"0"1" " " " " """"" " " " " """""""""" "!"""""&#### #!#"###$#%#&#'# (# )# *# +# ,#-#.#/#0#1#2#3#4#5##########  #! #" #$ $$$$$$$$$$ $ $ $ $ $$$$$ $!$"$#$$$%$&$'$($)$*$+$,$-$ .$!/$"0$#1$$2$%3$&4$'5$(6$)7$*8$ %9%;%<%=%>%%%%%%% % % %  %  % % % %%%%%%%%%%%%%%%% %!%"%:& &"&#&$&%&&&'&(&)&*&+&,& -& .& /& 0& 1&2&3&4&5&6&7&8&9&:&;&&&&&&&&& &! &" & &!' '' 7<y4e  Z  R  J  ? y 7 q/oQQ<j'^RF&hz.IND1I c.IND1I6! w&hz.COM10I c.COM10I9# w&hz.COM9I c.COM9I6! w&hz.COM8I c.COM8I6! w&hz.COM7I c.COM7I6! w&hz.COM6I c.COM6I6! w&hz.COM5I c.COM5I6! w&hz.COM4I c.COM4I6! w&hz.COM3I c.COM3I6! w&hz.COM2I c.COM2I6! w& hz.COM1I c.COM1I6! w& hz.RES6I c.RES6I6! w& hz.RES5I c.RES5I6! w& hz.RES4I c.RES4I6! w& hz.RES3FI c.RES3FI9# w&hz.RES3EI c.RES3EI9# w&hz.RES3DI c.RES3DI9# w&hz.RES3CI c.RES3CI9# w&hz.RES3BI c.RES3BI9# w&hz.RES3AI c.RES3AI9# w&hz.RES2I c.RES2I6! w&hz.RES1I c.RES1I6! w&hz.Tract c.Tract6! w&Exposurec##! &dbo_hzExposureOccupThz==9 & G& & G%"EDU2IInt(e.EDU2I)5 o%!EDU1IInt(e.EDU1I)5 o% GOV2IInt(e.GOV2I)5 o%GOV1IInt(e.GOV1I)5 o%REL1IInt(e.REL1I)5 o%AGR1IInt(e.AGR1I)5 o%IND6IInt(e.IND6I)5 o%IND5IInt(e.IND5I)5 o%IND4IInt(e.IND4I)5 o%IND3IInt(e.IND3I)5 o%IND2IInt(e.IND2I)5 o%IND1IInt(e.IND1I)5 o%COM10IInt(e.COM10I)8 o%COM9IInt(e.COM9I)5 o%COM8IInt(e.COM8I)5 o%COM7IInt(e.COM7I)5 o%COM6IInt(e.COM6I)5 o%COM5IInt(e.COM5I)5 o%COM4IInt(e.COM4I)5 o%COM3IInt(e.COM3I)5 o%COM2IInt(e.COM2I)5 o% COM1IInt(e.COM1I)5 o% RES6IInt(e.RES6I)5 o% RES5IInt(e.RES5I)5 o% RES4IInt(e.RES4I)5 o% RES3FIInt(e.RES3FI)8 o%RES3EIInt(e.RES3EI)8 o%RES3DIInt(e.RES3DI)8 o%RES3CIInt(e.RES3CI)8 o%RES3BIInt(e.RES3BI)8 o%RES3AIInt(e.RES3AI)8 o%RES2IInt(e.RES2I)5 o<:z7n+ b  K  o  w @ # ^x*@b:\z0R)IND6ie.IND6I*pct.IND6/100= o)IND5ie.IND5I*pct.IND5/100= o)IND4ie.IND4I*pct.IND4/100= o)IND3ie.IND3I*pct.IND3/100= o)IND2ie.IND2I*pct.IND2/100= o)IND1ie.IND1I*pct.IND1/100= o)COM10ie.COM10I*pct.COM10/100A o)COM9ie.COM9I*pct.COM9/100= o)COM8ie.COM8I*pct.COM8/100= o)COM7ie.COM7I*pct.COM7/100= o)COM6ie.COM6I*pct.COM6/100= o)COM5ie.COM5I*pct.COM5/100= o)COM4ie.COM4I*pct.COM4/100= o)COM3ie.COM3I*pct.COM3/100= o)COM2ie.COM2I*pct.COM2/100= o) COM1ie.COM1I*pct.COM1/100= o) RES6ie.RES6I*pct.RES6/100= o) RES5ie.RES5I*pct.RES5/100= o) RES4ie.RES4I*pct.RES4/100= o) RES3Fie.RES3FI*pct.RES3F/100A o)RES3Eie.RES3EI*pct.RES3E/100A o)RES3Die.RES3DI*pct.RES3D/100A o)RES3Cie.RES3CI*pct.RES3C/100A o)RES3Bie.RES3BI*pct.RES3B/100A o)RES3Aie.RES3AI*pct.RES3A/100A o)RES2ie.RES2I*pct.RES2/100= o)RES1ie.RES1I*pct.RES1/100= o) e.Tract& g)02hzExposureOccupT_Te;;9 )07hzPctContentOfStructureValue_T_Crosstabpctiic ) ) G(  T.Occupancy* g(  T.fakeID' g( T.Occupancy* g( T.fakeID' g(AvgOfContentValPctAvg(T.ContentValPct)W55 o(06hzPctContentOfStructureValue_TTSSQ ( G( ( G'fakeID1+ o' hzPctContentOfStructureValue.*= g'hzPctContentOfStructureValueIII ' ' G&hzchz.Tract=c.Tract5 &"hz.EDU2I c.EDU2I6! w&!hz.EDU1I c.EDU1I6! w& hz.GOV2I c.GOV2I6! w&hz.GOV1I c.GOV1I6! w&hz.REL1I c.REL1I6! w&hz.AGR1I c.AGR1I6! w&hz.IND6I c.IND6I6! w&hz.IND5I c.IND5I6! w&hz.IND4I c.IND4I6! w&hz.IND3I c.IND3I6! w&hz.IND2I c.IND2I6! w @ @ @ @ @ @ @ @ @ @ @ @ @ @$!$"$#$$$%$&$'$($)$*$+$,$-$ .$!/$"0$#1$$2$%3$&4$'5$(6$)7$*8$ %9%;%<%=%>%%%%%%% % % %  %  % % % %%%%%%%%%%%%%%%% %!%"%:& &"&#&$&%&&&'&(&)&*&+&,& -& .& /& 0& 1&2&3&4&5&6&7&8&9&:&;&&&&&&&&& &! &" & &!' '''' ((((((( ( ()))))) )!)")#)$)%) &) ') () )) *)+),)-).)/)0)1)2)3)4)5)6)7)8)9)))) )!)"))** * * * * ***** * * * * ********** *!*"*#*$*%*&*'*(* )*!**"+*#,*$-*%.*&/*'0*(1*)2**3* 4*+5+7+8+9+:+;+<+=++6 >l"D w D t 4 d " V  B |:t2l*aYQ|^"c!+RES3BIInt(c.RES3BI)8 o+RES3AIInt(c.RES3AI)8 o+RES2IInt(c.RES2I)5 o+RES1IInt(c.RES1I)5 o+ c.Tract& g+08CalcContentExposurec==; +ContentExposure/// O+ + G*  c.Tract& '**EDU2IInt(c.EDU2i)5 o*)EDU1IInt(c.EDU1I)5 o*(GOV2IInt(c.GOV2I)5 o*'GOV1IInt(c.GOV1I)5 o*&REL1IInt(c.REL1I)5 o*%AGR1IInt(c.AGR1I)5 o*$IND6IInt(c.IND6I)5 o*#IND5IInt(c.IND5I)5 o*"IND4IInt(c.IND4I)5 o*!IND3IInt(c.IND3I)5 o* IND2IInt(c.IND2I)5 o*IND1IInt(c.IND1I)5 o*COM10IInt(c.COM10I)8 o*COM9IInt(c.COM9I)5 o*COM8IInt(c.COM8I)5 o*COM7IInt(c.COM7I)5 o*COM6IInt(c.COM6I)5 o*COM5IInt(c.COM5I)5 o*COM4IInt(c.COM4I)5 o*COM3IInt(c.COM3I)5 o*COM2IInt(c.COM2I)5 o*COM1IInt(c.COM1I)5 o*RES6IInt(c.RES6I)5 o*RES5IInt(c.RES5I)5 o*RES4IInt(c.RES4I)5 o*RES3FIInt(c.RES3FI)8 o*RES3EIInt(c.RES3EI)8 o*RES3DIInt(c.RES3DI)8 o*RES3CIInt(c.RES3CI)8 o* RES3BIInt(c.RES3BI)8 o* RES3AIInt(c.RES3AI)8 o* RES2IInt(c.RES2I)5 o* RES1IInt(c.RES1I)5 o* EDUIInt(c.EDU1I+c.EDU2I); o*GOVIInt(c.GOV1I+c.GOV2I); o*RELIInt(c.REL1I)3 o*AGRIInt(c.AGR1I)3 o*INDIh@ % o*COMI@ % o*RESI@ % o*TotalExpj@ -!! o* c.Tract& g*08CalcContentExposurec==; * * G)pctepct.fakeID=e.fakeID: )"EDU2ie.EDU2I*pct.EDU2/100= o)!EDU1ie.EDU1I*pct.EDU1/100= o) GOV2ie.GOV2I*pct.GOV2/100= o)GOV1ie.GOV1I*pct.GOV1/100= o)REL1ie.REL1I*pct.REL1/100= o)AGR1ie.AGR1I*pct.AGR1/100= o.<v1h& `  X  M E   = wD&TBp*aUI}:,hz.IND4I c.IND4I6! w,hz.IND3I c.IND3I6! w,hz.IND2I c.IND2I6! w,hz.IND1I c.IND1I6! w,hz.COM10I c.COM10I9# w,hz.COM9I c.COM9I6! w,hz.COM8I c.COM8I6! w,hz.COM7I c.COM7I6! w,hz.COM6I c.COM6I6! w,hz.COM5I c.COM5I6! w,hz.COM4I c.COM4I6! w,hz.COM3I c.COM3I6! w, hz.COM2I c.COM2I6! w, hz.COM1I c.COM1I6! w, hz.RES6I c.RES6I6! w, hz.RES5I c.RES5I6! w, hz.RES4I c.RES4I6! w,hz.RES3FI c.RES3FI9# w,hz.RES3EI c.RES3EI9# w,hz.RES3DI c.RES3DI9# w,hz.RES3CI c.RES3CI9# w,hz.RES3BI c.RES3BI9# w,hz.RES3AI c.RES3AI9# w,hz.RES2I c.RES2I6! w,hz.RES1I c.RES1I6! w,ContentExposurec11/ ,dbo_hzExposureContentOccupThzKKG , G, , G+  c.Tract& '+"EDU2IInt(c.EDU2i)5 o+!EDU1IInt(c.EDU1I)5 o+ GOV2IInt(c.GOV2I)5 o+GOV1IInt(c.GOV1I)5 o+REL1IInt(c.REL1I)5 o+AGR1IInt(c.AGR1I)5 o+IND6IInt(c.IND6I)5 o+IND5IInt(c.IND5I)5 o+IND4IInt(c.IND4I)5 o+IND3IInt(c.IND3I)5 o+IND2IInt(c.IND2I)5 o+IND1IInt(c.IND1I)5 o+COM10IInt(c.COM10I)8 o+COM9IInt(c.COM9I)5 o+COM8IInt(c.COM8I)5 o+COM7IInt(c.COM7I)5 o+COM6IInt(c.COM6I)5 o+COM5IInt(c.COM5I)5 o+COM4IInt(c.COM4I)5 o+COM3IInt(c.COM3I)5 o+COM2IInt(c.COM2I)5 o+ COM1IInt(c.COM1I)5 o+ RES6IInt(c.RES6I)5 o+ RES5IInt(c.RES5I)5 o+ RES4IInt(c.RES4I)5 o+ RES3FIInt(c.RES3FI)8 o+RES3EIInt(c.RES3EI)8 o+RES3DIInt(c.RES3DI)8 o+RES3CIInt(c.RES3CI)8 o @ @ @ @ @ @ @ @ @ @ @ @ @ @'' ((((((( ( ()))))) )!)")#)$)%) &) ') () )) *)+),)-).)/)0)1)2)3)4)5)6)7)8)9)))) )!)"))** * * * * ***** * * * * ********** *!*"*#*$*%*&*'*(* )*!**"+*#,*$-*%.*&/*'0*(1*)2**3* 4*+5+7+8+9+:+;+<+=++++ + + + + ++ + + + + +++++++++++++ +!+"+ +6,, ,!,",#,$,%,&,',(,),*, +, ,, -, ., /,0,1,2,3,4,5,6,7,8,9,:,;,,,,,,, ,!,,- - - - ------- - - - - -------- -!-"-#-$-%-&-'-(-)-*- +-!,-"--#.- 4Gz7n+ j  } K  `  O   L  MNNOKPz.\/hz.RES3BF c.RES3BF9# w/hz.RES3AF c.RES3AF9# w/hz.RES2F c.RES2F6! w/hz.RES1F c.RES1F6! w/10AhzSqFootageOccupT_Tc??= /dbo_hzSqFootageOccupThz??; / G/ / G.FIPSLeft$([Tract],5)7 o.fakeID1+ o.hz.*# g.dbo_hzSqFootageOccupThz??; . . G-,FIPSleft(a.Tract,5)6 o-+fakeID1+ o-* a.EDU2F& g-) a.EDU1F& g-( a.GOV2F& g-' a.GOV1F& g-& a.REL1F& g-% a.AGR1F& g-$ a.IND6F& g-# a.IND5F& g-" a.IND4F& g-! a.IND3F& g- a.IND2F& g- a.IND1F& g- a.COM10F' g- a.COM9F& g- a.COM8F& g- a.COM7F& g- a.COM6F& g- a.COM5F& g- a.COM4F& g- a.COM3F& g- a.COM2F& g- a.COM1F& g- a.RES6F& g- a.RES5F& g- a.RES4F& g- a.RES3FF' g- a.RES3EF' g- a.RES3DF' g- a.RES3CF' g- a.RES3BF' g- a.RES3AF' g- a.RES2F& g- a.RES1F& g- EDUFa.EDU1F+a.EDU2F6 o-GOVFa.GOV1F+a.GOV2F6 o-RELF a.REL1F. o-AGRF a.AGR1F. o-INDF^@% o-COMF@% o-RESF@% o-TotalSqFt@/## o- a.Tract& g-ASSR_hzSqFootageOccupTa??= - - G,hzchz.Tract=c.Tract5 ,!hz.EDU2I c.EDU2I6! w, hz.EDU1I c.EDU1I6! w,hz.GOV2I c.GOV2I6! w,hz.GOV1I c.GOV1I6! w,hz.REL1I c.REL1I6! w,hz.AGR1I c.AGR1I6! w,hz.IND6I c.IND6I6! w,hz.IND5I c.IND5I6! w( @ @ @ @ @ @ @ @ @ @ @ @ @ @++ + + + + ++ + + + + +++++++++++++ +!+"+ +6,, ,!,",#,$,%,&,',(,),*, +, ,, -, ., /,0,1,2,3,4,5,6,7,8,9,:,;,,,,,,, ,!,,- - - - ------- - - - - -------- -!-"-#-$-%-&-'-(-)-*- +-!,-"--#.-$/-%0-&1-'2-(3-)4-*5-+6-,7- .8.:.;.<.=.9/>/@/A/B/C/D/E/F///// / / / / / / / / / ////////////// /!//?00 0!0"01#1%1&1'1(1)1 *1 +1$2,2.2/20212223242526272 82 92 :2 ;2 <2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2  2! 2" 2-=t.b V  J  ~ ; r / f # Zi11[=L^ hv(2 COM1IInt(s.COM1F*1000/c.COM1)A o2 RES6IInt(s.RES6F*1000/c.RES6)A o2 RES5IInt(s.RES5F*1000/c.RES5)A o2 RES4IInt(s.RES4F*1000/c.RES4)A o2 RES3FIInt(s.RES3FF*1000/c.RES3F)E o2RES3EIInt(s.RES3EF*1000/c.RES3E)E o2RES3DIInt(s.RES3DF*1000/c.RES3D)E o2RES3CIInt(s.RES3CF*1000/c.RES3C)E o2RES3BIInt(s.RES3BF*1000/c.RES3B)E o2RES3AIInt(s.RES3AF*1000/c.RES3A)E o2RES2IInt(s.RES2F*1000/c.RES2)A o2RES1IInt(s.RES1F*1000/c.RES1)A o2 s.Tract& g212hzSqftFactors_T_CrosstabcGGE 210BhzSqFootageOccupT_Ts??= 2 2 G1  T.Occupancy* g1  T.fakeID' g1 T.Occupancy* g1 T.fakeID' g1AvgOfSquareFootageAvg(T.SquareFootage)W55 o111hzSqftFactors_TT553 1 G1 1 G0fakeID1+ o0hzSqftFactors.*. g0hzSqftFactors+++ 0 0 G/hzchz.Tract=c.Tract5 /!hz.EDU2F c.EDU2F6! w/ hz.EDU1F c.EDU1F6! w/hz.GOV2F c.GOV2F6! w/hz.GOV1F c.GOV1F6! w/hz.REL1F c.REL1F6! w/hz.AGR1F c.AGR1F6! w/hz.IND6F c.IND6F6! w/hz.IND5F c.IND5F6! w/hz.IND4F c.IND4F6! w/hz.IND3F c.IND3F6! w/hz.IND2F c.IND2F6! w/hz.IND1F c.IND1F6! w/hz.COM10F c.COM10F9# w/hz.COM9F c.COM9F6! w/hz.COM8F c.COM8F6! w/hz.COM7F c.COM7F6! w/hz.COM6F c.COM6F6! w/hz.COM5F c.COM5F6! w/hz.COM4F c.COM4F6! w/hz.COM3F c.COM3F6! w/ hz.COM2F c.COM2F6! w/ hz.COM1F c.COM1F6! w/ hz.RES6F c.RES6F6! w/ hz.RES5F c.RES5F6! w/ hz.RES4F c.RES4F6! w/