Standard Jet DBnb` Ugr@?~1y0̝cßFNg7 ؜(B*`{6߱&hC33ey[)|*"|YEFf_Љ$g'DeFx -bT4.0 Pb YS  Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OYx#SY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId YOx#SOY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -Yx#S Y Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationship-j%V B s . S  / \  Hy HH0@@P Pe PPP@ |pPP@ Q+kh+M86mQ^QfWdbQ+kh+MMd`LdFB + ::J:JF8JQS@D>MD8HFM>LH6BJ@HHOM>D+ +;K[P!6@Mokmd`u`^UQbQiJmYdb6BdiUJbYxJmYdb6DfQikdb6F`JY^YbUJOOiQkk6HQ^QMmidbYMJOOiQkk86mQ^QfWdbQ88diUJbYxJmYdbid^QJkkYUb8:fQikdbid^QJkkYUb8<fd^^omYdbkdoiMQk8>fidMQOoiQk8@fidMQOoiQJkkYUb8B^Jm^dbU 8DUQbQiJmQu`^!8FLQJMWJMmYqYmviQJkdb"8HLQJMWJMmYqYmvkmJmYdb#`dOMokmd`u`^$`dOUQbQiJmQu`^%`dOfiQqJ^u`^&`dOkWJiQOu`^'JMmYdbkiQfdim(JmmiYLomQkiQfdim)`dbYmdiYbUiQfdim*fd^^omYdbkdoiMQiQfdim+JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+M6:LQJMW+kh+MMd`Ld<8+kh+M6<LQJMWJmmiYLomQ+kh+MMd`Ld86B+kh+M6<LQJMWJmmiYLomQ+kh+MMd`Ld86H+kh+M6<LQJMWJmmiYLomQ+kh+MMd`Ld8F+kh+M6>LQJMWJMmYqYmv+kh+MMd`Ld86B+kh+M6>LQJMWJMmYqYmv+kh+MMd`Ld8F+kh+M6>LQJMWJMmYqYmv+kh+MMd`Ld:<+kh+M6BdiUJbYxJmYdb+kh+MMd`LdF8+kh+M6DfQikdb+kh+MMd`LdF8 +kh+M6F`JY^YbUJOOiQkk+kh+MMd`LdFB +kh+M6F`JY^YbUJOOiQkk+kh+MMd`LdFF +kh+M6F`JY^YbUJOOiQkk+kh+MMd`LdH6 +kh+M6HQ^QMmidbYMJOOiQkk+kh+MMd`LdFB +kh+M6HQ^QMmidbYMJOOiQkk+kh+MMd`LdFF+kh+M6HQ^QMmidbYMJOOiQkk+kh+MMd`LdH6+kh+M86mQ^QfWdbQ+kh+MMd`Ld<8+kh+M86mQ^QfWdbQ+kh+MMd`LdFB+kh+M86mQ^QfWdbQ+kh+MMd`LdFF+kh+M86mQ^QfWdbQ+kh+MMd`LdH6+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdFB+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdFF+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdH6+kh+M8:fQikdbid^QJkkYUb+kh+MMd`Ld8F+kh+M8:fQikdbid^QJkkYUb+kh+MMd`LdFB+kh+M8:fQikdbid^QJkkYUb+kh+MMd`LdH6+kh+M8<fd^^omYdbkdoiMQk+kh+MMd`Ld8F+kh+M8<fd^^omYdbkdoiMQk+kh+MMd`LdFB+kh+M8>fidMQOoiQk+kh+MMd`LdF8+kh+M8@fidMQOoiQJkkYUb+kh+MMd`Ld8F+kh+M8@fidMQOoiQJkkYUb+kh+MMd`LdF8+kh+M8B^Jm^dbU+kh+MMd`Ld86F+kh+M8B^Jm^dbU+kh+MMd`Ld88H+kh+M8B^Jm^dbU+kh+MMd`Ld8F+kh+M8B^Jm^dbU+kh+MMd`Ld<8+kh+M8FLQJMWJMmYqYmviQJkdb+kh+MMd`LdF:+kh+M8HLQJMWJMmYqYmvkmJmYdb+kh+MMd`LdF:+kh+S6:LQJMW+kh+S6<LQJMWJmmiYLomQ+kh+S6>LQJMWJMmYqYmv +kh+S6BdiUJbYxJmYdb +kh+S6DfQikdb +kh+S6F`JY^YbUJOOiQkk +kh+S6HQ^QMmidbYMJOOiQkk +kh+S86mQ^QfWdbQ+kh+S88diUJbYxJmYdbid^QJkkYUb+kh+S8:fQikdbid^QJkkYUb+kh+S8<fd^^omYdbkdoiMQk+kh+S8>fidMQOoiQk+kh+S8@fidMQOoiQJkkYUb+kh+S8B^Jm^dbU+kh+S8FLQJMWJMmYqYmviQJkdb+kh+S8HLQJMWJMmYqYmvkmJmYdbJMmYdbkJmmiYLomQkLQJMW`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOn @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$%&'()*+,- . / 0 1 23456789:;<=>?@ABCDEFGHIJK L M N O PQRSTUVWXYZ[n\n ]n ^n_n`n#an$bn%cn&dPePfPgPhPiPjPkPlPmP nP oP (07<@H P!U"\#d$onn nnnnnnnn n  nnnnnnn$n'n*n-n0n3n6n;n>nAn Dn!Gn"r A^ qRRRRRRRR R R R RRRRRRRRRRRRR$R% R& R' R( R) R* R+ R, R- R. R/ R0 R1 R2 R3 R4R5R6R7R8R9R:R;R<R=R>R?R@RARBRCRDRERFRGRHRIRJRKRLRMRNRORPXXXXXXXXXX X X X X XXXXXXXXXXXX XJ Z Z!Z!Z!Z"Z"Z"Z#Z#Z #Z $Z $Z $Z %Z%Z%Z%Z&Z&Z&Z&Z'Z'Z'Z'Z(Z(Z(Z(Z)Z)Z)Z )Z!*Z"*Z#*Z$*Z%+Z&+Z'+Z(+Z),Z*,Z+,Z,,Z--Z.-Z/-Z0-Z1.Z2.Z3.Z4.Z5/Z6/Z7/Z8/Z90Z:0Z;0Z<0]1]1]1]1]2]2]2]2]3] 3] 3] 3] 4] 4]4]4]5]5]5]5]6]6]6]6]7]7]7]7]8]8]8]8] 9]!9]"9]#9]$:]%:]&:]':](;]);]*;]+;],<]-<].<]/<]0=]1=]2=]3=]4>]5>]6>]7>^?^?^?^?^@^@^@^@^A^ A^ A^ A^ B^ B^B^B^C^C^C^C^D^D^D^D^E^E^E^E^F^F^F^F^ G^!G^"G^#G^$H^%H^&H^'H^(I^)I^*I^+I^,J^-J^.J^/J^0K^1K^2K^3K^4L^5L^6L^7L`M`M`M`M`N`N`N`N`O` O` O` O` P` P`P`P`Q`Q`Q`Q`R`R`R`R`S`S`S`S`T`T`T`T` U`!U`"U`#U`$V`%V`&V`'V`(W`)W`*W`+W`,X`-X`.X`/X`0Y`1Y`2Y`3Z`4Z`5Z`6[d [d![d"`X`X`XaXaXaXbX bX!bX"cX#cX$cX%dX&dX'dX(eX)eX*eX+fX,fX-fX.gX/gX0gX1hX2hX3hX4iX5iX6iX7jX8jX9jX:kX;kX<kX=lX>lX?lX@mXAmXBmXCnXDnXEnXFoXGoXHoXId=d>d+d,`7`8`9`:dd(d(d(d0d0d0d7d7d 7d <d <d <d @d@d@dHdHdHdPdPdPdUdUdUd\d\d\dddddddod#od$od%od&d'd(d)d*d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<RRRR RR RRRR!R"R#N%% %&&&&  &' ' ' ' ' ((((( ()))) )***** *+ +"+#+ $+!,%,',(, ),&-*-,--- .-+./.1.2. 3.0/4/6/7/ 8/5090;0<0 =0:1>1@1A1 B1?2C2E2F2 G2D3H3J3K3 L3I4M4O4P4 Q4N5R5T5U5 V5S6W666 6X7777 788 8 8  8 9 999 9:::: :;;;;; ;<<< < !<="=$=%= &=#>'>)>*>+> ,>(?-?/?0?.@1@3@4@ 5@2A6A8A9A:A ;A7BB?B=C@CBCCC DCADEDGDHD IDFEJELEMENE OEKFPFRFSF TFQGUGWGXGGG GVHHHHHH  HI I I I JJJJKKKKLLLLMMMMNN N!NQb @@@@@+ 66DLOSOMBFQ<>6QDHDHS:JSF:LO@6F<@<>@>>FJJJ+ +;K[O+ 6MLB8S:@QOJB>>:JHLSJQ@BH8S>8JS86+ +;K[O+ 8SL::B6@DBM:>S:>FO6B6HD@@M6LBMD8HFM>LH6BJ@HHOM>D+ +;K[O+ >JM8@JLLHJL:8:JMHO@HS<+ +;K[O+ @:QHBFO<:BFF>>H>JH6B8H8<>DS>QBFLM:@<@>MMMQSDDOFDD>FSJFJ:MMHD>QH:>LHJQMQ:@:>>8JL>@FDHL:8H>J@F:FD6:+ +;K[O + L6BBMJ>LD@D@>QQFJB<66LQH:OQBFMFF+ +;K[O + MBJO>MJ::DB6>>Q:HMLQBHJH@6JHLFDJ+ +;K[O + MBM8QBBBHOL8HLBS8S@<<@SO+ +;K[OLQJMWLQJMW+fd^^omYdbOt @@@ LQJMW+JMmYqYmvOLQJMW+JMmYqYmv+iQJkdbO LQJMW+diUJbYxJmYdb+id^Q+JkkYUbOLQJMW+diUJbYxJmYdb+id^Q+JkkYUbOLQJMW+fQikdb+id^Q+JkkYUbOLQJMW+fQikdb+id^Q+JkkYUbO LQJMW+fd^^omYdbOLQJMW+fidMQOoiQ+JkkYUbOLQJMW+fidMQOoiQ+JkkYUbO Q^QMmidbYM+JOOiQkkOQ^QMmidbYM+JOOiQkkO`JY^YbU+JOOiQkkO `JY^YbU+JOOiQkkO fQikdbOmQ^QfWdbQOmQ^QfWdbQO+  @@ LQJMWOLQJMWOLQJMWOLQJMWO LQJMWOLQJMW+JMmYqYmvO diUJbYxJmYdbOdiUJbYxJmYdbOdiUJbYxJmYdbOdiUJbYxJmYdbO diUJbYxJmYdbOfQikdbOfQikdbOfQikdbOfQikdbO fidMQOoiQO W,d _ Z g cL Kf  ) I aG"(LDjne:6A###z*@z*@Pollution Source Report#`$@`$@Pollution Source Report{_@Y\\\PPPPPPPN @P!@@Attributes Report{_(@YPPPDDDDDDDB @ Nd@Nd@Actions Report{_@YJJJ>>>>>>>< @+9@+9@modSharedXML{_::::::::::8 )AD̓@)AD̓@modPreValXML{_::::::::::8 =]S`@=]S`@modGenerateXML{_>>>>>>>>>>< +9@+9@modCustomXML{_::::::::::8 ΅}e@΅}e@19) Beach Activity Station{_T@YbbbVVVVVVVT @Kd@Kd@18) Beach Activity Reason{_@W```TTTTTTTR @l@l@17) Generate XML{_~@TNNNBBBBBBB@ @P&@&@15) Procedure Assign{_@WVVVJJJJJJJH @2@2@14) Procedures{_.@WJJJ>>>>>>>< @@@13) Pollution Sources{_@WXXXLLLLLLLJ @,u2@,u2@12) Person Role Assign{_@VZZZNNNNNNNL @z@z@11) Organization Role Assign{_@VfffZZZZZZZX @64x@64x@10) Telephone{_@VHHH<<<<<<<: @@@09) Electronic Address{_@VZZZNNNNNNNL @P@@07) Person{_@UBBB66666664 @@@06) Organization{_p@UNNNBBBBBBB@ @ Ӥ@Ӥ@05) Custom XML Generation{_~@T```TTTTTTTR @ 9L@9L@04) Beach Activity{_J@URRRFFFFFFFD @ Wmd@Wmd@03) Beach Attribute{_@TTTTHHHHHHHF @ F݂@F݂@02) Beach{_V@T@@@44444442 @  F݂@ F݂@01) Main Menu {Start Here}{_~@TbbbVVVVVVVT @ #`@#`@UserDefined{_A@TDDD88888886 @ #`@)@SummaryInfo{_@TDDD88888886 @ P#`@#`@SysRel{_.........., #`@#`@Scripts{_0000000000. P#`@#`@Modules{_0000000000. #`@#`@Forms{_,,,,,,,,,,* #`@#`@DataAccessPages{_@@@@@@@@@@> #`@#`@MSysRelationshipsz]DDDDDDDDDDB #`@#`@MSysQueriesz]88888888886 #`@#`@MSysACEsz]22222222220 #`@#`@MSysObjectsz]88888888886 #`@mXu@MSysDb{_|@T:::......., @#`@#`@Relationshipsz]<<<<<<<<<<: #`@#`@Databasesz]44444444442 #`@#`@Tablesz].........., nN+d `M K V RJ H2.GsoFDCPAAAK*@K*@~sAKAAK*@K*@~sq_c15) PrAm)@m)@~sq_c15) Procedure Assign~sq_cCombo18{_4MR2KeepLocal Tlllllllj @_?_hQ@_hQ@~sq_c13) Pollution Sources~sq_cCombo86{_4MR2KeepLocal Tnnnnnnnl @>_hQ@_hQ@~sq_c13) Pollution Sources~sq_cCombo18{_4MR2KeepLocal Tnnnnnnnl @P<ire@ire@~sq_c12) Person Role Assign~sq_cCombo86{_4MR2KeepLocal Tpppppppn @;ire@ire@~sq_c12) Person Role Assign~sq_cCombo18{_4MR2KeepLocal Tpppppppn @P9i+@i+@~sq_c11) Organization Role Assign~sq_cCombo88{_4MR2KeepLocal T|||||||z @8@@~sq_c11) Organization Role Assign~sq_cCombo86{_4MR2KeepLocal T|||||||z @P6.3@3@~sq_c10) Telephone~sq_cCombo88{_4MR2KeepLocal T^^^^^^^\ @P4 @ @~sq_c10) Telephone~sq_cCombo31{_4MR2KeepLocal T^^^^^^^\ @3#@#@~sq_c09) Electronic Address~sq_cCombo90{_4MR2KeepLocal Tpppppppn @P1#@#@~sq_c09) Electronic Address~sq_cCombo86{_4MR2KeepLocal Tpppppppn @0o'@o'@~sq_c08) Mailing Address~sq_cCombo90{_4MR2KeepLocal Tjjjjjjjh @P.SU@SU@~sq_c08) Mailing Address~sq_cCombo86{_4MR2KeepLocal Tjjjjjjjh @-qZ@qZ@~sq_c07) Person~sq_cCombo81{_4MR2KeepLocal TXXXXXXXV @P+Y_@Y_@~sq_c04) Beach Activity~sq_cCombo23{_4MR2KeepLocal Thhhhhhhf @*Y_@Y_@~sq_c04) Beach Activity~sq_cCombo18{_4MR2KeepLocal Thhhhhhhf @P((;@(;@~sq_c03) Beach Attribute~sq_cCombo18{_4MR2KeepLocal Tjjjjjjjh @'(;@(;@~sq_c03) Beach Attribute~sq_cCombo109{_4MR2KeepLocal Tlllllllj @P%c@c@~sq_c02) Beach~sq_cCombo31{_4MR2KeepLocal TVVVVVVVT @$ i:c`@ Yy;@Admin{_[e8,,,,,,,,,* YHO \ * \ ,  e 3  e 5  w E ' qS5g1oAi7iK-k-SoA6 6 G5 ID! '5ID! g5ORGANIZATION))) 5 5 G4 [NAME]% '4REF_ACCESS_TYPE.NAME3 g4REF_ACCESS_TYPE/// 4 4 G3 [NAME]% '3NAME# g3REF_MAILING_CODE111 3 3 G2 ID! '2ID! g2PERSON 2 2 G1 ID! '1ID! g1ORGANIZATION))) 1 1 G0 [NAME]% '0NAME# g0REF_MAILING_CODE111 0 0 G/ ID! '/ID! g/PERSON / / G. ID! '.ID! g.ORGANIZATION))) . . G- ID! '-ID! g-ORGANIZATION))) - - G, [NAME]% ',NAME# g,REF_ORG_CODE))) , , G+ [NAME]% '+REF_ACTIVITY_CODE.NAME5 g+REF_ACTIVITY_CODE333 + + G* [ID]# '* BEACH.NAME) g* BEACH.ID' g*BEACH * * G) [NAME]% ')REF_MEASUREMENT_UNIT.NAME8 g)REF_MEASUREMENT_UNIT999 ) ) G( [ID]# '( BEACH.NAME) g( BEACH.ID' g(BEACH ( ( G' [NAME]% ''REF_FREQUENCY_UNIT.NAME6 g'REF_FREQUENCY_UNIT555 ' ' G& [NAME]% '&REF_MEASUREMENT_UNIT.NAME8 g&REF_MEASUREMENT_UNIT999 & & G% [NAME]% '%REF_ACCESS_TYPE.NAME3 g%REF_ACCESS_TYPE/// % % GYz\>|^( h : ` .  ` 0  n P 2 l N & nPT$Z$Z<hJ,z\>|^@tVGBEACH_ACTIVITY.ACTIVITY_ID9 gGBEACH_ACTIVITY--- G G GF [NAME]% 'FREF_ACCESS_TYPE.NAME3 gFREF_ACCESS_TYPE/// F F GE [ID]# 'E BEACH.NAME) gE BEACH.ID' gEBEACH E E GD NAME# 'DNAME# gDREF_H_REFERENCE_DATUM_NAMEEEE D D GC NAME# 'CNAME# gCREF_H_COLLECTION_METHOD_NAMEIII C C GBID! gBPROCEDURE### B B GA [ID]# 'A BEACH.NAME) gA BEACH.ID' gABEACH A A G@ [NAME]% '@NAME# g@REF_PROCEDURE_CODE555 @ @ G?NAME# g?REF_ACTIVITY_SOURCE_TYPEAAA ? ? G> [ID]# '> BEACH.NAME) g> BEACH.ID' g>BEACH > > G= [NAME]% '=NAME# g=REF_PERSON_ROLE_CODE999 = = G< ID! '<ID! g<PERSON < < G; [ID]# '; BEACH.NAME) g; BEACH.ID' g;BEACH ; ; G: [NAME]% ':NAME# g:REF_ORG_ROLE_CODE333 : : G9 ID! '9ID! g9BEACH 9 9 G8 ID! '8ID! g8ORGANIZATION))) 8 8 G7 [NAME]% '7NAME# g7REF_TELEPHONE_CODE555 7 7 G6 ID! '6ID! g6PERSON R%OAN M U K J: IH d`GF.rCx@ddd.*@*@MAILING_ADDRESS>>>>>>> _\tm3vO@,;:h@ELECTRONIC_ADDRESS{_ @nRRRFFFFFFFD @U 2vO@q= _h@BEACH_PROCEDURE_ASSIGN{_@mZZZNNNNNNNL @P{th@BPh@BEACH_POLLUTION{_@mLLL@@@@@@@> @H}1vO@.Xh@BEACH_PERSON_ROLE_ASSIGN{_ @l^^^RRRRRRRP @@̓0vO@)lRh@BEACH_ORGANIZATION_ROLE_ASSIGN{_ @kjjj^^^^^^^\ @<F^@+ah@BEACH_LATITUDE_LONGITUDE_COORDINATE{_ @jttthhhhhhhf @7@/vO@*QN@BEACH_ATTRIBUTE{_h fLLL@@@@@@@> @ _(.vO@Ih@BEACH_ACTIVITY_REASON{_b@gXXXLLLLLLLJ @I-vO@{Eh@BEACH_ACTIVITY{_ e fJJJ>>>>>>>< @,vO@^,?h@BEACH{_; @c888,,,,,,,* @Z-@*a@ATTRIBUTES{_|@a`@bNBB66666664 @Yz@ b@ACTIONS{_~@a`@SH<<0000000. @X݅e@݅e@~sq_f19) Beach Activity Station{_4MR2KeepLocal T```````^ @ _VU@U@~sq_f16) Lat Long{_4MR2KeepLocal TDDDDDDDB @_T j@ j@~sq_f14) Procedures{_4MR2KeepLocal THHHHHHHF @S_hQ@HóhQ@~sq_f13) Pollution Sources{_4MR2KeepLocal TVVVVVVVT @_Qk2"@k2"@~sq_f11) Organization Role Assign{_4MR2KeepLocal Tdddddddb @_O@@~sq_f09) Electronic Address{_4MR2KeepLocal TXXXXXXXV @N@@~sq_f08) Mailing Address{_4MR2KeepLocal TRRRRRRRP @_Lw@w@~sq_f06) Organization{_ @4MR2KeepLocal TXLLLLLLJ `_J(;@;@~sq_f03) Beach Attribute{_4MR2KeepLocal TRRRRRRRP @Ic@c@~sq_f02) Beach{_4MR2KeepLocal T~~~>>>>>>>< @He@e@~sq_c19) Beach Activity Station~sq_cCombo82{_4MR2KeepLocal Txxxxxxxv @_F(s@(s@~sq_c16) Lat Long~sq_cCombo31{_4MR2KeepLocal T\\\\\\\Z @_DL/@L/@~sq_c16) Lat Long~sq_cCombo119{_4MR2KeepLocal T^^^^^^^\ @CL/@L/@~sq_c16) Lat Long~sq_cCombo108{_4MR2KeepLocal T^^^^^^^\ @_?Wy@"< j B $  p R  j L .  n P 2  x H * vX:V8r( jL.n$0DCYACTION_DURATIONl@;// oYBA.ACTUAL_STOP_DATE2 gYBA.ACTUAL_START_DATE3 gYBA.ACTIVITY_CODE/ gYBEACH_NAMEB.NAME9%% oYBEACH_IDB.ID3!! oYREF_ACTIVITY_SOURCESOURCECC7 YREF_ACTIVITY_INDICATORINDICATOROO= YREF_ACTIVITY_REASONREASONCC7 YBEACH_ACTIVITYBA11- YBEACHB Y Y GXBEACH_ACTIVITY_STATION=== X  GX X GWBEACH_ACTIVITY_REASON;;; W  GW W GVBEACH_LATITUDE_LONGITUDE_COORDINATEWWW V  GV V GUBEACH_PROCEDURE_ASSIGN=== U  GU U GTPROCEDURE### T  GT T GSBEACH_POLLUTION/// S  GS S GRBEACH_PERSON_ROLE_ASSIGNAAA R  GR R GQBEACH_ORGANIZATION_ROLE_ASSIGNMMM Q  GQ Q GPTELEPHONE### P  GP P GOELECTRONIC_ADDRESS555 O  GO O GNMAILING_ADDRESS/// N  GN N GMPERSON M  GM M GL ORGANIZATION))) L  GL  L GK BEACH_ACTIVITY--- K  GK  K GJBEACH_ATTRIBUTE/// J  GJ J GIBEACH I  GI I GH [ACTIVITY_ID], 'HBEACH_ACTIVITY.NAME2 gHBEACH_ACTIVITY.ACTIVITY_CODE; gHBEACH_ACTIVITY.ACTIVITY_ID9 gHBEACH_ACTIVITY--- H H GG [ACTIVITY_ID], 'GBEACH_ACTIVITY.NAME2 gGBEACH_ACTIVITY.ACTIVITY_CODE; g @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @%%%% %&&&&  &' ' ' ' ' ((((( ()))) )***** *+ +"+#+ $+!,%,',(, ),&-*-,--- .-+./.1.2. 3.0/4/6/7/ 8/5090;0<0 =0:1>1@1A1 B1?2C2E2F2 G2D3H3J3K3 L3I4M4O4P4 Q4N5R5T5U5 V5S6W666 6X7777 788 8 8  8 9 999 9:::: :;;;;; ;<<< < !<="=$=%= &=#>'>)>*>+> ,>(?-?/?0?.@1@3@4@ 5@2A6A8A9A:A ;A7BB?B=C@CBCCC DCADEDGDHD IDFEJELEMENE OEKFPFRFSF TFQGUGWGXGGG GVHHHHHH  HI I I I JJJJKKKKLLLLMMMMNN N!NQ  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ O"O$O%O#P&P(P)P'Q*Q,Q-Q+R.R0R1R/S2S4S5S3T6T8T9T7U:U<U=U;V>V@VAV?WBWDWEWCXFXHXIXGYJYLYMYNYOYPYQYRYSYTYUYVYYY YYKZZZZZ Z Z Z Z ZZZZ ZZ[[[[[[[[[[[[[\ \"\#\$\%\&\'\(\)\*\+\,\ -\ .\ /\ 0\ 1\2\3\4\5\6\!]7]9]:];]8^<^>^?^@^=_A_C___BLVALR X  H  X L T @:B.ID=BA.FK_BEACH_ID AND B.ID=BP.FK_BEACH_IDIIf(BP.POLLUTION_SOURCE="UNKNOWN","YES","NO")IIf(BP.POLLUTION_SOURCE="OTHER","YES","NO")IIf(BP.POLLUTION_SOURCE="WILDLIFE","YES","NO")IIf(BP.POLLUTION_SOURCE="SEPTIC","YES","NO")IIf(BP.POLLUTION_SOURCE="SEWER_LINE","YES","NO")IIf(BP.POLLUTION_SOURCE="POTW","YES","NO")IIf(BP.POLLUTION_SOURCE="SSO","YES","NO")IIf(BP.POLLUTION_SOURCE="CSO","YES","NO")IIf(BP.POLLUTION_SOURCE="CAFO","YES","NO")IIf(BP.POLLUTION_SOURCE="BOAT","YES","NO")IIf(BP.POLLUTION_SOURCE="AGRICULTURAL","YES","NO")IIf(BP.POLLUTION_SOURCE="STORM","YES","NO")IIf(BP.POLLUTION_SOURCE="RUNOFF","YES","NO")BA.POLLUTION_SOURCES_INVESTIGATED(((B.ID)=BA.FK_BEACH_ID And (B.ID)=BLLC.FK_BEACH_ID))IIf(BLLC.END_LONGITUDE Is Null,"NO","YES")IIf(BLLC.END_LATITUDE Is Null,"NO","YES")IIf(BLLC.START_LONGITUDE Is Null,"NO","YES")IIf(BLLC.START_LATITUDE Is Null,"NO","YES")IIf(BA.BEACH_ACT_BEACH="Y","YES","NO")(((B.ID)=BA.FK_BEACH_ID) And (((BA.ACTIVITY_ID)=REASON.FK_ACTIVITY_ID And (BA.ACTIVITY_ID)=INDICATOR.FK_ACTIVITY_ID And (BA.ACTIVITY_ID)=SOURCE.FK_ACTIVITY_ID)))DateDiff("d",BA.ACTUAL_START_DATE,BA.ACTUAL_STOP_DATE)9DQn. < > n * Z  S  Wa7w1`Z(zFBc) _ G_ _ G^CLASS='REASON'- '^BEACH_ACTIVITY_REASON;;; ^ G^ ^ G]CLASS='INDICATOR'0 ']BEACH_ACTIVITY_REASON;;; ] G] ] G\V@ '\UNKNOWNZ@+ o\OTHERV@' o\WILDLIFE\@-!! o\SEPTICX@) o\ SEWER_LINE`@1%% o\ POTWT@% o\ SSOR@# o\ CSOR@# o\ CAFOT@ % o\BOATT@ % o\AGRICULTURALd@ 5)) o\STORMV@ ' o\RUNOFFX@ ) o\POLLUTION_SOURCES0 g\B@ g\BEACH_NAMEB.NAME9%% o\BEACH_IDB.ID3!! o\BEACH_POLLUTIONBP33/ \BEACH_ATTRIBUTEBA33/ \BEACHB \ \ G[B.ID=BA.FK_BEACH_ID2 '[OFF_SEASON_MONITOR_FREQ_UNITSBA.MONITOR_FREQ_UNITSnKK o[BA.OFF_MONITOR_FREQ2 g[SWIM_SEASON_MONITOR_FREQ_UNITSBA.MONITOR_FREQ_UNITSpMM o[BA.SWIM_MONITOR_FREQ3 g[BA.SWIM_SEASON_UNITS3 g[BA.SWIM_SEASON_LENGTH4 g[BEACH_NAMEB.NAME9%% o[BEACH_IDB.ID3!! o[BEACH_ATTRIBUTEBA33/ [BEACHB [ [ GZj@ 'Z END_LONGITUDET@7++ oZEND_LATITUDER@5)) oZSTART_LONGITUDEX@;// oZSTART_LATITUDEV@9-- oZBEACH_TIER_RANKBA.BEACH_TIERJ// oZBEACH_ACCESSIBILITYB.ACCESS_TYPER77 oZBEACH_ACT_BEACHL@;// oZBEACH_NAMEB.NAME9%% oZBEACH_IDB.ID3!! oZBEACH_LATITUDE_LONGITUDE_COORDINATEBLLC__W ZBEACH_ATTRIBUTEBA33/ ZBEACHB Z Z GYB@ 'Y ACTION_SOURCES SOURCE.TYPEF-- oYACTION_INDICATORSINDICATOR.TYPEO33 oYACTION_REASONS REASON.TYPEF-- o `Y$N  Y  Y x Y  Y  Y  Y  Y  Y C Y Nd Y O Y IDNAMEDESCRIPTIONCOMMENT"STATE_POSTAL_CODEFIPS_COUNTYWATERBODY_NAMEWATERBODY_TYPEACCESS_TYPEACCESS_COMMENTSEND_TO_EPAAGYYUYY@YHYPYYY.rD.rE.rF.rG.rH(FK_STATE_POSTAL_CODEIDPrimaryKeyv1 w] C  '  xd\L MP957808WEST HARBOR MARINAWEST HARBOR MARINAPACIFICMP69100PACIFICOPEN_COASTPUB_PUB_ACCYomm`TKA=4   MP905261JEFFREY'S BEACHJEFFREY'S BEACHPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYiggZNE;7.   MP901121HYATT HOTELHYATT HOTELPACIFICMP69110PACIFICOPEN_COASTPUB_PRV_ACCYa__RF=3/&   MP825132CORAL GARDEN BEACHCORAL GARDEN BEACHPACIFICMP69100PACIFICOPEN_COASTPRV_PUB_ACCYomm`TKA=4   MP771195S. PUERTO RICO DUMPS. PUERTO RICO DUMPPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYqoobVMC?6!   MP743331MANAGAHA BEACHESMANAGAHA BEACHESPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYkii\PG=90   MP706463NORTH LAULAU BEACHNORTH LAULAU BEACHPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYomm`TKA=4   MP633629NIKKO HOTELNIKKO HOTELPACIFICMP69110PACIFICOPEN_COASTPUB_PRV_ACCYa__RF=3/&   MP555804CENTRAL REPAIR SHOPCENTRAL REPAIR SHOPPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYqoobVMC?6!   MP469801DRAINAGE #2DRAINAGE #2PACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYa__RF=3/&   MP453911UNAI DANGKULO BEACHUNAI DANGKULO BEACHPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYqoobVMC?6!   MP425195SAN JOSE BEACHSAN JOSE BEACHPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYgeeXLC95,   MP423664SAMOAN HOUSING AREASAMOAN HOUSING AREAPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYqoobVMC?6!   MP412521OBYANOBYANPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYUSSF:1'#   MP283265DIAMOND HOTELDIAMOND HOTELPACIFICMP69110PACIFICOPEN_COASTPUB_PRV_ACCYeccVJA73*   MP274563DISTRICT #2 STORM DRAINAGEDISTRICT #2 STORM DRAINAGEPACIFICMP69100PACIFICOPEN_COASTPRV_PUB_ACCY}}pd[QMD(   MP272711GARAPAN FISHING DOCKGARAPAN FISHING DOCKPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYsqqdXOEA8"   MP234034DAI-ICHI HOTEL BEACHDAI-ICHI HOTEL BEACHPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYsqqdXOEA8"   MP227159SOUTH LAULAU BEACHSOUTH LAULAU BEACHPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYomm`TKA=4   MP198597DPW CHANNEL BRIDGEDPW CHANNEL BRIDGEPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYomm`TKA=4   MP178951TANAPAG MEETING HALLTANAPAG MEETING HALLPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYsqqdXOEA8"   MP142032CHALAN PIAO BEACHCHALAN PIAO BEACHPACIFICMP69110PACIFICOPEN_COASTPUB_PUB_ACCYmkk^RI?;2  Z  @ @ @`f`f`f`f`f`f`f`f`f`f `f `f `f `f `f`f`f`f`f`f`f`f @ @ @ `f8>:6<:`f8DFH@8`f8HF@HD`f::D8@H`f:<>6<>`f:D:D88`f:D>@B<`f:F<:B@`f>8:@:8`f>: `f>:@8H@ `f>@BHF68 `f@@@F6> `fB<B<`fD><<<8`fDD88H@`fF:@8<:`fH688:8`fH6@:B8`fH@DF6F @ @ @ `f8>:6<:`f8DFH@8`f8HF@HD`f::D8@H`f:<>6<>`f:D:D88`f:D>@B<`f:F<:B@`f>8:@:8`f>: `f>:@8H@ `f>@BHF68 `f@@@F6> `fB<B<`fD><<<8`fDD88H@`fF:@8<:`fH688:8`fH6@:B8`fH@DF6F Y,$N  ,,,,,,Y  Y   Y   Y  xY Y   Y   Y  Y Y   Y    Y   ACTIVITY_IDFK_BEACH_IDACTIVITY_CODENAME"ACTUAL_START_DATE ACTUAL_STOP_DATEDESCRIPTIONCOMMENT(EXTENT_START_MEASUREEXTENT_LENGTH,EXTENT_UNIT_OF_MEASURESEND_TO_EPA$%&.r'-Y(YYYYY.rFL{4AC36A5A-98EC-415A-BB9A-B212AC9D59F3}BEACH_ID FK_ACTIVITY_TYPEKEYPrimaryKeyHv1b@   !@  @@@@   @@68`JYb`Qbo+ kmJimWQiQ+ 6:LQJMW6<LQJMWJmmiYLomQ6>LQJMWJMmYqYmv6@Mokmd`u`^UQbQiJmYdb6BdiUJbYxJmYdb6DfQikdb6F`JY^YbUJOOiQkk6HQ^QMmidbYMJOOiQkk86mQ^QfWdbQ88diUJbYxJmYdbid^QJkkYUb8:fQikdbid^QJkkYUb8<fd^^omYdbkdoiMQk8>fidMQOoiQk8@fidMQOoiQJkkYUb8B^Jm^dbU 8DUQbQiJmQu`^!8FLQJMWJMmYqYmviQJkdb"8HLQJMWJMmYqYmvkmJmYdb#`dOMokmd`u`^$`dOUQbQiJmQu`^%`dOfiQqJ^u`^&`dOkWJiQOu`^'JMmYdbkiQfdim(JmmiYLomQkiQfdim)`dbYmdiYbUiQfdim*fd^^omYdbkdoiMQiQfdim+JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+M6:LQJMW+kh+MMd`Ld<8+kh+M6<LQJMWJmmiYLomQ+kh+MMd`Ld86B+kh+M6<LQJMWJmmiYLomQ+kh+MMd`Ld86H+kh+M6<LQJMWJmmiYLomQ+kh+MMd`Ld8F+kh+M6>LQJMWJMmYqYmv+kh+MMd`Ld86B+kh+M6>LQJMWJMmYqYmv+kh+MMd`Ld8F+kh+M6>LQJMWJMmYqYmv+kh+MMd`Ld:<+kh+M6BdiUJbYxJmYdb+kh+MMd`LdF8+kh+M6DfQikdb+kh+MMd`LdF8 +kh+M6F`JY^YbUJOOiQkk+kh+MMd`LdFB +kh+M6F`JY^YbUJOOiQkk+kh+MMd`LdFF +kh+M6F`JY^YbUJOOiQkk+kh+MMd`LdH6 +kh+M6HQ^QMmidbYMJOOiQkk+kh+MMd`LdFB +kh+M6HQ^QMmidbYMJOOiQkk+kh+MMd`LdFF+kh+M6HQ^QMmidbYMJOOiQkk+kh+MMd`LdH6+kh+M86mQ^QfWdbQ+kh+MMd`Ld<8+kh+M86mQ^QfWdbQ+kh+MMd`LdFB+kh+M86mQ^QfWdbQ+kh+MMd`LdFF+kh+M86mQ^QfWdbQ+kh+MMd`LdH6+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdFB+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdFF+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdH6+kh+M8:fQikdbid^QJkkYUb+kh+MMd`Ld8F+kh+M8:fQikdbid^QJkkYUb+kh+MMd`LdFB+kh+M8:fQikdbid^QJkkYUb+kh+MMd`LdH6+kh+M8<fd^^omYdbkdoiMQk+kh+MMd`Ld8F+kh+M8<fd^^omYdbkdoiMQk+kh+MMd`LdFB+kh+M8>fidMQOoiQk+kh+MMd`LdF8+kh+M8@fidMQOoiQJkkYUb+kh+MMd`Ld8F+kh+M8@fidMQOoiQJkkYUb+kh+MMd`LdF8+kh+M8B^Jm^dbU+kh+MMd`Ld86F+kh+M8B^Jm^dbU+kh+MMd`Ld88H+kh+M8B^Jm^dbU+kh+MMd`Ld8F+kh+M8B^Jm^dbU+kh+MMd`Ld<8+kh+M8FLQJMWJMmYqYmviQJkdb+kh+MMd`LdF:+kh+M8HLQJMWJMmYqYmvkmJmYdb+kh+MMd`LdF:+kh+S6:LQJMW+kh+S6<LQJMWJmmiYLomQ+kh+S6>LQJMWJMmYqYmv +kh+S6BdiUJbYxJmYdb +kh+S6DfQikdb +kh+S6F`JY^YbUJOOiQkk +kh+S6HQ^QMmidbYMJOOiQkk +kh+S86mQ^QfWdbQ+kh+S88diUJbYxJmYdbid^QJkkYUb+kh+S8:fQikdbid^QJkkYUb+kh+S8<fd^^omYdbkdoiMQk+kh+S8>fidMQOoiQk+kh+S8@fidMQOoiQJkkYUb+kh+S8B^Jm^dbU+kh+S8FLQJMWJMmYqYmviQJkdb+kh+S8HLQJMWJMmYqYmvkmJmYdbJMmYdbkJmmiYLomQkLQJMW`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO Q@ @ @@@  @  @@ @ @@@ @ @@ @@+kh+M86mQ^QfWdbQ+kh+MMd`LdFF+kh+M86mQ^QfWdbQ+kh+MMd`LdH6+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdFB+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdFF+kh+M88diUJbYxJmYdbid^QJkkYUb+kh+MMd`LdH6+kh+M8:fQikdbid^QJkkYUb+kh+MMd`Ld8F+kh+M8:fQikdbid^QJkkYUb+kh+MMd`LdFB+kh+M8:fQikdbid^QJkkYUb+kh+MMd`LdH6+kh+M8<fd^^omYdbkdoiMQk+kh+MMd`Ld8F+kh+M8<fd^^omYdbkdoiMQk+kh+MMd`LdFB+kh+M8>fidMQOoiQk+kh+MMd`LdF8+kh+M8@fidMQOoiQJkkYUb+kh+MMd`Ld8F+kh+M8@fidMQOoiQJkkYUb+kh+MMd`LdF8+kh+M8B^Jm^dbU+kh+MMd`Ld86F+kh+M8B^Jm^dbU+kh+MMd`Ld88H+kh+M8B^Jm^dbU+kh+MMd`Ld8F+kh+M8B^Jm^dbU+kh+MMd`Ld<8+kh+M8FLQJMWJMmYqYmviQJkdb+kh+MMd`LdF:+kh+M8HLQJMWJMmYqYmvkmJmYdb+kh+MMd`LdF:+kh+S6:LQJMW+kh+S6<LQJMWJmmiYLomQ+kh+S6>LQJMWJMmYqYmv +kh+S6BdiUJbYxJmYdb +kh+S6DfQikdb +kh+S6F`JY^YbUJOOiQkk +kh+S6HQ^QMmidbYMJOOiQkk +kh+S86mQ^QfWdbQ+kh+S88diUJbYxJmYdbid^QJkkYUb+kh+S8:fQikdbid^QJkkYUb+kh+S8<fd^^omYdbkdoiMQk+kh+S8>fidMQOoiQk+kh+S8@fidMQOoiQJkkYUb+kh+S8B^Jm^dbU+kh+S8FLQJMWJMmYqYmviQJkdb+kh+S8HLQJMWJMmYqYmvkmJmYdbJMmYdbkJmmiYLomQkLQJMWLQJMW+JMmYqYmvLQJMW+JMmYqYmv+iQJkdbLQJMW+JMmYqYmv+kmJmYdbLQJMW+JmmiYLomQLQJMW+^JmYmoOQ+^dbUYmoOQ+MddiOYbJmQLQJMW+diUJbYxJmYdb+id^Q+JkkYUbLQJMW+fQikdb+id^Q+JkkYUb LQJMW+fd^^omYdb!LQJMW+fidMQOoiQ+JkkYUb"Q^QMmidbYM+JOOiQkk#`JY^YbU+JOOiQkk$`dbYmdiYbUn`kvkJMMQkkdL[QMmkn`kvkJMMQkku`^n`kvkJMQk`kvkbJqfJbQUidofMJmQUdiYQkn`kvkbJqfJbQUidofkn`kvkbJqfJbQUidofmddL[QMmkn`kvkbJqfJbQdL[QMmYOkn`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkdiUJbYxJmYdbnfQikdbnfd^^omYdb+kdoiMQkn fidMQOoiQn iQS+JMMQkk+mvfQn iQS+JMmYqYmv+MdOQn iQS+JMmYqYmv+YbOYMJmdin iQS+JMmYqYmv+YbOYMJmdi+mvfQniQS+JMmYqYmv+iQJkdbniQS+JMmYqYmv+iQJkdb+mvfQniQS+JMmYqYmv+kdoiMQniQS+JMmYqYmv+kdoiMQ+mvfQniQS+OJmJLJkQ+qQikYdbniQS+Q^QMmidbYM+`JY^YbU+MdOQniQS+SiQhoQbMv+obYmniQS+W+Md^^QMmYdb+`QmWdO+bJ`QniQS+W+iQSQiQbMQ+OJmo`+bJ`QniQS+`JY^YbU+MdOQniQS+`QJkoiQ`Qbm+obYmniQS+diU+MdOQniQS+diU+id^Q+MdOQniQS+fQikdb+id^Q+MdOQniQS+fidMQOoiQ+MdOQniQS+kmJmQ+fdkmJ^+MdOQniQS+mQ^QfWdbQ+MdOQniQS+sJmQi+LdOv+bJ`Qn iQS+sJmQi+LdOv+mvfQn!mQ^QfWdbQn"JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO+ 66DLOSOMBFQ<>6QDHDHS:JSF:LO@6F<@<>@>>FJJJ+ +;K[n$+ 6MLB8S:@QOJB>>:JHLSJQ@BH8S>8JS86+ +;K[n%+ 8SL::B6@DBM:>S:>FO6B6HD@@M6LBMD8HFM>LH6BJ@HHOM>D+ +;K[P u v } y |xtpnljhd UUUUu@UUUUUu@CMP771195CONTAM_ADVS. PUERTO RICO DUMPsigns posted by city & countyFTYnlhII4( UUUUUs@UUUUs@CMP771195CONTAM_ADVS. PUERTO RICO DUMPsigns posted by city & countyFTYnlhII4( UUUUUz@UUUUz@CMP198597CONTAM_ADVDPW CHANNEL BRIDGEsigns posted by city & countyFTYmkgHH4( UUUUuy@UUUUy@CMP198597CONTAM_ADVDPW CHANNEL BRIDGEsigns posted by city & countyFTYmkgHH4( UUUUw@UUUUw@CMP198597CONTAM_ADVDPW CHANNEL BRIDGEsigns posted by city & countyFTYmkgHH4( UUUUv@UUUUw@CMP198597CONTAM_ADVDPW CHANNEL BRIDGEsigns posted by city & countyFTYmkgHH4( UUUUu@UUUUUu@CMP198597CONTAM_ADVDPW CHANNEL BRIDGEsigns posted by city & countyFTYmkgHH4( UUUUUs@UUUUs@CMP198597CONTAM_ADVDPW CHANNEL BRIDGEsigns posted by city & countyFTYmkgHH4( UUUUur@UUUUr@CMP198597CONTAM_ADVDPW CHANNEL BRIDGEsigns posted by city & countyFTYmkgHH4( UUUUq@UUUUq@CMP198597CONTAM_ADVDPW CHANNEL BRIDGEsigns posted by city & countyFTYmkgHH4( UUUU5{@UUUUu{@CMP555804CONTAM_ADVCENTRAL REPAIR SHOPsigns posted by city & countyFTYnlhII4( UUUUUz@UUUUz@CMP555804CONTAM_ADVCENTRAL REPAIR SHOPsigns posted by city & countyFTYnlhII4( UUUUuy@UUUUy@CMP555804CONTAM_ADVCENTRAL REPAIR SHOPsigns posted by city & countyFTYnlhII4( UUUUx@UUUUx@CMP555804CONTAM_ADVCENTRAL REPAIR SHOPsigns posted by city & countyFTYnlhII4( UUUUw@UUUUw@CMP555804CONTAM_ADVCENTRAL REPAIR SHOPsigns posted by city & countyFTYnlhII4( UUUUv@UUUUw@CMP555804CONTAM_ADVCENTRAL REPAIR SHOPsigns posted by city & countyFTYnlhII4( UUUUur@UUUUr@CMP178951CONTAM_ADVTANAPAG MEETING HALLsigns posted by city & countyFTYomiJJ4( UUUUx@UUUUx@CMP633629CONTAM_ADVNIKKO HOTELsigns posted by city & countyFTYfd`AA4( UUUUux@UUUUx@CMP453911CONTAM_ADVUNAI DANGKULO BEACHsigns posted by city & countyFTYnlhII4( UUUUu@UUUUu@CMP453911CONTAM_ADVUNAI DANGKULO BEACHsigns posted by city & countyFTYnlhII4( UUUUs@UUUU5t@CMP453911CONTAM_ADVUNAI DANGKULO BEACHsigns posted by city & countyFTYnlhII4( UUUU5r@UUUUur@CMP453911CONTAM_ADVUNAI DANGKULO BEACHsigns posted by city & countyFTYnlhII4( UUUUux@UUUUx@CMP412521CONTAM_ADVOBYANsigns posted by city & countyFTY`^Z;;4( UUUUus@UUUUs@CMP227159CONTAM_ADVSOUTH LAULAU BEACHsigns posted by city & countyFTYmkgHH4( UUUUs@UUUU5t@CMP706463CONTAM_ADVNORTH LAULAU BEACHsigns posted by city & countyFTYmkgHH4( UUUU5s@UUUUus@CMP905261CONTAM_ADVJEFFREY'S BEACHsigns posted by city & countyFTYjhdEE4( UUUU5r@UUUUur@CMP274563CONTAM_ADVDISTRICT #2 STORM DRAINAGEsigns posted by city & countyFTYusoPP4( UUUU5r@UUUUur@CMP957808CONTAM_ADVWEST HARBOR MARINAsigns posted by city & countyFTYmkgHH4( UUUUt@UUUUu@CMP825132CONTAM_ADVCORAL GARDEN BEACHsigns posted by city & countyFTYmkgHH4( UUUU5r@UUUUur@CMP825132CONTAM_ADVCORAL GARDEN BEACHsigns posted by city & countyFTYmkgHH4( UUUUux@UUUUx@CMP743331CONTAM_ADVMANAGAHA BEACHESsigns posted by city & countyFTYkieFF4(T    ~ x x | ,UUUUur@UUUUr@CMP142032CONTAM_ADVCHALAN PIAO BEACHsigns posted by city & countyFTYljfGG4( +UUUUu@UUUU5v@CMP283265CONTAM_ADVDIAMOND HOTELsigns posted by city & countyFTYhfbCC4( *UUUUur@UUUUr@CMP425195CONTAM_ADVSAN JOSE BEACHsigns posted by city & countyFTYigcDD4( )UUUU5{@UUUUu{@CMP272711CONTAM_ADVGARAPAN FISHING DOCKsigns posted by city & countyFTYomiJJ4( (UUUUu@UUUU5v@CMP272711CONTAM_ADVGARAPAN FISHING DOCKsigns posted by city & countyFTYomiJJ4( 'UUUUu@UUUUUu@CMP272711CONTAM_ADVGARAPAN FISHING DOCKsigns posted by city & countyFTYomiJJ4( &UUUUUs@UUUUs@CMP272711CONTAM_ADVGARAPAN FISHING DOCKsigns posted by city & countyFTYomiJJ4( %UUUUur@UUUUr@CMP272711CONTAM_ADVGARAPAN FISHING DOCKsigns posted by city & countyFTYomiJJ4( $UUUUq@UUUUq@CMP272711CONTAM_ADVGARAPAN FISHING DOCKsigns posted by city & countyFTYomiJJ4( #UUUU5{@UUUUu{@CMP469801CONTAM_ADVDRAINAGE #2signs posted by city & countyFTYfd`AA4( "UUUU5{@UUUUu{@CMP423664CONTAM_ADVSAMOAN HOUSING AREAsigns posted by city & countyFTYnlhII4( !UUUU5{@UUUUu{@CMP234034CONTAM_ADVDAI-ICHI HOTEL BEACHsigns posted by city & countyFTYomiJJ4( UUUU5{@UUUUu{@CMP901121CONTAM_ADVHYATT HOTELsigns posted by city & countyFTYfd`AA4( @ @ @ @ @ @ `f8>:6<:# `f8DFH@8"`f8HF@HD"`f8HF@HD"`f8HF@HD"`f8HF@HD"`f8HF@HD"`f8HF@HD"`f8HF@HD"`f8HF@HD"`f::D8@H"`f:<>6<>#`f:D:D88#`f:D:D88#`f:D:D88#`f:D:D88#`f:D:D88#`f:D:D88# `f:D>@B<"`f:F<:B@# `f>8:@:8"`f>:#`f>:@8H@# `f>@@@@BHF68#`f@@@F6>"`f@@@F6>"`f@@@F6>"`f@@@F6>"`f@@@F6>"`f@@@F6>"`fB<B<"`fD><<<8"`fDD88H@"`fDD88H@"`fF:@8<:"`fF:@8<:"`fH688:8#`fH6@:B8"`fH@DF6F" @@@@@@@@@@@MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq" MdbmJ`+JOq" MdbmJ`+JOq" MdbmJ`+JOq" MdbmJ`+JOq" MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq"MdbmJ`+JOq#MdbmJ`+JOq#MdbmJ`+JOq#MdbmJ`+JOq#MdbmJ`+JOq#MdbmJ`+JOq#MdbmJ`+JOq#MdbmJ`+JOq#MdbmJ`+JOq#MdbmJ`+JOq# MdbmJ`+JOq# MdbmJ`+JOq# MdbmJ`+JOq#   @ @ @ @ @"""""""" " "  "  "  " " """"""""""""""""" #!#"###$#%#&#'#(#)# *# +# ,#   @ @ @ @ @"""""""" " "  "  "  " " """"""""""""""""" #!#"###$#%#&#'#(#)# *# +# ,# 0 Y+v$x%N)),Y Y  Y d Y Fx Y FKEYFK_ACTIVITY_ID CLASSTYPEDESCRIPTION)-).Y)/YYYYL{C6AD4CA2-2760-44E2-9CBE-69A950A9B87A}ACTIVITY_IDKEY1PrimaryKeyv1@ 2(?{FM M  ^  e  e 0 v 7 }7}H O O`!g!g2x9?INDICATORENTEROEnterococci* >SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; =REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 <INDICATORENTEROEnterococci* ;SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; :REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 9INDICATORENTEROEnterococci* 8SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; 7REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 6INDICATORENTEROEnterococci* 5SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; 4REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 3INDICATORENTEROEnterococci* 2SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; 1REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 0INDICATORENTEROEnterococci* /SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; .REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 -INDICATORENTEROEnterococci* ,SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; +REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 *INDICATORENTEROEnterococci* )SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; (REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 ' INDICATORENTEROEnterococci* & SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; % REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 $ INDICATORENTEROEnterococci* # SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; " REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 ! INDICATORENTEROEnterococci*  SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF;  REASONELEV_BACTEXCEEDED ENTEROCOCCUS4  INDICATORENTEROEnterococci*  SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF;  REASONELEV_BACTEXCEEDED ENTEROCOCCUS4  INDICATORENTEROEnterococci*  SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF;  REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 INDICATORENTEROEnterococci* SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 INDICATORENTEROEnterococci* SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 INDICATORENTEROEnterococci* SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 INDICATORENTEROEnterococci* SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF;  REASONELEV_BACTEXCEEDED ENTEROCOCCUS4  INDICATORENTEROEnterococci*  SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF;  REASONELEV_BACTEXCEEDED ENTEROCOCCUS4  INDICATORENTEROEnterococci* SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 INDICATORENTEROEnterococci* SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 INDICATORENTEROEnterococci* SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 2(?{FM M  ^  e  e 0 v 7 }7}H O O`!g!g2x9~*INDICATORENTEROEnterococci* }*SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; |*REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 {)INDICATORENTEROEnterococci* z)SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; y)REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 x(INDICATORENTEROEnterococci* w(SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; v(REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 u'INDICATORENTEROEnterococci* t'SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; s'REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 r&INDICATORENTEROEnterococci* q&SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; p&REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 o%INDICATORENTEROEnterococci* n%SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; m%REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 l$INDICATORENTEROEnterococci* k$SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; j$REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 i#INDICATORENTEROEnterococci* h#SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; g#REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 f"INDICATORENTEROEnterococci* e"SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; d"REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 c!INDICATORENTEROEnterococci* b!SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; a!REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 ` INDICATORENTEROEnterococci* _ SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; ^ REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 ]INDICATORENTEROEnterococci* \SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; [REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 ZINDICATORENTEROEnterococci* YSOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; XREASONELEV_BACTEXCEEDED ENTEROCOCCUS4 WINDICATORENTEROEnterococci* VSOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; UREASONELEV_BACTEXCEEDED ENTEROCOCCUS4 TINDICATORENTEROEnterococci* SSOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; RREASONELEV_BACTEXCEEDED ENTEROCOCCUS4 QINDICATORENTEROEnterococci* PSOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; OREASONELEV_BACTEXCEEDED ENTEROCOCCUS4 NINDICATORENTEROEnterococci* MSOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; LREASONELEV_BACTEXCEEDED ENTEROCOCCUS4 KINDICATORENTEROEnterococci* JSOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; IREASONELEV_BACTEXCEEDED ENTEROCOCCUS4 HINDICATORENTEROEnterococci* GSOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; FREASONELEV_BACTEXCEEDED ENTEROCOCCUS4 EINDICATORENTEROEnterococci* DSOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; CREASONELEV_BACTEXCEEDED ENTEROCOCCUS4 BINDICATORENTEROEnterococci* ASOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; @REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 r({F,INDICATORENTEROEnterococci* ,SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; ,REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 +INDICATORENTEROEnterococci* +SOURCESTORMSTORM RELATED/WET-WEATHER RUNOFF; +REASONELEV_BACTEXCEEDED ENTEROCOCCUS4 | ( @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @********** * * * * ********** * * * * * * * * *  *! *" *# *$ *% *&*'*(*)***+*,*-*.*/*0*1*2*3*4*5*6*7*8*9*:*;*<*=*>++++++++++ + + + + ++++++++++++++++ + + + !+!!+"!+#"+$"+%"+&#+'#+(#+)$+*$++$+,%+-%+.%+/&+0&+1&+2'+3'+4'+5(+6(+7(+8)+9)+:)+;*+<*+=*+>+,+,+,,,,,,,| ( @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @******** * *  *  *  * * ***************** *!* "*!#*"$*#%*$&*%'*&(*')*(**)+**,*+-*,.*-/*.0*/1*02*13*24*35*46*57*68*79*8:*9;*:<*;=*<>*=?*>@+A+B+C+D+E+F+G+H+I+ J+ K+ L+ M+ N+O+P+Q+R+S+T+U+V+W+X+Y+Z+[+\+]+^+_+`+ a+!b+"c+#d+$e+%f+&g+'h+(i+)j+*k++l+,m+-n+.o+/p+0q+1r+2s+3t+4u+5v+6w+7x+8y+9z+:{+;|+<}+=~+>,,,,,,| ( @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @******** * *  *  *  * * ***************** *!* "*!#*"$*#%*$&*%'*&(*')*(**)+**,*+-*,.*-/*.0*/1*02*13*24*35*46*57*68*79*8:*9;*:<*;=*<>*=?*>@+A+B+C+D+E+F+G+H+I+ J+ K+ L+ M+ N+O+P+Q+R+S+T+U+V+W+X+Y+Z+[+\+]+^+_+`+ a+!b+"c+#d+$e+%f+&g+'h+(i+)j+*k++l+,m+-n+.o+/p+0q+1r+2s+3t+4u+5v+6w+7x+8y+9z+:{+;|+<}+=~+>,,,,,,l Y,,N11,,,,,,,Y Y  Y 0KEYFK_ACTIVITY_IDSTATION_ID%0d%0d13d0%%0d%0d14d0%%0d%0d15d0%%0d%0d16d0%YYYYFK_ACTIVITY_IDKEY1PrimaryKeySTATION_IDHv1b@  0,y^C( kP5 x ] B ' j O 4  w \ ,,MP142032 ++MP283265 **MP425195 ))MP272711 ((MP272711 ''MP272711 &&MP272711 %%MP272711 $$MP272711 ##MP469801 ""MP423664 !!MP234034  MP901121 MP771195 MP771195 MP198597 MP198597 MP198597 MP198597 MP198597 MP198597 MP198597 MP198597 MP555804 MP555804 MP555804 MP555804 MP555804 MP555804 MP178951 MP633629  MP453911  MP453911  MP453911  MP453911  MP412521 MP227159 MP706463 MP905261 MP274563 MP957808 MP825132 MP825132 MP743331  0 @ @ @ @ @22222222 2 2  2  2  2 2 22222222222222222 2!2 "2!#2"$2#%2$&2%'2&(2')2(*2)+2*,2+ 0 @ @ @ @ @22222222 2 2  2  2  2 2 22222222222222222 2!2 "2!#2"$2#%2$&2%'2&(2')2(*2)+2*,2+ 0 @ @ @ @ @22222222 2 2  2  2  2 2 22222222222222222 2!2 "2!#2"$2#%2$&2%'2&(2')2(*2)+2*,2+ 0@ @ @ @ @ @ `f8>:6<:2+`f8DFH@82`f8HF@HD2`f8HF@HD2`f8HF@HD2`f8HF@HD2`f8HF@HD2`f8HF@HD2`f8HF@HD2`f8HF@HD2`f::D8@H2`f:<>6<>2 `f:D:D882#`f:D:D882$`f:D:D882%`f:D:D882&`f:D:D882'`f:D:D882(`f:D>@B<2`f:F<:B@2*`f>8:@:82`f>:2!`f>:@8H@2)`f>@@@@BHF682"`f@@@F6>2`f@@@F6>2`f@@@F6>2`f@@@F6>2`f@@@F6>2`f@@@F6>2`fB<B<2`fD><<<82`fDD88H@2`fDD88H@2`fF:@8<:2`fF:@8<:2`fH688:82`fH6@:B82`fH@DF6F2{ }YN 88 Y Y Y Y @d Y d0Y Y Y Y  Y  0%dY  Y    Y  d0d Y  0% Y %d Y d Y  d0 Y  0%FK_BEACH_IDEFFECTIVE_YEAREXTENT_LENGTHEXTENT_UNITSBEACH_ACT_BEACHBEACH_TIER,SWIM_SEASON_START_DATE(SWIM_SEASON_END_DATE$SWIM_SEASON_LENGTH"SWIM_SEASON_UNITS"SWIM_MONITOR_FREQ OFF_MONITOR_FREQ$MONITOR_FREQ_UNITS*MONITORED_IRREGULARLY<MONITORED_IRREGULARLY_COMMENTS"POLLUTION_SOURCES<POLLUTION_SOURCES_INVESTIGATEDSEND_TO_EPA8:8;YYFK_BEACH_IDPrimaryKeyv17 p@@@ MP9578080uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP9052610uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP9011210uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP8251320uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP7711950uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP7433310uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP7064630uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP6336290uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP5558040uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP4698010uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP4539110uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP4251950uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP4236640uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP4125210uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP2832650uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP2745630uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP2727110uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP2340340uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP2271590uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP1985970uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP1789510uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0& p@@@ MP1420320uFTYMONTHSPER_WEEKNNYNYca_][YOGEA0&  7@ @ @ `f8>:6<:9`f8DFH@89`f8HF@HD9`f::D8@H9`f:<>6<>9`f:D:D889`f:D>@B<9`f:F<:B@9`f>8:@:89`f>:9 `f>:@8H@9 `f>@BHF689 `f@@@F6>9 `fB<B<9`fD><<<89`fDD88H@9`fF:@8<:9`fH688:89`fH6@:B89`fH@DF6F9h 7`f8>:6<:9`f8DFH@89`f8HF@HD9`f::D8@H9`f:<>6<>9`f:D:D889`f:D>@B<9`f:F<:B@9`f>8:@:89`f>:9 `f>:@8H@9 `f>@BHF689 `f@@@F6>9 `fB<B<9`fD><<<89`fDD88H@9`fF:@8<:9`fH688:89`fH6@:B89`fH@DF6F92 Y,N  ==, Y Y Y Y Y Y   Y $d Y $d Y $fFK_BEACH_IDSTART_LATITUDESTART_LONGITUDEEND_LATITUDEEND_LONGITUDE SOURCE_MAP_SCALE8REF_H_COLLECTION_METHOD_NAME4REF_H_REFERENCE_DATUM_NAMEDESCRIPTION$f$$f$=?$f$YBEACH_IDv1@@<,TR P N L J H FDB@><:8 H.@|a2U6b@H.@|a2U6b@MP142032GPS-UNSPECIFIEDNAD83HHA0& nR.@"~6b@nR.@"~6b@MP283265GPS-UNSPECIFIEDNAD83HHA0& .!U.@lV}6b@.!U.@lV}6b@MP425195GPS-UNSPECIFIEDNAD83HHA0& Bfj.@q6b@Bfj.@q6b@MP272711GPS-UNSPECIFIEDNAD83HHA0& Bfj.@q6b@Bfj.@q6b@MP272711GPS-UNSPECIFIEDNAD83HHA0& Bfj.@q6b@Bfj.@q6b@MP272711GPS-UNSPECIFIEDNAD83HHA0& Bfj.@q6b@Bfj.@q6b@MP272711GPS-UNSPECIFIEDNAD83HHA0& Bfj.@q6b@Bfj.@q6b@MP272711GPS-UNSPECIFIEDNAD83HHA0& Bfj.@q6b@Bfj.@q6b@MP272711GPS-UNSPECIFIEDNAD83HHA0& Bfj.@q6b@Bfj.@q6b@MP469801GPS-UNSPECIFIEDNAD83HHA0& h"l.@7A`6b@ h"l.@7A`6b@MP423664GPS-UNSPECIFIEDNAD83HHA0& m.@7A`6b@m.@7A`6b@MP234034GPS-UNSPECIFIEDNAD83HHA0& ;On.@q6b@;On.@q6b@MP901121GPS-UNSPECIFIEDNAD83HHA0& {p.@a+e7b@{p.@a+e7b@MP771195GPS-UNSPECIFIEDNAD83HHA0& {p.@a+e7b@{p.@a+e7b@MP771195GPS-UNSPECIFIEDNAD83HHA0& k+s.@K=7b@k+s.@K=7b@MP198597GPS-UNSPECIFIEDNAD83HHA0& k+s.@K=7b@k+s.@K=7b@MP198597GPS-UNSPECIFIEDNAD83HHA0& k+s.@K=7b@k+s.@K=7b@MP198597GPS-UNSPECIFIEDNAD83HHA0& k+s.@K=7b@k+s.@K=7b@MP198597GPS-UNSPECIFIEDNAD83HHA0& k+s.@K=7b@k+s.@K=7b@MP198597GPS-UNSPECIFIEDNAD83HHA0& k+s.@K=7b@k+s.@K=7b@MP198597GPS-UNSPECIFIEDNAD83HHA0& k+s.@K=7b@k+s.@K=7b@MP198597GPS-UNSPECIFIEDNAD83HHA0& k+s.@K=7b@k+s.@K=7b@MP198597GPS-UNSPECIFIEDNAD83HHA0& -Cv.@V/7b@-Cv.@V/7b@MP555804GPS-UNSPECIFIEDNAD83HHA0& -Cv.@V/7b@-Cv.@V/7b@MP555804GPS-UNSPECIFIEDNAD83HHA0& -Cv.@V/7b@-Cv.@V/7b@MP555804GPS-UNSPECIFIEDNAD83HHA0& -Cv.@V/7b@-Cv.@V/7b@MP555804GPS-UNSPECIFIEDNAD83HHA0& -Cv.@V/7b@-Cv.@V/7b@MP555804GPS-UNSPECIFIEDNAD83HHA0& -Cv.@V/7b@-Cv.@V/7b@MP555804GPS-UNSPECIFIEDNAD83HHA0& xz,C|.@H}8b@xz,C|.@H}8b@MP178951GPS-UNSPECIFIEDNAD83HHA0& H..@-C8b@H..@-C8b@MP633629GPS-UNSPECIFIEDNAD83HHA0& _Q:.@ r6b@_Q:.@ r6b@MP453911GPS-UNSPECIFIEDNAD83HHA0& _Q:.@ r6b@_Q:.@ r6b@MP453911GPS-UNSPECIFIEDNAD83HHA0& _Q:.@ r6b@_Q:.@ r6b@MP453911GPS-UNSPECIFIEDNAD83HHA0& _Q:.@ r6b@_Q:.@ r6b@MP453911GPS-UNSPECIFIEDNAD83HHA0& hs5.@/$7b@hs5.@/$7b@MP412521GPS-UNSPECIFIEDNAD83HHA0& d`TR.@\(8b@d`TR.@\(8b@MP227159GPS-UNSPECIFIEDNAD83HHA0& N@S.@!u8b@N@S.@!u8b@MP706463GPS-UNSPECIFIEDNAD83HHA0& l gs.@Zd;O9b@l gs.@Zd;O9b@MP905261GPS-UNSPECIFIEDNAD83HHA0& H,@Bi$b@H,@Bi$b@MP274563GPS-UNSPECIFIEDNAD83HHA0& 1ZD,@|a2U0$b@1ZD,@|a2U0$b@MP957808GPS-UNSPECIFIEDNAD83HHA0& !uq;,@=U%b@!uq;,@=U%b@MP825132GPS-UNSPECIFIEDNAD83HHA0& !uq;,@=U%b@!uq;,@=U%b@MP825132GPS-UNSPECIFIEDNAD83HHA0& %u{.@+6b@%u{.@+6b@MP743331GPS-UNSPECIFIEDNAD83HHA0& <@ @ @ @ @ @ `f8>:6<:>+`f8DFH@8>`f8HF@HD>`f8HF@HD>`f8HF@HD>`f8HF@HD>`f8HF@HD>`f8HF@HD>`f8HF@HD>`f8HF@HD>`f::D8@H>`f:<>6<>> `f:D:D88>#`f:D:D88>$`f:D:D88>%`f:D:D88>&`f:D:D88>'`f:D:D88>(`f:D>@B<>`f:F<:B@>*`f>8:@:8>`f>:>!`f>:@8H@>)`f>@ `f>@ `f>@ `f>@ `f>BHF68>"`f@@@F6>>`f@@@F6>>`f@@@F6>>`f@@@F6>>`f@@@F6>>`f@@@F6>>`fB< `fD6B>B<>`fD><<<8>`fDD88H@>`fDD88H@>`fF:@8<:>`fF:@8<:>`fH688:8>`fH6@:B8>`fH@DF6F> iY,$NAA,,,,,,,Y  Y  Y  Y Y  Y ZKEYFK_BEACH_ID$FK_ORGANIZATION_IDORG_ROLE_CODEEFFECTIVE_DATE STATUSKEACDA"ADLYAE\AFYdAGYYYYYYYL{6590FD47-D877-48FA-8A2C-C974E93739DC}L{C6C1E3E8-9AA8-4666-9DB1-9B6F1F5335FD}BEACH_IDKEYORGANIZATION_IDPrimaryKeyROLE_TYPEv1b@ @,Uq8 T  p 7 S  o 6 R  n5Qm4,p@MP142032DEQSTATEACTIVE,$?+p@MP283265DEQSTATEACTIVE,$?*p@MP425195DEQSTATEACTIVE,$?)p@MP272711DEQSTATEACTIVE,$?(p@MP272711DEQSTATEACTIVE,$?'p@MP272711DEQSTATEACTIVE,$?&p@MP272711DEQSTATEACTIVE,$?%p@MP272711DEQSTATEACTIVE,$?$p@MP272711DEQSTATEACTIVE,$?#p@MP469801DEQSTATEACTIVE,$?"p@MP423664DEQSTATEACTIVE,$?!p@MP234034DEQSTATEACTIVE,$? p@MP901121DEQSTATEACTIVE,$?p@MP771195DEQSTATEACTIVE,$?p@MP771195DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP178951DEQSTATEACTIVE,$?p@MP633629DEQSTATEACTIVE,$? p@MP453911DEQSTATEACTIVE,$? p@MP453911DEQSTATEACTIVE,$? p@MP453911DEQSTATEACTIVE,$? p@MP453911DEQSTATEACTIVE,$? p@MP412521DEQSTATEACTIVE,$?p@MP227159DEQSTATEACTIVE,$?p@MP706463DEQSTATEACTIVE,$?p@MP905261DEQSTATEACTIVE,$?p@MP274563DEQSTATEACTIVE,$?p@MP957808DEQSTATEACTIVE,$?p@MP825132DEQSTATEACTIVE,$?p@MP825132DEQSTATEACTIVE,$?p@MP743331DEQSTATEACTIVE,$? @@ @ @ @ @ @ `f8>:6<:B+`f8DFH@8B`f8HF@HDB`f8HF@HDB`f8HF@HDB`f8HF@HDB`f8HF@HDB`f8HF@HDB`f8HF@HDB`f8HF@HDB`f::D8@HB`f:<>6<>B `f:D:D88B#`f:D:D88B$`f:D:D88B%`f:D:D88B&`f:D:D88B'`f:D:D88B(`f:D>@B<B`f:F<:B@B*`f>8:@:8B`f>:B!`f>:@8H@B)`f>@@@@BHF68B"`f@@@F6>B`f@@@F6>B`f@@@F6>B`f@@@F6>B`f@@@F6>B`f@@@F6>B`fB<B<B`fD><<<8B`fDD88H@B`fDD88H@B`fF:@8<:B`fF:@8<:B`fH688:8B`fH6@:B8B`fH@DF6FB @ @ @ @ @ @BBBBBBBB B B  B  B  B B BBBBBBBBBBBBBBBBB B!B "B!#B"$B#%B$&B%'B&(B')B(*B)+B*,B+h @@@@@@@@@@@@OQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhB OQhB OQhB OQhB OQhB OQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhBOQhB OQhB!OQhB"OQhB#OQhB$OQhB%OQhB&OQhB'OQhB(OQhB)OQhB*OQhB+ @ @ @ @ @ @BBBBBBBB B B  B  B  B B BBBBBBBBBBBBBBBBB B!B "B!#B"$B#%B$&B%'B&(B')B(*B)+B*,B+ @kmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQB kmJmQB kmJmQB kmJmQB kmJmQB kmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQBkmJmQB kmJmQB!kmJmQB"kmJmQB#kmJmQB$kmJmQB%kmJmQB&kmJmQB'kmJmQB(kmJmQB)kmJmQB*kmJmQB+ WY,$NII,,,,,,,Y  Y  Y  Y Y  Y KEYFK_BEACH_IDFK_PERSON_ID PERSON_ROLE_CODEEFFECTIVE_DATE STATUSOE"A_IKALI_UYAILODWEO_PIMCECSOEINENAIOOYYYYYYYL{52E968D3-2688-4494-A906-191347F3FBF0}L{916F5F3C-DC96-4B45-879B-2194A5828702}BEACH_IDKEYPERSON_IDPrimaryKeyROLE_TYPEv1b@ H,Uq8 T  p 7 S  o 6 R  n5Qm4,p@MP142032DEQSTATEACTIVE,$?+p@MP283265DEQSTATEACTIVE,$?*p@MP425195DEQSTATEACTIVE,$?)p@MP272711DEQSTATEACTIVE,$?(p@MP272711DEQSTATEACTIVE,$?'p@MP272711DEQSTATEACTIVE,$?&p@MP272711DEQSTATEACTIVE,$?%p@MP272711DEQSTATEACTIVE,$?$p@MP272711DEQSTATEACTIVE,$?#p@MP469801DEQSTATEACTIVE,$?"p@MP423664DEQSTATEACTIVE,$?!p@MP234034DEQSTATEACTIVE,$? p@MP901121DEQSTATEACTIVE,$?p@MP771195DEQSTATEACTIVE,$?p@MP771195DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP198597DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP555804DEQSTATEACTIVE,$?p@MP178951DEQSTATEACTIVE,$?p@MP633629DEQSTATEACTIVE,$? p@MP453911DEQSTATEACTIVE,$? p@MP453911DEQSTATEACTIVE,$? p@MP453911DEQSTATEACTIVE,$? p@MP453911DEQSTATEACTIVE,$? p@MP412521DEQSTATEACTIVE,$?p@MP227159DEQSTATEACTIVE,$?p@MP706463DEQSTATEACTIVE,$?p@MP905261DEQSTATEACTIVE,$?p@MP274563DEQSTATEACTIVE,$?p@MP957808DEQSTATEACTIVE,$?p@MP825132DEQSTATEACTIVE,$?p@MP825132DEQSTATEACTIVE,$?p@MP743331DEQSTATEACTIVE,$? H@ @ @ @ @ @ `f8>:6<:J+`f8DFH@8J`f8HF@HDJ`f8HF@HDJ`f8HF@HDJ`f8HF@HDJ`f8HF@HDJ`f8HF@HDJ`f8HF@HDJ`f8HF@HDJ`f::D8@HJ`f:<>6<>J `f:D:D88J#`f:D:D88J$`f:D:D88J%`f:D:D88J&`f:D:D88J'`f:D:D88J(`f:D>@B<J`f:F<:B@J*`f>8:@:8J`f>:J!`f>:@8H@J)`f>@@@@BHF68J"`f@@@F6>J`f@@@F6>J`f@@@F6>J`f@@@F6>J`f@@@F6>J`f@@@F6>J`fB<B<J`fD><<<8J`fDD88H@J`fDD88H@J`fF:@8<:J`fF:@8<:J`fH688:8J`fH6@:B8J`fH@DF6FJ H @ @ @ @ @JJJJJJJJ J J  J  J  J J JJJJJJJJJJJJJJJJJ J!J "J!#J"$J#%J$&J%'J&(J')J(*J)+J*,J+h H@@@@@@@@@@@OQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJ OQhJ OQhJ OQhJ OQhJ OQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJOQhJ OQhJ!OQhJ"OQhJ#OQhJ$OQhJ%OQhJ&OQhJ'OQhJ(OQhJ)OQhJ*OQhJ+ H @ @ @ @ @JJJJJJJJ J J  J  J  J J JJJJJJJJJJJJJJJJJ J!J "J!#J"$J#%J$&J%'J&(J')J(*J)+J*,J+ HkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJ kmJmQJ kmJmQJ kmJmQJ kmJmQJ kmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJkmJmQJ kmJmQJ!kmJmQJ"kmJmQJ#kmJmQJ$kmJmQJ%kmJmQJ&kmJmQJ'kmJmQJ(kmJmQJ)kmJmQJ*kmJmQJ+ Y+v$x%NQQ Y d Y d Y FK_BEACH_ID POLLUTION_SOURCE"POLLUTION_COMMENTAPDQSPTQTYYY(BEACHBEACH_POLLUTIONBeachIdPrimaryKeyv1 P`@ `@  ` @ MP957808UNKNOWN MP905261UNKNOWN MP901121UNKNOWN MP825132UNKNOWN MP771195UNKNOWN MP743331UNKNOWN MP706463UNKNOWN MP633629UNKNOWN MP555804UNKNOWN MP469801UNKNOWN MP453911UNKNOWN MP425195UNKNOWN MP423664UNKNOWN MP412521UNKNOWN MP283265UNKNOWN MP274563UNKNOWN MP272711UNKNOWN MP234034UNKNOWN MP227159UNKNOWN MP198597UNKNOWN MP178951UNKNOWN MP142032UNKNOWN  P@ @ @ `f8>:6<:R`f8DFH@8R`f8HF@HDR`f::D8@HR`f:<>6<>R`f:D:D88R`f:D>@B<R`f:F<:B@R`f>8:@:8R`f>:R `f>:@8H@R `f>@BHF68R `f@@@F6>R `fB<B<R`fD><<<8R`fDD88H@R`fF:@8<:R`fH688:8R`fH6@:B8R`fH@DF6FR P @ @ @`f8>:6<:ob\bdsbR`f8DFH@8ob\bdsbR`f8HF@HDob\bdsbR`f::D8@Hob\bdsbR`f:<>6<>ob\bdsbR`f:D:D88ob\bdsbR`f:D>@B<ob\bdsbR`f:F<:B@ob\bdsbR`f>8:@:8ob\bdsbR`f>:ob\bdsbR `f>:@8H@ob\bdsbR `f>@BHF68ob\bdsbR `f@@@F6>ob\bdsbR `fB<B<ob\bdsbR`fD><<<8ob\bdsbR`fDD88H@ob\bdsbR`fF:@8<:ob\bdsbR`fH688:8ob\bdsbR`fH6@:B8ob\bdsbR`fH@DF6Fob\bdsbR `Y,+v$x%NVV,,,,,,Y  Y  Y KEYFK_BEACH_IDFK_PROCEDURE_IDNTEVXAVYOVZYV[YYYYYYL{0CB61F25-EDA6-442A-9BFA-E5691F41AF10}L{6F0337BD-7DBE-424B-9AEC-E2523CFBA821}BEACH_IDKEYORGANIZATION_IDPrimaryKeyHv1b U,|[:tS2 l K * d C "  } \ ;  u T ,MP142032PROC_1+MP283265PROC_1*MP425195PROC_1)MP272711PROC_1(MP272711PROC_1'MP272711PROC_1&MP272711PROC_1%MP272711PROC_1$MP272711PROC_1#MP469801PROC_1"MP423664PROC_1!MP234034PROC_1 MP901121PROC_1MP771195PROC_1MP771195PROC_1MP198597PROC_1MP198597PROC_1MP198597PROC_1MP198597PROC_1MP198597PROC_1MP198597PROC_1MP198597PROC_1MP198597PROC_1MP555804PROC_1MP555804PROC_1MP555804PROC_1MP555804PROC_1MP555804PROC_1MP555804PROC_1MP178951PROC_1MP633629PROC_1 MP453911PROC_1 MP453911PROC_1 MP453911PROC_1 MP453911PROC_1 MP412521PROC_1MP227159PROC_1MP706463PROC_1MP905261PROC_1MP274563PROC_1MP957808PROC_1MP825132PROC_1MP825132PROC_1MP743331PROC_1 U@ @ @ @ @ @ `f8>:6<:W+`f8DFH@8W`f8HF@HDW`f8HF@HDW`f8HF@HDW`f8HF@HDW`f8HF@HDW`f8HF@HDW`f8HF@HDW`f8HF@HDW`f::D8@HW`f:<>6<>W `f:D:D88W#`f:D:D88W$`f:D:D88W%`f:D:D88W&`f:D:D88W'`f:D:D88W(`f:D>@B<W`f:F<:B@W*`f>8:@:8W`f>:W!`f>:@8H@W)`f>@@@@BHF68W"`f@@@F6>W`f@@@F6>W`f@@@F6>W`f@@@F6>W`f@@@F6>W`f@@@F6>W`fB<B<W`fD><<<8W`fDD88H@W`fDD88H@W`fF:@8<:W`fF:@8<:W`fH688:8W`fH6@:B8W`fH@DF6FW U @ @ @ @ @WWWWWWWW W W  W  W  W W WWWWWWWWWWWWWWWWW W!W "W!#W"$W#%W$&W%'W&(W')W(*W)+W*,W+ U@@@@@@@@@@@fidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8W fidM+8W fidM+8W fidM+8W fidM+8W fidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8WfidM+8W fidM+8W!fidM+8W"fidM+8W#fidM+8W$fidM+8W%fidM+8W&fidM+8W'fidM+8W(fidM+8W)fidM+8W*fidM+8W+ U @ @ @ @ @WWWWWWWW W W  W  W  W W WWWWWWWWWWWWWWWWW W!W "W!#W"$W#%W$&W%'W&(W')W(*W)+W*,W+H Y$N]]Y  Y  Y  Y  Y xY  Y AKEY$FK_ORGANIZATION_IDFK_PERSON_ID.ELECTRONIC_ADDRESS_CODEADDRESSEFFECTIVE_DATE STATUS]_G]`Y]aY]b.Er]cGAYYYYYYYL{22A2A81A-EF57-4C71-98C4-B906A599DC47}L{5FD66722-0304-4E68-BC25-354CCCEF73EA}ADDRESS_TYPEKEYORGANIZATION_IDPERSON_IDPrimaryKeyv1b@@\p@DEQDEQEMAILclarissabearden@deq.gov.mpACTIVEC;\Q`JY^^\^\OQh^\OQh^\^ oY$N eeY  Y  Y  Y  Y  Y  Y  Y Ad Y   Y  _Y  Y IKEY$FK_ORGANIZATION_IDFK_PERSON_ID(MAILING_ADDRESS_CODE LINE_1 LINE_2 LINE_3CITY"STATE_POSTAL_CODEZIP_CODEEFFECTIVE_DATE STATUSYegYeheir.ej.r256-2ek0603}DRelZA ireemDYYYYYYYYYL{81BF7223-8544-41A3-8560-CACC051B6D95}L{B066CA4B-7575-4EE8-A630-0BE92DE68C88}ADDRESS_TYPEKEYORGANIZATION_IDPERSON_IDPrimaryKey"STATE_POSTAL_CODEZIP_CODEs v1b @@^dn p@DEQDEQMAILINGCNMI DIVISION OF ENVIRONMENTAL QUALITYPO BOX 501304SAIPANMP12345-1234ACTIVExpd`XXI! d@`JY^YbUfdfdOQhfdOQhfdfd`ff d8:<>@8:<>f'ON] ME u  B >K @ H HHVlE;[wac 9vO@ 9vO@{1FB22605-76C2-4F24-8D06-09755C0B638A}{_nnnnnnnnnnl b~9vO@~9vO@{0CB61F25-EDA6-442A-9BFA-E5691F41AF10}{_nnnnnnnnnnl a 9vO@ 9vO@{024D5083-5345-448A-AA3E-79900810E254}{_nnnnnnnnnnl `P9:vO@P9:vO@{007BDFDC-68E3-40E7-979F-2AF82B37C52B}{_nnnnnnnnnnl G7vO@3@TELEPHONE{_ @@@@44444442 @D]n@ּ@REF_WATER_BODY_TYPE{_w@~TTTHHHHHHHF @AC֣@𺥷@REF_WATER_BODY_NAME{_w@~TTTHHHHHHHF @>Fڃ@ڃ@REF_TELEPHONE_CODE{_u@|RRRFFFFFFFD @;-7@rS@REF_STATE_POSTAL_CODE{_m@|XXXLLLLLLLJ @6}dY߃@}@REF_PROCEDURE_CODE{_u@|RRRFFFFFFFD @3Fv]@w@]@REF_PERSON_ROLE_CODE{_y@{VVVJJJJJJJH @_-d$΃@K$΃@REF_ORG_CODE{_i@{FFF:::::::8 @*s϶@N@REF_MEASUREMENT_UNIT{_y@zVVVJJJJJJJH @'Ӄ@Ӄ@REF_MAILING_CODE{_q@zNNNBBBBBBB@ @$@I @REF_H_REFERENCE_DATUM_NAME{_@zbbbVVVVVVVT @,@I @REF_H_COLLECTION_METHOD_NAME{_@yfffZZZZZZZX @Ɲ @=s@REF_FREQUENCY_UNIT{_u@yRRRFFFFFFFD @aңڃ@㓏ڃ@REF_ELECTRONIC_MAILING_CODE{_@ydddXXXXXXXV @_~@'@REF_ACTIVITY_SOURCE_TYPE{_@x^^^RRRRRRRP @_\@ɐ("@REF_ACTIVITY_SOURCE{_@x`@b`TTHHHHHHHF @Gɫ~@ɫs4@REF_ACTIVITY_REASON_TYPE{_@x^^^RRRRRRRP @^jH@!*@REF_ACTIVITY_REASON{_@v`@b`TTHHHHHHHF @ ~@yKs@REF_ACTIVITY_INDICATOR_TYPE{_@wdddXXXXXXXV @_An}ނ@}ނ@REF_ACTIVITY_CODE{_s@wPPPDDDDDDDB @}ނ@\ =@REF_ACCESS_TYPE{_o@wLLL@@@@@@@> @W6vO@"\h@PROCEDURE{_@v@@@44444442 @\u5۱@qN@POLLUTION_SOURCES{_@v`@b\PPDDDDDDDB @5vO@u 6h@PERSON{_ @u:::......., @H4vO@75uh@ORGANIZATION{_m @tFFF:::::::8 @_u0r@u0r@ MSysNavPaneGroupToObjects{_4MR2KeepLocal  TTTTTTTTR @u0r@u0r@ MSysNavPaneGroups{_4MR2KeepLocal  TDDDDDDDB @ _(O@(O@MSysAccessXML{_4MR2KeepLocal  T|||<<<<<<<: @o*@*@MSysAccessObjects{_DDDDDDDDDDB _ Yj NppjjY Y oDataIDLL#pbYAOIndexv1Ko[N0P3DTwSysAccessObjectsyLLLLLLLLLLJ Ko[ࡱ>  |h_n{56789   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntryQ VBA͌2Q VBAProjectOM͌2Q VBA#͌2 hb'dir __SRP_0 5__SRP_18t__SRP_2 *9  !"#$%&'()*+,-./012345679:;<=>?@ABCDEFGHIKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqstuvwxyz{|}~߹0* pHdBeachActivitiesQH@  = | 2K J< EADO DB> ADOB *\G{0201-010-8 AA006D2EA4}#2.1#0#C:\Program Files\Common System\a do\ms21.tlb#Microsoft peX Data Objects , Librar&yHyMS XML2>iMSXMLj2^lb^F5078F18-C551-11D@3-89B9^00F81FE22@1}#6.0^c:\WINDOWHS\sT32Sxml6.dllSq<, v2K Form_05) Custom  GenerationGForm_05) Cuhstm@4 @Genrai@n@CTJPBYGNUKXAAEDVHQOPJDIVZAMB28ATJ PBYNUKJAAE{VHQ OJ@IVZ@M@ A@1@6@,B;"B*(B+BdmodShared>G@m-d@jjh@1r@3dlC2ASTLVMMZTFOSHEOZCHNWKWFTFPPNC2ATxV@zM)TF@.*S(EZNHhNW7W@AP5NIK2>P2!B/0A,odl^eB1DC1KdeJ2USHUBAJFLNRXAERHHJMUBUKTLTAJD2U@2H@bB`-J`LR`a2RH 6M5aA 1n#q2+~?1P1MM1DNJOXLNOVMBVQDJIOLTBHJFGXXTVC1D`J.X 2N2BGQHJI L OBU!GXC1,o:k1#j1) Main Menu {Start Herep}G>LEj1BjMMig Fhuk{0tPt"HBke}jMPNWYVEWVSODNCERMFLXPLSBN_UMKW@jVhWSF"C`R F@#X`L JB%_ dEۑjRC 2) VG 2"BachGFKBKRJUUKURMDBYYNZTDRPFHWDGPK~KRMU@OK`aDYNnDP`Hl!bKk$\A3 AttributeG ǣ3, @gtribt`CWFOXJEECEJLOUXDUUVOOBFDWXTLLG7XE4a5jJ4OX@WaVՀWOFWWpL2@OiD9aSB4æ|yG.+V4tKo[v0tyXPYYFGIQYRKPXDP`YORFJIpZZHRT:'F I^YK )G )UO0FjI Z:RTI1_PrPeValFPneq2al{CTTBLQAKHPFYYSDIXNGANLPNCVOWFCTDL0 A^H0 F Y5DFX G !NPC0O@*F/7H¾/*)F6) Organiz{*6O gEnzp oPG AKMVJBJSYUTLZDPCFPNMISBBNNFEUA M@ Jp'J@ Yk(q'Z0(PENU0EIB0N@FMPF87) Pe\rsq(7 P 5r' TZQCJUEZYNWXVDFEMCJSGWGVGRTKUZC%U6ZyQ`D=E S)W0V0R0Ke/ y1-/ r# 8rbling AddressOE8 blng`AdrsZJIXLXCFMFCBBEZCSJYVNSMMBGpVZ4pXM0CUBC`JVm`SGp'p5(BE9) Elಠronic6U9E7eEr+cobZSWNUMJCJODACCHMYDDGERUVJCZ W@ U@ J7C~D8CHYP,DEFUR.E+EOtoe10) Telephon0cg@5c10d!TZl0pp+eSZKOKLWIVBPJWTDTHFWERBTWEBTAH K`K EW FVP@W@*D0HWRpjTErAT m aH ,1G Role AssigzB1OH `oBasQ-i.5LKMLYOFNMJQHNDPJTGCOHNVPhBTBWLWZYUFM`QNUIJGOVYBB]}g-1I+-1!JoiEQZKLRMGMUCKZDCKNVSWKBIKPDGRMEKZLM+!Ck1YqN,SIp.1oo P"(P+P8Form_13) Pollution SourcesG4|orm_13 ) P"lluti*n&SuNc(esrUTEILHJTISPJZDWNRSFGCFFRNL DG28!TEILHDJ IS]JZDWNRFGCTFRLG]3BI` ,W y4yrocedturv& cv4vr kdxroHJXCFVLWIDOBCEJGBFNBCWTXURRNojX^ VqWtDOBEwGFiŁW~XUxroEo<oo5o AssigPnG2 959 AqswgnsCQZKIEMAVODQVDGKNJOTCAF CLSIDLKrJCY6Ơ667) Generate XMLXG*777GUnr9e@X@aL9XDSHZMHFNZKSSDWZWREWDDVLGYWMSZANb9VS`pqZ rR@W@!L@Y`M%qP8) Beach Activity Reaso`V*<8B ahchAavQUty Rs`$WZLEABJ@FTGIHU=NEUUKMXFUPWMK_ZBEU7BsFrG`SHUrHH`WE`UU;M>F`W$KࢯW*69StahG> 9 6t @4WSYBGM_FJBOXUDJRGMGRJKHGNYAKUC WY ]G@_U]J`OU>J ZGJ H@NY&KP@e\O `ˁ.K*m0rUL~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Ko[~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~7 aYLA8K?Z~    ) Qy) SGK# rQsvxz{! Form_05) Custom XML Generation modSharedXMLmodGenerateXML modCustomXMLForm_01) Main Menu {Start Here}Form_02) BeachForm_03) Beach AttributeForm_04) Beach ActivityBeachActivities 02) Beach &03) Beach Attribute $04) Beach Activity 205) Custom XML GenerationVBA * Beach * &* Beach Attribute * $* Beach Activity * * Generate XML *F@C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL Y `J_N?4C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLBAccess i  p0FC:\WINDOWS\system32\stdole2.tlbstdole ym.4C:\Program Files\Common Files\System\ado\msado21.tlbADODB a Q!c:\WINDOWS\system32\msxml6.dllMSXML2 q  *0[ C:\WINDOWS\System32\shdocvw.dllSHDocVw Q y PpZdC:\WINDOWS\system32\SHELL32.dllShell32Label29Frame73 Send_To_EPA 1 Y .'d/$ 'C:\PROGRA~1\MICROS~2\OFFICE11\MSCAL.OCXMSACAL a  'V:#Uw6KekF  C:\WINDOWS\System32\compatui.dll COMPATUILib Q y "L~C:\WINDOWS\system32\msdxm.ocx MediaPlayer Ai\ uM  C:\WINDOWS\system32\mscomctl.ocx MSComctlLibBeach_Pollution_Button )QX#b`2s  C:\WINDOWS\System32\msjtes40.dllJetES ac~k B*  C:\WINDOWS\system32\comctl32.ocx ComctlLib Iq іhYPJ;9uime1sF=?qNNC,U,cC90I0SC7?DetailHC7?Frame5AC7?Beach_Person_Role_Assign_ButtonFrame25Label27Beach_Procedure_Assign_ButtonLabel30Label31Label32Label33Frame39Label43Label44Frame49DC7?Image63Label7231?FormLabel76Label83Label84 Beach_ButtonBeach_Activity_ButtonKo[Generate_XML_ButtonBeach_Attribute_Button %Beach_Organization_Role_Assign_ButtonLabel75 Form_LoadDetail_MouseMoveBeach_Button_ClickBeach_Button_MouseMoveAccess_CommentBeach_Attribute_Button_Click  Beach_Attribute_Button_MouseMoveBeach_Activity_Button_ClickBeach_Activity_Button_MouseMove #Beach_Activity_Station_Button_Click 'Beach_Activity_Station_Button_MouseMove +Beach_Organization_Role_Assign_Button_Click /Beach_Organization_Role_Assign_Button_MouseMove &Beach_Person_Role_Assignn_Button_Click )Beach_Person_Role_Assign_Button_MouseMoveBeach_Pollution_Button_Click  Beach_Pollution_Button_MouseMoveLabel67 #Beach_Procedure_Assign_Button_Click 'Beach_Procedure_Assign_Button_MouseMoveGenerate_XML_Button_ClickGenerate_XML_Button_MouseMoveSet_Main_Menu_Items  BeachH;|? Beach Activity Beach Attribute <Beach Organization Role Assign 0Beach Person Role Assign Beach Pollution m/d/yyyy ,Beach Procedure Assign Generate XML 4* Beach Procedure Assign * &* Beach Pollution * 8* Beach Person Role Assign * D* Beach Organization Role Assign *ɤs h)aN?""`GXGPJ?P"0 $ActivityReasonType rhttp://www.exchangenetwork.net/schema/BEACHES/2 index.xsd ^http://www.exchangenetwork.net/schema/BEACHES/2 Rhttp://www.w3.org/2001/XMLSchema-instance . WHERE SEND_TO_EPA = 'Y .ActivityActualStartDate ,ActivityActualStopDateFIPS_County_Codef SELECT BEACH.ID, BEACH.NAME, BEACH.DESCRIPTION, BEACH.COMMENT, BEACH.STATE_POSTAL_CODE, BEACH.FIPS_COUNTY, BEACH.WATERBODY_NAME, BEACH.WATERBODY_TYPE, BEACH.ACCESS_TYPE, BEACH.ACCESS_COMMENT FROM BEACH (BeachProcedureDetail ActivityTypeCodeJ SELECT ORGANIZATION.ID, ORGANIZATION.ORGANIZATION_CODE, ORGANIZATION.NAME, ORGANIZATION.DESCRIPTION, ORGANIZATION.ABBREVIATION FROM ORGANIZATION t WHERE BEACH_LATITUDE_LONGITUDE_COORDINATE.FK_BEACH_ID = ' SOURCE INDICATOR BeachDetail &SELECT MAILING_ADDRESS.MAILING_ADDRESS_CODE, MAILING_ADDRESS.LINE_1, MAILING_ADDRESS.LINE_2, MAILING_ADDRESS.LINE_3, MAILING_ADDRESS.CITY, MAILING_ADDRESS.STATE_POSTAL_CODE, MAILING_ADDRESS.ZIP_CODE, MAILING_ADDRESS.EFFECTIVE_DATE, MAILING_ADDRESS.STATUS FROM MAILING_ADDRESSS FSELECT ELECTRONIC_ADDRESS.ELECTRONIC_ADDRESS_CODE, ELECTRONIC_ADDRESS.ADDRESS, ELECTROKo[NIC_ADDRESS.EFFECTIVE_DATE, ELECTRONIC_ADDRESS.STATUS FROM ELECTRONIC_ADDRESS& ', 'mm/dd/yyyy')) AND BEACH_ACTIVITY.ACTUAL_START_DATE <= CDATE(FORMAT$(' Access_Type= SELECT TELEPHONE.TELEPHONE_CODE, TELEPHONE.TELEPHONE_NUMBER, TELEPHONE.EFFECTIVE_DATE, TELEPHONE.STATUS FROM TELEPHONE : WHERE FK_ORGANIZATION_ID = ' . WHERE FK_PERSON_ID = ' ^ WHERE BEACH_PERSON_ROLE_ASSIGN.FK_BEACH_ID = ' ActivityNameD SELECT PERSON.ID, PERSON.ACTIVE, PERSON.FIRST_NAME, PERSON.LAST_NAME, PERSON.MIDDLE_INITIAL, PERSON.SUFFIX, PERSON.TITLE FROM PERSON 8' AND FK_ORGANIZATION_ID = ' *' AND FK_BEACH_ID = ' j WHERE BEACH_ORGANIZATION_ROLE_ASSIGN.FK_BEACH_ID = '2 SELECT BEACH_ATTRIBUTE.EFFECTIVE_YEAR, BEACH_ATTRIBUTE.EXTENT_LENGTH, BEACH_ATTRIBUTE.EXTENT_UNITS, BEACH_ATTRIBUTE.BEACH_TIER, BEACH_ATTRIBUTE.SWIM_SEASON_LENGTH, BEACH_ATTRIBUTE.SWIM_SEASON_UNITS, BEACH_ATTRIBUTE.SWIM_SEASON_START_DATE, BEACH_ATTRIBUTE.SWIM_SEASON_END_DATE, BEACH_ATTRIBUTE.SWIM_MONITOR_FREQ, BEACH_ATTRIBUTE.OFF_MONITOR_FREQ, BEACH_ATTRIBUTE.MONITOR_FREQ_UNITS, BEACH_ATTRIBUTE.MONITORED_IRREGULARLY, BEACH_ATTRIBUTE.MONITORED_IRREGULARLY_COMMENTS, BEACH_ATTRIBUTE.NO_POLLUTION_SOURCES, BEACH_ATTRIBUTE.POLLUTION_SOURCES_UNINVESTIGATED, BEACH_ATTRIBUTE.BEACH_ACT_BEACH FROM BEACH_ATTRIBUTE@ SELECT BEACH_POLLUTION.FK_BEACH_ID, BEACH_POLLUTION.POLLUTION_SOURCE, BEACH_POLLUTION.POLLUTION_COMMENT FROM BEACH_POLLUTION , WHERE FK_BEACH_ID = ' r' AND BEACH_ACTIVITY.ACTUAL_START_DATE >= CDATE(FORMAT$(' $OrganizationDetailBeach_Description SELECT BEACH_ACTIVITY.ACTIVITY_CODE, BEACH_ACTIVITY.NAME, BEACH_ACTIVITY.ACTUAL_START_DATE, BEACH_ACTIVITY.ACTUAL_STOP_DATE, BEACH_ACTIVITY.DESCRIPTION, BEACH_ACTIVITY.COMMENT, BEACH_ACTIVITY.EXTENT_START_MEASURE, BEACH_ACTIVITY.EXTENT_LENGTH, BEACH_ACTIVITY.EXTENT_UNIT_OF_MEASURE, BEACH_ACTIVITY.ACTIVITY_ID FROM BEACH_ACTIVITY@ SELECT BEACH_ACTIVITY_REASON.CLASS, BEACH_ACTIVITY_REASON.TYPE, BEACH_ACTIVITY_REASON.DESCRIPTION FROM BEACH_ACTIVITY_REASON 0 WHEREKo[ FK_ACTIVITY_ID =  AND CLASS = '% SELECT BEACH_ACTIVITY_STATION.STATION_ID FROM BEACH_ACTIVITY_STATIONr SELECT BEACH_ORGANIZATION_ROLE_ASSIGN.ORG_ROLE_CODE, BEACH_ORGANIZATION_ROLE_ASSIGN.FK_ORGANIZATION_ID, BEACH_ORGANIZATION_ROLE_ASSIGN.EFFECTIVE_DATE, BEACH_ORGANIZATION_ROLE_ASSIGN.STATUS FROM BEACH_ORGANIZATION_ROLE_ASSIGN &BeachDataSubmission BSELECT BEACH_PERSON_ROLE_ASSIGN.PERSON_ROLE_CODE, BEACH_PERSON_ROLE_ASSIGN.FK_PERSON_ID, BEACH_PERSON_ROLE_ASSIGN.EFFECTIVE_DATE, BEACH_PERSON_ROLE_ASSIGN.STATUS, PERSON.FK_ORGANIZATION_ID FROM PERSON INNER JOIN BEACH_PERSON_ROLE_ASSIGN ON PERSON.ID = BEACH_PERSON_ROLE_ASSIGN.FK_PERSON_ID  ,SELECT BEACH_LATITUDE_LONGITUDE_COORDINATE.FK_BEACH_ID, BEACH_LATITUDE_LONGITUDE_COORDINATE.START_LATITUDE, BEACH_LATITUDE_LONGITUDE_COORDINATE.START_LONGITUDE, BEACH_LATITUDE_LONGITUDE_COORDINATE.END_LATITUDE, BEACH_LATITUDE_LONGITUDE_COORDINATE.END_LONGITUDE, BEACH_LATITUDE_LONGITUDE_COORDINATE.SOURCE_MAP_SCALE, BEACH_LATITUDE_LONGITUDE_COORDINATE.REF_H_COLLECTION_METHOD_NAME, BEACH_LATITUDE_LONGITUDE_COORDINATE.REF_H_REFERENCE_DATUM_NAME, BEACH_LATITUDE_LONGITUDE_COORDINATE.DESCRIPTION FROM BEACH_LATITUDE_LONGITUDE_COORDINATE, SELECT PROCEDURE.ID, PROCEDURE.PROCEDURE_CODE, PROCEDURE.DESCRIPTION FROM [PROCEDURE]$ SELECT BEACH_PROCEDURE_ASSIGN.FK_BEACH_ID FROM BEACH_PROCEDURE_ASSIGN 4 WHERE FK_PROCEDURE_ID = ' '; ; $', 'mm/dd/yyyy')); REASON Beach_Comment FActivityMonitoringStationIdentifier .ActivityDescriptionText &ActivityCommentText (ActivityExtentDetail 4ActivityExtentStartMeasure 6ActivityExtentLengthMeasure >ActivityExtentUnitOfMeasureCode (ActivityReasonDetailp W*  :ActivityReasonDescriptionText (ActivitySourceDetail $ActivitySourceType :ActivitySourceDescriptionText .ActivityIndicatorDetail *ActivityIndicatorType @ActivityIndicatorDescriptionText ,AttributeEffectiveYearAddBeachActivityInformation "BeachExtentDetail &ExtentLengthMeasure .ExtentUnitOfMeasureCode 6Ko[BeachSwimSeasonLengthDetail .SwimSeasonLengthMeasure 6SwimSeasonUnitOfMeasureCode &SwimSeasonStartDate "SwimSeasonEndDate 2MonitoringFrequencyDetail-'d/$ 4SwimSeasonFrequencyMeasure 2OffSeasonFrequencyMeasure HMonitoringFrequencyUnitOfMeasureCode (MonitoredIrregularly 6MonitoredIrregularlyComment 4BeachPollutionSourceDetail (BeachPollutionSource 0BeachPollutionSourceCodeLabel66 >BeachPollutionSourceDescription 6NoPollutionSourcesIndicator NPollutionSourcesUninvestigatedIndicator BeachTierRanking ,BeachActBeachIndicator ,MailingAddressTypeCode :MailingAddressStreetLine1Text &ProgramInterestName xCalBegin :MailingAddressStreetLine2Text :MailingAddressStreetLine3Text ,MailingAddressCityName StateCode "AddressPostalCode 6MailingAddressEffectiveDate :MailingAddressStatusIndicator BeachIdentifier BeachNameDetailAddBeachAttributeInformation <ProgramInterestDescriptionText 0ProgramInterestStateCode 4ProgramInterestCommentText :ProgramInterestFIPSCountyCode "WaterBodyNameCode "WaterBodyTypeCode 0BeachAccessibilityDetail ,BeachAccessibilityTypeAddElectronicAddressInformation 2BeachAccessibilityComment (BeachAttributeDetail &BeachActivityDetail BeachRoleDetail *BeachCoordinateDetail 2ElectronicAddressTypeCode *ElectronicAddressText <ElectronicAddressEffectiveDate @ElectronicAddressStatusIndicator ,OrganizationIdentifier ,OrganizationNameDetail (OrganizationTypeCode OrganizationName 6OrganizationDescriptionText 8OrganizationAbbreviationText @OrganizationMailingAddressDetail FOrganizationElectronicAddressDetailchkAct 6OrganizationTelephoneDetail 0OrganizationPersonDetail PersonIdentifier PersonNameDetail *PersonStatusIndicator FirstName LastName &PersonMiddleInitial NameSuffixText NamePrefixText 4PersonMailingAddressDetail :PersonElectronicAddressDetail *PersonTelephoneDetail 0ProcedureDescriptionText "ProcedureTypeCode &ProcedureIdenKo[tifier 0ProcedureBeachIdentifier "BeachRoleTypeCode >BeachRoleOrganizationIdentifier 2BeachRolePersonIdentifier ,BeachRoleEffectiveDate 0BeachRoleStatusIndicator >BeachCoordinateStartPointDetail :BeachCoordinateEndPointDetail LatitudeMeasure LongitudeMeasure *SourceMapScaleNumeric <HorizontalCollectionMethodNameAddMailingAddressInformationchkLoc XHorizontalCoordinateReferenceSystemDatumName <BeachCoordinateDescriptionText "TelephoneTypeCode &TelephoneNumberText ,TelephoneEffectiveDate 0TelephoneStatusIndicator 0YearCompletionIndicators CompletionYearAddTelephoneInformation DNotificiationDataCompleteIndicator >MonitoringDataCompleteIndicator :LocationDataCompleteIndicator ,,LL, $,0<HGetSaveFileName comdlg32.dll GetSaveFileNameA pAddOrganizationInformation3)6{O>`3)6{O>`  AddOrganizationPersonInformation !AddBeachActivityReasonInformation "AddBeachActivityStationInformation #AddBeachOrganizationRoleInformationAddBeachPersonRoleInformationAddBeachCoordinateInformationAddBeachProcedureInformation !AddEndOfYearCompletionInformationAppendBeachXMLDataToDocument  =E'a?*3Xs-EhT T3ST/~IDQ֧QWuKM !GC7?chkNotEC7?cmdGochkMon@C7? txtDataYearActiveX Controls in Access p AxCalEnd txtStartDate txtStopDatechkBeachchkNamechkAttchkRole cmdBrowsechkCoortxtFilecmdReset B* pbProgresschkOrgchkProcchkComp SetFileName CreateBaseXML chkAct_Click chkAtt_ClickchkBeach_Click chkName_Click chkRole_ClickcmdBrowse_Click cmdGo_ClickcmdReset_ClickVBE6.DLLtxtStartDate_AfterUpdatetxtStopDate_AfterUpdatexCalBegin_AfterUpdatexCalEnd_AfterUpdate Form_OpenxCalBegin_NewMonthxCalBegin_NewYearxCalEnd_NewMonthxCalEnd_NewYear IncludedDataBeachDataCheck <<48<@i   F;|?T;|?P;|?h;|? 1/2/ yyyy 1/1/Refresh Today !b  !  *XML Documents (*.xml) *.xml <Save Beach Notification XML As .XML .xml !  !_  ! 8 DESCRIPTION State_Code ! X !j x! |Please select file save location using the 'Browse...' button.5 Please make sure that both a beginning and ending date have beenKo[ selected for the Activity Date Range. "ORGANIZATION_CODE! |End Date occurs before Begin Date. Please correct to proceed. pPlease select at least one data type to include in file.% Please select at least one data type of Beach data to include in file. version="1.0"3)6{O>`3)6{O>` STATUS# Please select any data completions that apply and include the year. PNotification XML Generated Successfully!   File Name:    Included: !S  !0 iو_@2Q xmlCombo31 <Beach Data Submission created $xsi:schemaLocation3)6{O>` xmlns xmlns:xsiAddCustomBeachInformation !AddCustomBeachActivityInformation !" qy>`}A5m.Um. m. IDm.Lm. NAMEText22 ABBREVIATION &YYYY-MM-DDTHH:MM:SS YYYY-MM-DD Y true N false !  (MAILING_ADDRESS_CODE LINE_1 LINE_2 LINE_3 CITY "STATE_POSTAL_CODE ZIP_CODE EFFECTIVE_DATE BEACH_NAME .ELECTRONIC_ADDRESS_CODE ADDRESS TELEPHONE_CODE TELEPHONE_NUMBER ACTIVE FIRST_NAME LAST_NAME MIDDLE_INITIAL SUFFIX TITLE COMMENT FIPS_COUNTY WATERBODY_NAME WATERBODY_TYPE ACCESS_TYPECombo25 ACCESS_COMMENT EFFECTIVE_YEAR EXTENT_LENGTH EXTENT_UNITS ,SWIM_SEASON_START_DATE (SWIM_SEASON_END_DATE $SWIM_SEASON_LENGTH "SWIM_SEASON_UNITS "SWIM_MONITOR_FREQ OFF_MONITOR_FREQ $MONITOR_FREQ_UNITSLC7? *MONITORED_IRREGULARLY <MONITORED_IRREGULARLY_COMMENTS (NO_POLLUTION_SOURCES @POLLUTION_SOURCES_UNINVESTIGATED POLLUTION_SOURCE "POLLUTION_COMMENT BEACH_TIER BEACH_ACT_BEACH ACTIVITY_ID ACTIVITY_CODEBEACH_IDText18 "ACTUAL_START_DATE ACTUAL_STOP_DATE ,EXTENT_UNIT_OF_MEASURE (EXTENT_START_MEASURE ORG_ROLE_CODE $FK_ORGANIZATION_ID PERSON_ROLE_CODE FK_PERSON_ID START_LATITUDE START_LONGITUDE SOURCE_MAP_SCALEText14Text16 8REF_H_COLLECTION_METHOD_NAME 4REF_H_REFERENCE_DATUM_NAME END_LA Ko[TITUDE END_LONGITUDE PROCEDURE_CODE FK_BEACH_ID -Beach Data : -Beach Name Data *-Beach Attribute Data ,-Beach Activity Data (  to  ) -Beach Role Data ,-Beach Coordinate Data 6-Organizational/Person Data -Procedure Data -Completion Data BMain Menu - Notification Database/"K,gi!wIp~ <<48<@i eeeeeeeeeeeeeeee eey9"]Hq@eDEE.sFrame53Text10Text12 <<48<@i eeeeeeeeeeeeeeee ee{d>H H[atMűBn +d(Frame54 <<48<@i eeeeeeeeeeeeeeee ee,;M#7^8lHs;Frame55%x E8i(FOzfq2Frame56 <<48<@i ng and ending da av,]F);͹lBVFrame57 << 48<@i eeeeeeeeeeeeeeee eeuBh B%^5N5^R+ <<48<@i eeeeeeeeeeeeeeee eeۊ=FU~_F_HHO$Label7 << 48<@i FlSt GЃA8Bˆs}4O>fQ(Frame60 <<48<@i pFlSt 7CQ?TZ7?LA_|6< ފKѸ <<48<@i xx UCt Aj*4̞5I~@7Hp22܀DWbjq;b@0c;Text8Label70Hyper_Link_UserguideFrame74 Close_ButtonLabel71Close_Button_ClickClose_Button_MouseMoveSet_Sub_Menu_Items *Beach Data Entry Form &Return to Main Menu .* Return to Main Menu * 401) Main Menu {Start Here}zWE NwkP'P2DtRTClqO`vC1nAr?Label85Text86Combo18Combo82Text87Label88Label89Text91Label92Label93Text94Label97Label99Text101Combo102Label103Combo104Label105Combo106Combo108Combo109Combo111 ĕl6IEn[Ҍ`f}D*R +jO{ffCլBF̠*3/?HVrf/9Label1Label2Label3Label4Label5Label6Label8Label9Label10Text11Text13Combo23Text112  2Beach Activity Entry Form|(d B dJĻ@g6EssL1'Label115Label113Combo114Combo116Label117Combo118 Module1 modPreValXML. SELECT * FROM ORGANIZATION WHERE ORGANIZATION_CODE NOT IN (SELECT NAME FROM REF_ORG_CODE)8 SELECT ID, ORGANIZATION_CODE FROM ORGANIZATION WHERE ORGANIZATION_CODE NOT IN (SELECT NAME FROM REF_ORG_CODE) ORGANIZATION.ID <ORGANIZATION.ORGANIZATION_CODECYcBIj0z <<48<@i  DW@ox Ko[iZƗFQM Command61"OUI+@68: SELECT COUNT(ORGANIZATION_CODE) FROM ORGANIZATION WHERE ORGANIZATION_CODE NOT IN (SELECT NAME FROM REF_ORG_CODE)7 SELECT COUNT(ID) AS COUNT FROM ORGANIZATION WHERE ORGANIZATION_CODE NOT IN (SELECT NAME FROM REF_ORG_CODE)X-ю=EX[G6oKE+` <<48<@i  gLRUK~CG 0ɜO)zcmdPreValidates;  g"HLbv <<48<@i DDRESS  \ELECTRONIC_ADDRESS.ELECTRONIC_ADDRESS_CODE = 'Q <SELECT FK_ORGANIZATION_ID, ELECTRONIC_ADDRESS_CODE FROM ELECTRONIC_ADDRESS WHERE ELECTRONIC_ADDRESS_CODE NOT IN (SELECT NAME FROM REF_ELECTRONIC_MAILING_CODE)BCH_0401" BCH-0401: ELECTRONIC_ADDRESS.E Ko[LECTRONIC_ADDRESS_CODE is invalid. 30GU7 BCH-0401: Please check the value of the ELECTRONIC_ADDRESS.ELECTRONIC_ADDRESS_CODE in the Access Database. & values used to indicate Electronic Address Type. Please check Chapter 3  T[ELECTRONIC_ADDRESS.FK_ORGANIZATION_ID = 'g#KS L <<48<@i T q2o[OL T~->eOOo <<48<@i  sT EL? SELECT FK_ORGANIZATION_ID, TELEPHONE_CODE FROM TELEPHONE WHERE TELEPHONE_CODE NOT IN (SELECT NAME FROM REF_TELEPHONE_CODE)BCH_0502 8TELEPHONE.TELEPHONE_CODE = '. BCH-0502: Please check the value of the TELEPHONE.TELEPHONE_CODE in the Access Database. ! ~values used to indicate Telephone Type. Please check Chapter 3  ^BCH-0502: TELEPHONE.TELEPHONE_CODE is invalid.  B[TELEPHONE.FK_ORGANIZATION_ID = ' <<48<@i t  * < SELECT FK_BEACH_ID, NAME, ACTIVITY_CODE FROM ACTIVITY WHERE ACTIVITY_CODE NOT IN (SELECT NAME FROM REF_ACTIVITY_CODE)BCH_0701 >[BEACH_ACTIVITY.FK_BEACH_ID = ' .BEACH_ACTIVITY.NAME = 'Form_07) PersonForm_06) Organization10 BCH-0701: Please check the value of the BEACH_ACTIVITY.ACTIVITY_CODE in the Access Database. ( values used to indicate Activity Type. Please check Chapter 3 and Appendix B  fBCH-0701: BEACH_ACTIVITY.ACTIVITY_CODE is invalid. Form_08) Mailing Address @BEACH_ACTIVITY.ACTIVITY_CODE = 'H%bMWM)d3XO,.Y <<48<@i  ? SELECT FK_BEACH_ID, NAME, ACTIVITY_CODE FROM BEACH_ACTIVITY WHERE ACTIVITY_CODE NOT IN (SELECT NAME FROM REF_ACTIVITY_CODE) <<48<@i  P :SELECT FK_BEACH_ID, NAME, ACTUAL_START_DATE, ACTUAL_STOP_DATE FROM BEACH_ACTIVITY WHERE FORMAT(ACTUAL_START_DATE, "yyyy") <> FORMAT(ACTUAL_STOP_DATE, "yyyy").|.2J֟n{\qfN9+) <<48<@i eeeeeeeeeeeeeeee eeBCH_0705&;Eu T gForm_06) OrganizationForm_02) Beach1% BCH-0705: The BEACH_ACTIVITY.ACTUAL_START_DATE year does not match the . BEACH_ACTIVITY.ACTUAL_STOP_DATE year. Activities can only occur during one calendar yea Ko[r.' In the event that an event does cross into another year, it must be split  Pinto two activities, one for each year. % BCH-0705: BEACH_ACTIVITY.ACTUAL_START_DATE year does not match year of  BBEACH_ACTIVITY.ACTUAL_STOP_DATE.  HBEACH_ACTIVITY.ACTUAL_START_DATE = ' FBEACH_ACTIVITY.ACTUAL_STOP_DATE = 'NЋ#Di/,@ SELECT FK_BEACH_ID, NAME, ACTUAL_START_DATE, ACTUAL_STOP_DATE FROM BEACH_ACTIVITY WHERE ACTUAL_STOP_DATE < ACTUAL_START_DATEBCH_07060 BCH-0706: BEACH_ACTIVITY.ACTUAL_START_DATE occurs after the BEACH_ACTIVITY.ACTUAL_STOP_DATE [,A5` B׫DTY- The order of these dates must be reversed in order to achieve a successful submission. tBCH-0706: BEACH_ACTIVITY.ACTUAL_STOP_DATE occurs prior to  DBEACH_ACTIVITY.ACTUAL_START_DATE. 3?d2F/<늽R-fmA.)_LR <<48<@i  o 7 SELECT ID, PROCEDURE_CODE FROM PROCEDURE WHERE PROCEDURE_CODE NOT IN (SELECT NAME FROM REF_PROCEDURE_CODE)BCH_0801BCH_0903. BCH-0903: Please check the value of the PROCEDURE.PROCEDURE_CODE in the Access Database.  4Beach Attribute Entry Form" values used to indicate Procedure Code. Please check Appendix C  ^BCH-0903: PROCEDURE.PROCEDURE_CODE is invalid. "[PROCEDURE.ID = ' 8PROCEDURE.PROCEDURE_CODE = '0BUM6NQkheB:^>`lJjLYExR*OsߒL 4Ӊtd_jK^NՑ_}A6w>g5PvrxRIor xvI랖7] o1A6 :BkJ@ZD򺀬ig:4MOMeLabel86Label81Text82Text84Text85]H3I!6@UGTs0ןPNI0ҖDuD"*1W(LqõQ4Ʃ4G W[dIFB ^TXHkG]1Combo86Label87Combo88Combo90Label91Text92Label95Text96Text98 ЦAx)>'d<"@GgҼwH;KOPQ'žHX@,J۬}U}FrJ{@DCAText104^iO&$W/PWL<J  L]˘A[J4|<AtJ; jٯGDO-1bDqPr=x)ܚ@FfJ氓 SSJVsOړO( @ 6't-?KUKK"$tM[pln2F6/ !Form_11) Organization Role AssignForm_10) Telephone1Form_12) Person Role Assign "Form_11) Organization Role Assign1񛴵CukȓdLbNtDOY&gMN&MWk q